| SELECT query input must be integer - Atom8 - Jan 08, 2008 2:20pm | | Tips & Tricks @ Technology / Computers / Progamming Languages / Perl - Views (9674) - Ratings(1): ( 1.00 ) | This is an example of an unusual syntax error for no obvious reasons. The DBI keep returning error string as a syntax error in the last element of the query string 'limit ?'.
1) The calling CGI code:
...
myFunc(param('itemCounts'));
...
2) The Perl library function:
sub myFunc {
my $limit = shift @_;
my $dbh = connectMyDB();
my $sth = $dbh->prepare('SELECT * from myProducts order by itemID DESC limit ?') or return die 'Unable to set handle.';
$sth->execute($limit) or print $sth->errstr;
...
}
---------------------------
This will ALWAYS cause a syntax error when $sth->execute() is called.
---------------------------
3) The Fix:
Modify to have $sth->execute(int($limit)) . The SELECT query was expecting type integer and param('itemCounts') in the CGI context returned as strings/text value.Last Edit: Jan 08, 2008 10:21pm - by Atom8  |  |
|
| Tips & Tricks | Recent Posts | The Invincible CELL Soldier in Crysis 2 - An Easter Egg?
:: Atom8 - Feb 13, 2012 3:45am
Inside Out of the Samsung Infuse 4G
:: Atom8 - Feb 03, 2012 4:31am
Update FW to 2.3.4 Gingerbread for T-Mobile Vibrant (Samsung Gal...
:: Atom8 - Jul 10, 2011 3:41pm
iPhone 3G with 4.2.1 iOS and 05.15.04 baseband jailbreak & unloc...
:: Atom8 - Jul 10, 2011 3:22pm
Methods to Set the Samsung Galaxy S 4G to Download Mode
:: Atom8 - Jun 24, 2011 6:43pm
Saab 92x Ecopower engine ignition coils
:: TwinsAuto - Jul 16, 2008 5:34pm
Free Serial port - RS232 Data Logger
:: Atom8 - Apr 21, 2008 3:14pm
Timing chain tensioner removal on Benz 560SL 1986
:: TwinsAuto - Jan 19, 2008 4:52pm
SELECT query input must be integer
:: Atom8 - Jan 08, 2008 2:20pm
MacOSX 'smbclient' command connects to WinXP PC
:: Atom8 - Dec 15, 2007 10:26pm
| | Most Viewed | | Most Commented | | Top Rated |
|
