> 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?
I suspect that's the problem.
> If so, is there a workaround?
Try placing zeroes in there, when you build your original query.
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]
