> -----Original Message-----
> From: Rob [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 15, 2002 2:24 PM
> To: [EMAIL PROTECTED]
> Subject: database update
>
>
> The following line works from a script run from the command
> line on the
> server...
>
> $sql = "UPDATE data SET CustNo = $custNo, PIN = $pin, Notes = '$notes'
> WHERE CustNo = $custNo and PIN = $pin and CustName = '$custName' and
> Serial = '$serial'";
>
> but when run from cgi I get the following error...
>
> ERROR: parser: parse error at or near ","
>
> I'm using the Pg module, any idea why it won't run from the web?
Are you dumping out $sql somewhere? Perhaps $custNo is blank, which would
give you:
UPDATE data SET CustNo = , PIN = ...
^^ syntax error here
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
