Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Re: PREPARE -> EXEC Problem


  • From: Chris <dmagick(at)gmail(dot)com>
  • To: "F." <dev001(at)pas-world(dot)com>
  • Cc: pgsql-php(at)postgresql(dot)org
  • Subject: Re: PREPARE -> EXEC Problem
  • Date: Thu, 15 Jan 2009 15:40:48 +1100
  • Message-id: <496EBE50.5010109@gmail.com> <text/plain>

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/




Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group