cover all the bases, but it's hard to
anticipate everything someone might throw in a formfield.
Rick
> -Original Message-
> From: Eric Roberts [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 07, 2006 11:29 PM
> To: CF-Talk
> Subject: RE: Ok, I give...how can I do this
nual hehehehe)
Eric
-Original Message-
From: Dawson, Michael [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 07 March 2006 08:23
To: CF-Talk
Subject: RE: Ok, I give...how can I do this...
I would use a regular expression to remove *all* non-numeric characters.
Then, check to see if the remainder is nu
: Tuesday, March 07, 2006 10:56 AM
> To: CF-Talk
> Subject: RE: Ok, I give...how can I do this...
>
>
> So, basically, what you're saying (besides "upgrade!" :o),
> is that it can't be done with any combination of CFIF statements...right?
>
> I
> So, basically, what you're saying (besides "upgrade!" :o),
> is that it can't be done with any combination of CFIF
> statements...right?
> I'm trying to figure out if I'm just continuing to beat a
> dead horse...
Nope. Unfortunately because LSParseNumber() throws an error on any
value it can't
ley [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 07, 2006 10:08 AM
> To: CF-Talk
> Subject: RE: Ok, I give...how can I do this...
>
>
> > CFIF Len(Trim(Form.Dollar_Amount)) and Not
> > IsNumeric(LSParseNumber(Form.Dollar_Amount))
>
> > - Now why d
06 9:53 AM
> To: CF-Talk
> Subject: RE: Ok, I give...how can I do this...
>
>
> CFLib to the rescue...
>
> http://www.cflib.org/udf.cfm?ID=433
>
> M!ke
>
> -Original Message-
> From: Rick Faircloth [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 07,
> CFIF Len(Trim(Form.Dollar_Amount)) and Not
> IsNumeric(LSParseNumber(Form.Dollar_Amount))
> - Now why didn't this work? Oh, now I remember...a junk
> entry like, asdflkj, can't
> be parsed by LSParseNumber and throws a CF error...
Oh yeah, sorry... I forgot that the behavior
CFLib to the rescue...
http://www.cflib.org/udf.cfm?ID=433
M!ke
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 07, 2006 8:51 AM
To: CF-Talk
Subject: RE: Ok, I give...how can I do this...
Sounds good...since I can't write RegEx's, coul
Sounds good...since I can't write RegEx's,
could you whip one up for me without too
much trouble?
Rick
> -Original Message-
> From: Dawson, Michael [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 07, 2006 9:23 AM
> To: CF-Talk
> Subject: RE: Ok, I give...how c
: CF-Talk
Subject: RE: Ok, I give...how can I do this...
Thanks for the tip, Josh...yet another way I'll have to validate an
entry. Maybe it's just easier to let them make an illegal entry, then
tell them how I want them to enter the data than try to catch all the
possible violations...
be I've
been working on it too long for now...
Rick
> -Original Message-
> From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 07, 2006 12:35 AM
> To: CF-Talk
> Subject: RE: Ok, I give...how can I do this...
>
>
> Nope, comma's never b
w*
> bug in CF7...I'm still using 4.5.2! :o)
> Rick
>> -Original Message-
>> From: Eric Roberts
>> [mailto:[EMAIL PROTECTED]
>> Sent: Monday, March 06, 2006 10:30 PM
>> To: CF-Talk
>> Subject: RE: Ok, I give...how can I do this...
>&g
hat?
(Couldn't find that example in my dog-eared copy
of CF Application Kit for 4.0 published in 1998 by
somebody named "Forta"... :o)
Rick
> -Original Message-
> From: Mike Kear [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 06, 2006 10:00 PM
> To: CF-Talk
>
I have to snicker at the irony of this being a *new*
bug in CF7...I'm still using 4.5.2! :o)
Rick
> -Original Message-
> From: Eric Roberts [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 06, 2006 10:30 PM
> To: CF-Talk
> Subject: RE: Ok, I give...how can I do this
I didn't have any instructions either way. The only formatting I was using
was with decimalformat so that we would have a number with 2 decimal places.
CF put the comma there and then refused to recognize it as a number.
Eric
~
I think it should. I have been having similar probs lately with CF7 where
numbers that have commas in them are viewed as strings. I don't ever
remember having this prob with previous versions...is this a new bug in 7?
Eric
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTE
i hate to keep on beating a dead horse, but in CFMX7, you just use http://afpwebworks.com
ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month
On 3/7/06, Rick Faircloth <[EMAIL PROTECTED]> wrote:
>
> What would be the best way to strip out
> any content a person might enter besides
> numerals,
March 06, 2006 7:46 PM
> To: CF-Talk
> Subject: Re: Ok, I give...how can I do this...
>
>
> You could do something like:
>
> IsNumeric(Replace(form.dollars, ",","","all"))
>
> That would remove any commas before applying the isNumeric tes
d I run it against
IsNumeric(Replace(Form.Dollars, ",","","all")) ?
What about that dollar sign?
I'll have to see...thanks, Josh...
> -Original Message-
> From: Josh Nathanson [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 06, 2006 7:46 PM
>
Ok, what's happening here ? What is C actually calculating?
a="1,000";
b="2,000";
c=a*b;
a=#a#
b=#b#
c=#c#
This gives the following result:
a=1,000
b=2,000
c=1500206316
I'd have thought C should be 2,000,000. So what's happening instead?
Cheers
Mike Kear
Windsor, NSW
k Faircloth" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Monday, March 06, 2006 4:27 PM
Subject: RE: Ok, I give...how can I do this...
> Seems like I'll just have to give formatting instructions
> not to put any commas in a field...on numerals.
>
> But that'
ginal Message-
> From: Rick Faircloth [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 06, 2006 7:13 PM
> To: CF-Talk
> Subject: RE: Ok, I give...how can I do this...
>
>
> You know...I tried using IsNumeric(Val(Form.Dollars)),
> but found it was identifying a field entry of "
dation (which is what I'm working on here...
trying to validate an entry as a valid dollar entry.
Rick
> -Original Message-
> From: Mike Kear [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 06, 2006 7:00 PM
> To: CF-Talk
> Subject: Re: Ok, I give...how can I do this...
&g
No. numeral 1, comma, zero zero zero is a text string. But if you want to
make it a numeric value you can use #val("1,000")# . The val() function
attempts to make a number out of whatever is in the string submitted to it.
Cheers
Mike Kear
Windsor, NSW, Australia
Certified Advanced ColdFusion
24 matches
Mail list logo
