Webmaster Forum / ColdFusion / Getting Started / November 2007

hi, i am doing a query in which i am deriving the results from the database as:

SELECT properties_details.property_unique_name, cityname as dCity,
    Subdivion_name as sub_name,  
    property_type_name as ptname  
    FROM properties_details
    INNER JOIN cities ON
    cities.cities_id =  properties_details.city_id
    INNER JOIN cities_subdivision ON
    cities_subdivision.sub_id = properties_details.sub_id
    INNER JOIN properties_types ON properties_types.ptype_id =
properties_details.ptype_id
    WHERE city_id =
  <cfqueryparam cfsqltype="cf_sql_integer" value="#url.detailsID#">

ok now when i reach the page where the query is executed,

what i need is split between the two types of properties, residential and
commercial, u will see the sub_id in the above query..

so on the page i do it loike this:

<cfif all.sub_id EQ 1>
         <cfoutput query="all">
         <tr>
             <td>#currentrow#</td>
            <td>#property_unique_name#</td>
            <td>#dcity#</td>
            <td>#ptname#</td>
            </tr>
            </cfoutput>
            <cfelse>
            <tr>
            <td colspan="4">No Residential property</td>
            </tr>
            </cfif>

the above should show the properties of residential in residential box and
commercial in commercial box but somehow i don't know it is showing all the
properties in the residential status also whose sub_id is not residential..

plz see this why i am getting this errronous thing,

i get no error for this: