in reply to Re^2: DBI question
in thread DBI question

It was a problem with SQL and not a perl problem. Doubling up the single quotes solved the problem.
Thanks for you help

Replies are listed 'Best First'.
Re^4: DBI question
by jZed (Prior) on Mar 11, 2005 at 15:10 UTC
    SO, in other words, you completely ignored our advice. DO NOT HANDLE QUOTING YOURSELF. You are certain to get into trouble eventually either through SQL injection attack or through missing something that should have been escaped. Use placeholders.