"NOTE: When dealing with real numbers it might be advisable to either
convert the real number to an integer if possible. For example if you are
dealing with decimal currency, it may be preferable to work in units of
cents rather than dollars - note that mSQL 2.x now has a MONEY type which
handles this concept - or to perform some sort of delta check when
retrieving values." Ref#: 970722-0018
More info at the following link below.
http://support.hughes.com.au/cgi-bin/hughestester?solution&11-970722-0018&13
0-869608757&14-0&2715-0&15-0&2716-0&57-search&58-console&25-6&3-decimal
Michael
> -----Original Message-----
> From: Michael Murphy [SMTP:tnetzley@worldnet.att.net]
> Sent: Monday, December 13, 1999 1:57 PM
> To: msql-list
> Subject: $Money data type
>
> Hello everyone,
>
> I cannot find any documentation/examples on the $MONEY data type and have
> several questions.
>
> Using an input form with a field declared as $MONEY is it possible for the
> user to input the currency sign ($) ?
> What about commas ($100,000)?
>
> Or is it suggested to force the user to just enter a "pure" integer OR let
> them enter it in any style then manipulate the value to get it the way you
> want?
>
> I'm using version 2.0.4.1 on Pentium Dual Pro machines running Apache 1.34
> over Linux 2.0.
>
> Thanks
> Mike
>
>
> -------------------------------------------------------------------------
> To unsubscribe, go to http://www.Hughes.com.au/extras/email/
-------------------------------------------------------------------------
To unsubscribe, go to http://www.Hughes.com.au/extras/email/
This archive was generated by hypermail 2b30 : Mon Mar 04 2002 - 09:04:03 EST