I would check my error logs, the error indicates that the statement handle was not created. Increase your debug level if you are not seeing a DBI error in the logs.
Don Shanks Senior Applications Systems Engineer Cell Systems Initiative - University of Washington [EMAIL PROTECTED] -----Original Message----- From: Nigel Peck [mailto:[EMAIL PROTECTED]] Sent: Friday, 12 July, 2002 09:18 To: Nigel Peck; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: esql error I'm getting the following error Can't call method "finish" on an undefined value at C:/Perl/site/lib/AxKit/XSP/ESQL.pm line 32. When I run this code my $update_string = 'UPDATE itm_telephone_datab SET Company_Name="Test2" WHERE Record_Number="4555";'; <xsp:content> <esql:connection> <esql:driver transactions="no">mysql</esql:driver> <esql:dburl>SalesDB</esql:dburl> <esql:execute-query> <esql:query><xsp:expr>$update_string</xsp:expr></esql:query> </esql:execute-query> </esql:connection> </xsp:content> The query works fine if I put it straight into MySQL. Any ideas? Thanks Nigel ITM Business Solutions Unit 4 Nine Trees Trading Estate Morthen Road Rotherham S66 9JG Reception Tel: 01709 703288 Fax: 01709 701549 Help Desk Tel:01709 530424 Fax: 01709 702159 CONFIDENTIALITY NOTICE: This message is intended only for the use of the individual or entity to which it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
