Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot
 
PerlMonks  

Re^3: DBD::CSV - SQL Syntax - "AND" clause is not working properly

by marto (Chancellor)
on Aug 28, 2012 at 11:31 UTC ( #990220=note: print w/ replies, xml ) Need Help??


in reply to Re^2: DBD::CSV - SQL Syntax - "AND" clause is not working properly
in thread DBD::CSV - SQL Syntax - "AND" clause is not working properly

When posting please provide an example which you are actually running, not doing this potentially wastes peoples time, posting unrelated code and a made up problem. I've provided a working example based on your csv file and the query you ran. Stop using variables like this, read and understand 'Placeholders and bind values' from the DBI documentation and never ever forget the ballad of Little Bobby Tables. SQL_injection.


Comment on Re^3: DBD::CSV - SQL Syntax - "AND" clause is not working properly
Re^4: DBD::CSV - SQL Syntax - "AND" clause is not working properly
by slayedbylucifer (Scribe) on Aug 28, 2012 at 11:41 UTC

    I understand your concern. But i cannot post the actual code as it has company sensitive information and will take me a day to edit that info from the code. so I always duplicate it with the test code and example and then only post it on the forum.

    thanks for your time.

      See How do I post a question effectively?, post a short example containing only code which contains no sensitive data which recreates the problem you're experiencing. Clearly on this occasion you didn't even run the test code you posted, never mind the fact that it wasn't even representative of the problem you were actually having. For the sake of existing replies, consider marking updates to your post if required (I notice you've added the semicolon).

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://990220]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others about the Monastery: (7)
As of 2014-11-28 17:31 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My preferred Perl binaries come from:














    Results (199 votes), past polls