Talk about frustrating. Ok, I am populating a menu from a database and something weird is going on. Hopefully someone can shed some light. This is a mySql database if that makes any difference. When I drill down into the menu, and select say Aston Martin as a auto make, I get a list of models. When I click on any model the Vanquish S model completely vanishes from the menu. This only happens with this one particular make. I have deleted and reinserted the information for this make and it always does the same thing.
DB9 V8 Vantage Vanquish S Other table categories cat_id pri key category parent_id <cfquery datasource="#request.site.dsn#" name="get_child_categories"> SELECT categories.cat_id, categories.category, categories.parent_id FROM categories WHERE categories.cat_id BETWEEN <cfqueryparam cfsqltype="cf_sql_numeric" value="#client.firstCat#"> AND <cfqueryparam cfsqltype="cf_sql_numeric" value="#client.LastCat#"> ORDER BY CASE WHEN categories.category = 'Other' THEN 1 ELSE 0 END, categories.category </cfquery> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254563 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
