STONER!!! :)
On Tue, May 18, 2010 at 11:48 AM, Chris Stoner <[email protected]> wrote: > > Try this: [0-9]{0,10}(\.[0-9][0]){0,1} > > Haven't tested it throughly, but looks like it works. At the very least > will give you a starting point. Im sure there is a more elegant way to do > it but this should be ok. Or not. > > On Tue, May 18, 2010 at 5:51 PM, G Money <[email protected]> wrote: > >> >> 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:318829 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
