I'd tried selecting
WHERE Age > 0
AND Age < 99
But this still gave me things like '50+'
"Stephen Pope"
<[EMAIL PROTECTED] To: <[EMAIL PROTECTED]>
rv.org.uk> cc:
Subject: RE: [ cf-dev ] MySQL
Select Numeric
25/08/2004 15:32
Please respond to
dev
You could try selecting where Age is greater than 0 .. That should give
you a number (in theory not tried it)
The RegExp one will work too (but can be a little 'expensive' if you are
doing a lot of queries.
e.g.
SELECT * FROM Ages WHERE Age 0 > 0;
Regards
Stephen
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: 25 August 2004 14:56
To: [EMAIL PROTECTED]
Subject: [ cf-dev ] MySQL Select Numeric
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]
