Jim,
Here is the code that I am outputting with.
<cfoutput query="get_child_categories">
<tr>
<td bgcolor="##D2D2D2" "width=22" "height=19"
align="center"><img src=_images/m07.gif></td>
<td width="94%" bgcolor="##E9E9E9">
<a
href="#cgi.script_name#/fuseaction/sub_cats/cat_id/#cat_id#"
class="black11">
<cfif url.cat_id EQ #cat_id#><font
color="black"><b>#trim(category)#</b></font>
<cfelse>#trim(category)#
</cfif></a></td></tr>
</cfoutput>
Like I said, the weird thing is that no other make does this. I figured it
is a database problem with mySql but once I moved it over to MSSQL it still
does the very same thing.
----- Original Message -----
From: "Jim Wright" <[EMAIL PROTECTED]>
To: "CF-Talk" <[email protected]>
Sent: Thursday, September 28, 2006 6:58 AM
Subject: Re: Arghhhh!!
> 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:254600
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
