Rob wrote: > > 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?
Try single or double quotes around your varilables, IE.. CustNo = '$custNo', PIN = '$pin' or read up on placeholders. -- Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Bus Phone: 1(985)902-8484 Cellular: 1(985)320-1191 Fax: 1(985)345-2419 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
