in reply to SQL Statement Not Firing Correctly?

Consider DBI->quote or, even better, using SQL placeholders instead of constructing your SQL statement as a string.

Also see Bobby Tables.

Replies are listed 'Best First'.
Re^2: SQL Statement Not Firing Correctly?
by boftx (Deacon) on Nov 28, 2013 at 22:12 UTC

    I strongly second Corion's suggestions. I would only add that failing to use either (especially placeholders IMO) can lead to some serious security issues in some cases.

    It helps to remember that the primary goal is to drain the swamp even when you are hip-deep in alligators.