|
|
|
|
|||||||
| Forums | Portal | Register | Forum Rules | FAQ | Contribute | Members List | Arcade | Search | Today's Posts | Mark Forums Read |
| Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts here. |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Perl - PostGreSql query | garric | UNIX and Linux Applications | 0 | 06-01-2008 12:17 AM |
| Query in perl | Dana Evans | UNIX for Dummies Questions & Answers | 2 | 11-21-2007 07:27 PM |
| perl query | bishweshwar | Shell Programming and Scripting | 1 | 04-30-2007 06:03 AM |
| Perl CGI Query | pondlife | Shell Programming and Scripting | 4 | 06-08-2006 06:28 PM |
| Query string assingment for other variable in PERL | maheshsri | Shell Programming and Scripting | 0 | 01-30-2006 12:45 AM |
 |
|
|
Submit Tools | LinkBack | Thread Tools | Display Modes |
04-04-2006
|
|||
|
|||
|
Incorrect SQL query in perl
I the the following perl script, however it does not return anything. Did i form my syantax wrongly?
Code:
$sth=$dbh->prepare("select a.rowid,a.* from Table1 a
where a.field1 = \'$Indicator1\'
and a.schedule = \'$Indicator2\' and a.lastdate <= sysdate");
$sth->execute()
Code:
$sth=$dbh->prepare("select a.rowid,a.* from Table1 a
where a.field1 = 'Valid'
and a.schedule = 'Y' and a.lastdate <= sysdate ");
$sth->execute()
Indicator1 and indicator2 are not supposed to be hardcoded. 
|
| Forum Sponsor | ||
|
|
Linear Mode
