Re: files, php & pgsql - Mailing list pgsql-php

From Dave Perkins
Subject Re: files, php & pgsql
Date
Msg-id 3.0.6.32.20001018071750.007aa450@shell1.shore.net
Whole thread Raw
In response to files, php & pgsql  (Chris <tomcat@weirdness.com>)
Responses Re: files, php & pgsql  (Chris <tomcat@weirdness.com>)
List pgsql-php
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


pgsql-php by date:

Previous
From: Chris
Date:
Subject: files, php & pgsql
Next
From: Chris
Date:
Subject: Re: files, php & pgsql