On Fri, 12 Jul 2002, Nigel Peck wrote: > 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?
You have to have some sort of result section, otherwise it doesn't even execute the query (yeah, I know it's a bit confusing - if you can fix it patches are very welcome ;-) (Note: the result section can be empty) -- <!-- Matt --> <:->Get a smart net</:-> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
