Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid
 
PerlMonks  

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

by dasgar (Curate)
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

Replies are listed 'Best First'.
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 all is quiet...

How do I use this? | Other CB clients
Other Users?
Others browsing the Monastery: (3)
As of 2016-12-10 23:18 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    On a regular basis, I'm most likely to spy upon:













    Results (166 votes). Check out past polls.