On Monday 24 February 2003 20:22, Karl Stubsjoen wrote: > I am reporting a bug. The format number function fails when a query is > sorted. I have included an example page to look at (the error is > reproduced here): > http://www.meetscoresonline.com/test_format.asp > > You'll see there are 2 result sets, the first is not ordered and the 2nd is > ordered. In the first example, the format function indeed works, but not > in the 2nd. > > Is this indeed a bug, or something I am doing wrong? > > > MySQL Version: 4.0.0-alpha
I tested and FORMAT() worked as expected. Could you upgrade MySQL server and test it on the latest version? 4.0.0 is a bit outdated. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- 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