Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
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 the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others taking refuge in the Monastery: (12)
As of 2015-07-28 22:30 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (260 votes), past polls