Strahan Posted May 29, 2010 Share Posted May 29, 2010 This is aggravating the heck out of me. I made a web based checkbook so I can update it on the fly with my BlackBerry. The table has an "amount" field that I set to double. This is one record: Now when I go to do a select to find it by amount, I get this: Nothing. ??? Does this have something to do with having used double? I don't understand why it's failing to find it. Quote Link to comment Share on other sites More sharing options...
PFMaBiSmAd Posted May 29, 2010 Share Posted May 29, 2010 You should be using DECIMAL data type - http://dev.mysql.com/doc/refman/5.0/en/problems-with-float.html Quote Link to comment Share on other sites More sharing options...
Strahan Posted May 29, 2010 Author Share Posted May 29, 2010 Thanks! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.