bind params broken w/ doubles?

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@peteleonard.com

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org