Re: best way to enter currency format

2003-02-14 Thread Dave Lyons
riday, February 14, 2003 5:30 AM Subject: 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 > > > > >

Re: best way to enter currency format

2003-02-14 Thread Stephen Moretti
egards Stephen - Original Message - From: <"Everett>; > 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 to a consistent format. > > First, I would

RE: best way to enter currency format

2003-02-14 Thread AEverett
On input, I would get all of the numbers to a consistent format. First, I would remove $ and , Then if there was anything left besides numbers and a . I'd throw an exception. Probably the easiest thing for that is ... error code ... If all passes, then put that value in the databas

Re: best way to enter currency format

2003-02-14 Thread Jochem van Dieten
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 alt

Re: best way to enter currency format

2003-02-13 Thread Justin Scott
> 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 standardi

Re: best way to enter currency format

2003-02-13 Thread paul
> 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 so

Re: best way to enter currency format

2003-02-13 Thread Justin Scott
> 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

Re: best way to enter currency format

2003-02-13 Thread Dave Lyons
o: "CF-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 > > u

Re: best way to enter currency format

2003-02-13 Thread paul
> (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: http://