insert query fails w/ postgres database

From: 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

« previous php.general (#113616) next »