Paul Hastings wrote:
(say user is bidding $1,000.00)
$1,000.00
$1,000
$1000
1,000.00
1,000
1000
use currency datatype on the backend.
I would have said Don't use currency on the backend because it is not
an official datatype, but since you are using Access the correct
alternative, using
To: CF-Talk
Subject: best way to enter currency format
in this auction app i cant find a reasonable solution for the
handling of the bids. I have been sitting here messing with a
lot of the tags and it seems to me that they are very
dependant on how the info was entered. With of course
it'll clear
most things out of your number.
Regards
Stephen
- Original Message -
From: Everett; Al [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, February 14, 2003 2:18 PM
Subject: RE: best way to enter currency format
On input, I would get all of the numbers
: Re: best way to enter currency format
Paul Hastings wrote:
(say user is bidding $1,000.00)
$1,000.00
$1,000
$1000
1,000.00
1,000
1000
use currency datatype on the backend.
I would have said Don't use currency on the backend because it is not
an official datatype, but since you
in this auction app i cant find a reasonable solution for the handling of the bids. I
have been sitting here messing with a lot of the tags and it seems to me that they are
very dependant on how the info was entered. With of course means that i need to format
it going into the db and possibly
(say user is bidding $1,000.00)
$1,000.00
$1,000
$1000
1,000.00
1,000
1000
use currency datatype on the backend. strip out any $ , from form
input. use dollarformat or whatever to display.
~|
Archives:
-Talk [EMAIL PROTECTED]
Sent: Friday, February 14, 2003 1:17 AM
Subject: Re: best way to enter currency format
(say user is bidding $1,000.00)
$1,000.00
$1,000
$1000
1,000.00
1,000
1000
use currency datatype on the backend. strip out any $ , from form
input. use dollarformat
not sure how to strip out the non numbers from the form field?
do u off hand know of any articles or tuts on it??
This will strip out anything but numbers and periods. You will probably
want to also test for multiple periods before inserting, and possibly the
number of digits after the period
This will strip out anything but numbers and periods. You will probably
want to also test for multiple periods before inserting, and possibly the
number of digits after the period as well to ensure valid data.
and might as well handle some of this on your input form with either cfform
or some
and might as well handle some of this on your input form
with either cfform or some js validation.
Personally, I never rely on JavaScript for validating input unless I know
that the application will only be used in a semi-controlled environment,
such as an Intranet where browsers are
10 matches
Mail list logo