website.
I adjusted my first query to use IS NOT NULL, but still get the error.
<cfquery name="temp" dbtype="query">
select *
from variables.listings.qResults
where price IS NOT NULL
AND beds IS NOT NULL
AND baths IS NOT NULL
</cfquery>
-----Original Message-----
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Monday, April 05, 2004 11:15 AM
To: CF-Talk
Subject: RE: Query of Query Error
> Ok, I queried the original query to get only rows which had
> numeric values for price, beds, baths... Then, I queried the
> new query. I get the same error.
>
> <cfquery name="temp" dbtype="query">
> select *
> from variables.listings.qResults
> where price <> ''
> AND beds <> ''
> AND baths <> ''
> </cfquery>
>
> <cfquery name="qResults" dbtype="query"> select * from
> temp where price between 1 AND 9999999
> AND beds >= 0
> AND baths >= 0
> </cfquery>
Are PRICE, BEDS and BATHS numeric columns within the database? In the
first
query, you're treating them as if they aren't, but in the second, you're
treating them as numeric.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
