cool, although i decided to go with my loop instead of the regex (might
even be faster?). this way i can append the non-numeric ones to a seperate
list for display on their own.
ta
"Fiaz Khan"
<[EMAIL PROTECTED] To: <[EMAIL PROTECTED]>
world.com> cc:
Subject: RE: [ cf-dev ] MySQL Select
Numeric
25/08/2004
15:20
Please respond
to dev
Try this
SELECT Age FROM Ages WHERE (Age REGEXP ('^[0-9]+'));
I havent tried it but it looks like it might work. :)
> Any way in MySQL to select rows where a value is or can be converted to a
> number?
>
> sort of like:
>
> SELECT Age
> FROM Ages
> WHERE IsNumeric(Age)
>
> My best workaround so far seems to be just do the select as normal, then
> loop through the list, removing rows where "NOT IsNumeric(query.Age)".
>
>
> --
> These lists are syncronised with the CFDeveloper forum at
http://forum.cfdeveloper.co.uk/
> Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
>
> CFDeveloper Sponsors and contributors:-
> *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF
provided by activepdf.com*
> *Forums provided by fusetalk.com* :: *ProWorkFlow provided by
proworkflow.com*
> *Tutorials provided by helmguru.com* :: *Lists hosted by
gradwell.com*
>
> To unsubscribe, e-mail: [EMAIL PROTECTED]
>
--
These lists are syncronised with the CFDeveloper forum at
http://forum.cfdeveloper.co.uk/
Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided
by activepdf.com*
*Forums provided by fusetalk.com* :: *ProWorkFlow provided by
proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted by
gradwell.com*
To unsubscribe, e-mail: [EMAIL PROTECTED]
--
These lists are syncronised with the CFDeveloper forum at
http://forum.cfdeveloper.co.uk/
Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by
activepdf.com*
*Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com*
To unsubscribe, e-mail: [EMAIL PROTECTED]
