Hi,
I'm running mysql 4.1.20 (Mac OS 10.4.11) and wondering why this ain't
returning the right answer? Maybe i'm missing something or am i doing
something wrong?
mysql> select (11.11-FLOOR(11.11))>=0.11;
++
| (11.11-FLOOR(11.11))>=0.11 |
+--
Thanks for your responses, i thought it was a float problem so i was
trying to CAST as a DECIMAL to fix it. It turns out (and the manual does
not document this) that casting as decimals doesn't actually work in
mysql 4.1.20. ROUND() is needed instead.
mysql> select ROUND(11.11-FLOOR(11.11),2)>
Hi,
I was wondering whether someone knew of the options available for
getting customer details from a MySQL db into Outlook?
Also whether it was possible to sync Outlook, so it reads it's
Address book straight from the MySQL db?
Any suggestions would be greatly appreciated,
Many thanks,
Adam
Can anyone suggest a proven method for creating a flexible directory
structure that can grow and have categories that can have multiple
parents?
Any suggestions would be greatly appreciated,
Thanks in advance,
Adam
--
// Adam de Zoete
\\ [EMAIL
