Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling
 
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?
[thezip]: It seemed so, choroba, but I don't want to confuse anyone (especially myself!)
[choroba]: thezip unless something like this happens to you.
[thezip]: I don't intend on doing any offline development in the Czech Republic soon, so i think I'm safe!
[thezip]: :-)
[choroba]: Yeah, there are countries with wifi everywhere
[choroba]: also, I didn't have a smart phone at that time

How do I use this? | Other CB clients
Other Users?
Others examining the Monastery: (7)
As of 2017-03-23 21:06 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Should Pluto Get Its Planethood Back?



    Results (294 votes). Check out past polls.