Hi Paul, Thanks so much`-` yep the OR did it I also wanted the global category to came after the other category, and it seems like: ORDER by Category DESC works since I wrote the global navigation first.
Thanks so much for your help! John >Sorry that's meant to say use or instead of and in the query. > >Paul > > >>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4690 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
