Thanks Stone man.
On Tue, May 18, 2010 at 10: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:318831
Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
