Yeah, it might even be funny if it were not happening to me :-/ Anyhow, here is what I have tried with no sucess.
1. Deleted the category aston Martin and all child categories 2. Reinserted the category and all childs 3. Created a flat file and copied the tables over to SQL2000 Nothing has helped. Does anyone think it may be a coldfusion problem? I cannot see that it would be myself since all other categories work just fine. ----- Original Message ----- From: "Zaphod Beeblebrox" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Wednesday, September 27, 2006 9:58 PM Subject: Re: Arghhhh!! > 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:254589 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
