On Sat, 03 Mar 2001 19:51:04 -0500, Alec Solway <[EMAIL PROTECTED]> wrote:
Try using DECIMAL, this works best for monetary values in my experience.
>>I'm having some trouble with the following:
>>
>>I have a sample table that has one record where price == 123.54, however
>>
>>select * from gpl where price=123.54
>>
>>returns an empty set. If I set price to an integer value that's also in the
>>table, it works. e.g.
>>
>>select * from gpl where price=500
>>
>>returns the proper results. price is a column of type float.
>>
>>TIA.
>>Alec Solway
>>
>>
>>---------------------------------------------------------------------
>>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
>>
Mike(mickalo)Blezien
========================================
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225) 686-2002
=========================================
---------------------------------------------------------------------
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
