Hi,
My CF query script isn't bringing up the same result in Access, and I think it's the way zeroes are handled that's the problem.
My Access query has three query fields - two for text and one for a number range when the number is >=0 And <=2.9
Access brings a result of 16. CF brings a result of 42!
-
<cfquery name="KWBand1S" dbtype="query">
-
select ClientFK,
-
ResponseLevelFK,
-
PowerRating
-
from getPumps
-
where ResponseLevelFK like 'Standard'
-
and (PowerRating >=0
-
and PowerRating <=2.9)
-
</cfquery>
If I change the query to
- ResponseLevelFK like 'Standard'
-
and (PowerRating >0
-
and PowerRating <=2.9)
(ie change >=0 to >0.
Then it brings up 16. But I'm not sure then that is doing the same thing as my Access query...
Can anyone help?
Cheers
Neil
