> 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]
