"be consistent" | |
PerlMonks |
comment on |
( [id://3333]=superdoc: print w/replies, xml ) | Need Help?? |
Hi, in general it's a bad idea to build SQL by hand like that. As you have found, you quickly run into complications with quoting, special characters, etc. At a minimum you should build the SQL statement with "placeholders" and "bind values" (look for those terms in the DBI docs). But your life may be made easier if you use SQL::Abstract or SQL::Abstract::More. Hope this helps!
The way forward always starts with a minimal test.
In reply to Re: Handling delimiters
by 1nickt
|
|