Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask
 
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 lurking in the Monastery: (5)
As of 2014-08-23 16:44 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (175 votes), past polls