Vinetop
 
Vinetop Login:

    Email/ID: Password:
**Login by Email or Nickname
Browse 
:: Browse Topic Focus
Journal
General
How-To & DIY
Tips & Tricks
Reviews
 

SELECT query input must be integer - Atom8 - Jan 08, 2008 2:20pm
Tips & Tricks @ Technology / Computers / Progamming Languages / Perl - Views (8219) - 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        Comments | Report




Comments and Ratings:( Post Your Comments )

No Comments...

Tips & Tricks

Recent Posts
Most Viewed
Unicode Viet Type Conversion for CGI using Perl
:: BanThad - Jun 04, 2007 7:50am

Saab 92x Ecopower engine ignition coils
:: TwinsAuto - Jul 16, 2008 5:34pm

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

Timing chain tensioner removal on Benz 560SL 1986
:: TwinsAuto - Jan 19, 2008 4:52pm

Free Serial port - RS232 Data Logger
:: Atom8 - Apr 21, 2008 3:14pm

MacOSX 'smbclient' command connects to WinXP PC
:: Atom8 - Dec 15, 2007 10:26pm

SELECT query input must be integer
:: Atom8 - Jan 08, 2008 2:20pm

iPhone 3G with 4.2.1 iOS and 05.15.04 baseband jailbreak & unloc...
:: Atom8 - Jul 10, 2011 3:22pm

Update FW to 2.3.4 Gingerbread for T-Mobile Vibrant (Samsung Gal...
:: Atom8 - Jul 10, 2011 3:41pm

Most Commented
Top Rated

© 2007 - 3000 vinetop.com [ Terms & Policy :: Contact Us :: About ]