Query Of Queries runtime error.
Unsupported type comparison.
Here's my code:
----------------------------------------
<cfquery name="qResults" dbtype="query">
select *
from variables.listings.qResults
where price between 1 AND 9999999
AND beds >= 0
AND baths >= 0
</cfquery>
----------------------------------------
The query I'm querying looks like this:
----------------------------------------
street price beds baths
123 Some Street 249900 3 2
501 Another St. 189000 [empty string] [empty string]
710 Third St. 95000 2 1
----------------------------------------
Would the empty strings have anything to do with it? If so, is there a
workaround?
Thanks,
Brad
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
