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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php