Ok, I found the culprit, but still do not understand why it only happens with one certain make.
ORDER BY CASE WHEN categories.category = 'Other' THEN 1 ELSE 0 END, categories.category ----- Original Message ----- From: "Doug Brown" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Thursday, September 28, 2006 6:14 AM Subject: Re: Arghhhh!! > 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:254592 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
