I'm terrible at regular expressions. I need what I think is an easy one. I have a field that is decimal(10,2). I have already verified that the value is of the correct precision. I now need to ensure that the actual value submitted is a whole number...aka the two digits to the right of the decimal are both zero.
So....9999999.99 would not pass, but 9999999.00 would pass. I then need a slight modification to that expression that allows for a significant digit in the tenths place, so that: 9999999.90 would pass. In both cases, a whole number should always pass (9999999.00). TIA amigos! Brian -- The suburbs have no charms to soothe The restless dream of youth ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:318825 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
