Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW
 
PerlMonks  

Re: Passing a perl variable in SQL AND statement

by clueless newbie (Chaplain)
on Nov 20, 2013 at 20:45 UTC ( #1063604=note: print w/replies, xml ) Need Help??


in reply to Passing a perl variable in SQL AND statement

This

and '$day' = 'Y';

should probably read

and $day = 'Y';

Replies are listed 'Best First'.
Re^2: Passing a perl variable in SQL AND statement
by vihar (Acolyte) on Nov 20, 2013 at 20:59 UTC
    I pretty much tried all combinations of using it without quotation marks, with ' ' and with " " and I keep getting those SQL errors.
      That was a silly mistake on my end. I took out ; and it worked. Thanks for your help!
Re^2: Passing a perl variable in SQL AND statement
by vihar (Acolyte) on Nov 20, 2013 at 20:58 UTC
    Thank you for your reply. I tried that. I still get SQL error.
    DBD::Oracle::db prepare failed: ORA-00911: invalid character (DBD ERRO +R: error possibly near <*> indicator at char 84 in 'Select * From SMSVA_SUPR.schedule_table where process_name = 'Seed' and Sunday = 'Y'<*>; ') [for Statement "Select * From SMSVA_SUPR.schedule_table where process_name = 'Seed' and Sunday = 'Y'; "] at seed_driver.pl line 93. DBD::Oracle::db prepare failed: ORA-00911: invalid character (DBD ERRO +R: error possibly near <*> indicator at char 84 in 'Select * From SMSVA_SUPR.schedule_table where process_name = 'Seed' and Sunday = 'Y'<*>; ') [for Statement "Select * From SMSVA_SUPR.schedule_table where process_name = 'Seed' and Sunday = 'Y'; "] at seed_driver.pl line 93.

      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.

        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://1063604]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others lurking in the Monastery: (3)
As of 2018-12-13 03:29 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    How many stories does it take before you've heard them all?







    Results (61 votes). Check out past polls.

    Notices?