>>>>> "PD" == Paul DuBois <[EMAIL PROTECTED]> writes:
PD> But why does it matter? MySQL will convert the strings to numbers
PD> anyway.
But according to earlier threads here, it will mess up with BIGINTs
Also it may screw up with LIMIT:
$sth = $dbh->prepare("SELECT foo FROM bar LIMIT ?,?") or die;
$sth->execute($start,$howmany);
may fail depending on how you set $start and $howmany. I got this
error the other day, where $start was the string "3" and DBI tried to
quote it, making my query look like this:
... LIMIT '3',2
and resulting in a parse error. The fix was to call
$sth->execute($start+0,$howmany+0) and then DBI did the right thing.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
