 | | | bind params broken w/ doubles? | bind params broken w/ doubles? 2005-05-13 - By Peter Leonard
Back
Mysql 4.1.11-Max
DBD::mysql 2.9006
perl 5.8.6
Entering the following query via the MySQL client works (returning 1 row):
select * from entity AS e where e.longitude=-73.974299 and
e.latitude=40.755668 ORDER BY e.entity_id ASC LIMIT 1;
(latitude and longitude are both doubles)
That same query, via DBD::mysql, also works.
However, when I use placeholders, the query returns 0 rows (the following
is logfile output):
[05/13/05 15:06:20][critical] Entity->find()
SQL: SELECT * FROM entity AS e WHERE e.longitude = ? AND
e.latitude = ? ORDER BY e.entity_id ASC LIMIT 1
[05/13/05 15:06:20][critical] Entity->find()
SQL ARGS: -73.974299, 40.755668
Note that placeholders work perfectly fine with all other columns. These
are the only two columns where doubles are used.
Any thoughts?
Thanks,
Peter
----
Peter Leonard
pete@(protected)
--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=mysql@(protected)
|
|
|