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
[email protected]

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]