I hear that you've moved on, and fair enough, but in case it helps others, you said, "I did verify the form.fieldname output by observing what was inserted to the database that it uses."
I would challenge that testing what got inserted into the DB would not be proof of what I was asking for. The DB could have permitted/converted the number to something different than what came in. I meant to assert that you test exactly what is coming from the form (because you were referring to an isvalid test in CFML). I see that you also now refer to CF's client-side validation, because you looked into the js file it uses. Again, fair enough. All different things. As for the scenario I mentioned above, with some DBs a currency format will accept entries with or without a $, but what it stores internally obviously is just a number. This may well be part of the confusion you're seeing, if some validation methods had to accomadate this factor. Just sharing thoughts from a brain to be "picked". :-) /charlie From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Troy Jones Sent: Wednesday, March 04, 2009 2:55 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] isValid and validate="integer" For now, I have implemented a server side workaround to fix the issue using REreplace(). It just seemed inconsistent to me that "integer" would not validate only "integral" data. Charlie, I did verify the form.fieldname output by observing what was inserted to the database that it uses. It did indeed have the "$" character in the data. What I was looking into and wasn't able to come to a good enough conclusion to determine anything was the /inetpub/wwwroot/cfide cfform.js. It appeared that the _cf_checkinteger() function was actually stripping the "$" character before providing a return value. I also found that confusing. Isn't the point of determining a data type to see if it is actually that data type and not strip it and manipulate it first? Maybe this is where I am missing the boat, if indeed I am missing the boat. Anyways, like I said, I have moved on with my own workaround for now. I was really just picking brains for experience on the matter. Troy Jones Dynapp Support Team 678-528-2952 ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------