Check what you are trying to do in the SQL. You are setting CustNo = $custNo and PIN = $pin WHERE they already have those values. This is not causing your parser problem, but it might be a source of confusion.
Cheers, Jim -----Original Message----- From: Bob Showalter [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 4:29 PM To: 'Rob'; [EMAIL PROTECTED] Subject: RE: database update > -----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]
