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]

Reply via email to