http://www.perlmonks.org?node_id=241166


in reply to Mysql module

I corrected the function and selected the field. I removed the function entirely. Either way I get the same error. I can't print the query out because the entire script fails and sends the error to the log files.

Replies are listed 'Best First'.
Re: Re: Mysql module
by Cabrion (Friar) on Mar 12, 2003 at 12:03 UTC
    You are not escaping some meta characters in your $var. Do a  $var = $dbh->quote($var); before you build the SQL. See my earlier post.