Re: files, php & pgsql

From: Dave Perkins <drp(at)shore(dot)net>
To: Chris <tomcat(at)weirdness(dot)com>
Cc: pgsql-php(at)hub(dot)org
Subject: Re: files, php & pgsql
Date: 2000-10-18 12:17:50
Message-ID: 3.0.6.32.20001018071750.007aa450@shell1.shore.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-php by date

  From Date Subject
Next Message Dave Perkins 2000-10-18 12:38:52 Re: files, php & pgsql
Previous Message Chris 2000-10-18 10:45:58 files, php & pgsql