be using "WHERE bed is not null" not where bed <> '' (assuming the original
column is a number column).
----- Original Message -----
From: "Brad Roberts"
> 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>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
