Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical
 
PerlMonks  

Re^3: Passing a perl variable in SQL AND statement

by dasgar (Deacon)
on Nov 20, 2013 at 21:06 UTC ( #1063610=note: print w/ replies, xml ) Need Help??


in reply to Re^2: Passing a perl variable in SQL AND statement
in thread Passing a perl variable in SQL AND statement

Based on what the error message is complaining about, I'd recommend that you try to remove the semi-colon at the end of the SQL statement.

Also, I don't know where your variable will be getting it's values from, but you might want to check out Little Bobby Tables for info about preventing SQL injection issues.


Comment on Re^3: Passing a perl variable in SQL AND statement
Re^4: Passing a perl variable in SQL AND statement
by vihar (Acolyte) on Nov 20, 2013 at 21:18 UTC
    That was a silly mistake on my end. I took out ; and it worked. Thanks for your help!

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (10)
As of 2014-10-20 13:32 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    For retirement, I am banking on:










    Results (76 votes), past polls