Re: files, php & pgsql

[Dave Perkins <drp(at)shore(dot)net>]

Chris,

I ran a quick test and got the following error: "PostgresSQL query failed:
ERROR:  parser: parse error at or near "
"

If the following is how the code is actually formated:

>$sql = "insert into images (picnum, image) values 
>(nextval('images_picnum_seq'), '$loid')";

it might be the source of the problem.

Putting the quoted string all on one line as in:

$sql = "insert into images (picnum, image) values
(nextval('images_picnum_seq'),'$loid')";

eliminates this error.

Hope this helps . . .

Cheers,
Dave