kind of ironic huh? The Vanquish is ...errm...vanquished. On 9/27/06, Doug Brown <[EMAIL PROTECTED]> wrote: > 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:254572 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
