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:318828
Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
