in reply to Re: DBI - check erroneous statement?
in thread DBI - check erroneous statement?

Ok, but that gives me only a hint of where the problem can be ("check the manual that corresponds to your MySQL server version for the right syntax to use near"). Is it possible to see the entire statement?

Replies are listed 'Best First'.
Re^3: DBI - check erroneous statement?
by marto (Cardinal) on Nov 19, 2010 at 16:18 UTC

    DBD::Oracle displays the SQL and points out where it thinks the error is. Perhaps look at DBD::mysql (search for RaiseError => 1) or the DBI documentation on Tracing.

Re^3: DBI - check erroneous statement?
by mje (Curate) on Nov 19, 2010 at 17:54 UTC

    Can't you just examine $sth->{Statement}? See Statement