Doug Brown wrote: > 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 >
Doug, What results do you get back if you run this query directly on the database? That CASE statement in the order by shouldn't be eliminating any data, so I'm thinking this is probably something in how you are outputting the menu in CF. Can we see that code? -jim ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:254599 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
