> 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 of LSParseNumber() is ...
horrific...
It would be _MUCH_ better for it to return an empty string than to
throw an error, but I digress...
<cftry>
<cfif len(trim(form.dollar_amount)) and
not isNumeric(LSParseNumber(trim(form.dollar_amount)))>
<cfthrow type="validation" message="not a number">
</cfif>
<cfcatch>
... do some stuff with the bad number information ...
</cfcatch>
</cftry>
Here's a good reason to upgrade. :) If you were using a more recent
version of CF (specifically MX or later) you could put this try-catch
block into a custom function so that you wouldn't have to repeat it
for each field you wanted to validate.
Note that I trim the form value before executing LSParseNumber() -- I
suspect that white space before or after the number may also cause an
error on an otherwise valid number, so it's probably better to just
trim it to be sure.
> CFIF Len(Trim(Form.Dollar_Amount)) and Not
> IsNumeric(LSParseNumber(Val(Form.Dollar_Amount)))
> - Worked for entries like 1,000 but didn't work with junk
> entries, like
> sldifjo,
> because I think Val created a value of 0 for the string
Yep, it does. Val() in general is probably most useful for performing
math with query data when the column might contain a null.
s. isaac dealey 434.293.6201
new epoch : isn't it time for a change?
add features without fixtures with
the onTap open source framework
http://www.fusiontap.com
http://coldfusion.sys-con.com/author/4806Dealey.htm
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234433
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
