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

Reply via email to