Re: PREPARE -> EXEC Problem - Mailing list pgsql-php

From Chris
Subject Re: PREPARE -> EXEC Problem
Date
Msg-id 496EBE50.5010109@gmail.com
Whole thread Raw
In response to PREPARE -> EXEC Problem  ("F." <dev001@pas-world.com>)
List pgsql-php
F. wrote:
> Hello,
> I'm trying to execute a query with a DEFAULT value for primary key value
> but do not work.
>     pdo->prepare("INSERT INTO "Table" ("id","colum") VALUES(?,?)");
>     $arr=('DEFAULT','helloworld');
> Result of PDO is "not valid value for integer".
> Anyone know, How assign DEFAULT value in pdo->exec($arr)?

I would have guessed there'd be a constant defined for it
(http://au2.php.net/manual/en/pdo.constants.php) but can't see anything.

Can you not include the column in the query? then the db will
automatically use the default value.

--
Postgresql & php tutorials
http://www.designmagick.com/


pgsql-php by date:

Previous
From: "F."
Date:
Subject: PREPARE -> EXEC Problem
Next
From: "F."
Date:
Subject: Re: PREPARE -> EXECUTE Problem