Re: PREPARE -> EXEC Problem

Chris <[email protected]> Thu, 15 Jan 2009 15:40:48 +1100
Newsgroups gmane.comp.db.postgresql.php
Message-ID <[email protected]>
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/


-- 
Sent via pgsql-php mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-php