insert query fails w/ postgres database
| From: | Javier Montserat | Date: | Thu, 22 Aug 2002 14:45:43 +0000 |
| Subject: | insert query fails w/ postgres database | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-113616@lists.php.net to get a copy of this message | ||
Hello PHP people...
I'm trying to insert a filename (string) into a postgres database field but the insert query is failing -
Warning: pg_exec() query failed: ERROR: oidin: error in "abc_abcde012_010_mpeg1.mpeg": can't parse "abc_abcde012_010_mpeg1.mpeg"
in /usr/local/apache/htdocs/filename.php on line 835
Here's the query -
$addFileResult = pg_exec($db->db, "INSERT INTO files(filename,type,size,uploaded) VALUES ('$this->uploadedFileName','$this->uploadedFileType','$this->uploadedFileSize','now'::datetime)");
Table looks like this -
CREATE TABLE "files"
(
"filename" oid,
"type" varchar(30),
"size" int,
"uploaded" datetime
);
Any Ideas?
Saludos,
Javier
_________________________________________________________________
MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx