Doug Brown wrote: > Jim, > > I think this is happening in the second query that I am running. I was > having a problem with my menu system to where when there was no more data to > populate the menu it would dissapear. anyhow I added a second query to get > the last set of cat_id's viewed. > > > I have this set in my action page > > <cfset temp = valueList(get_child_categories.cat_id)> > <cfset client.firstCat = listFirst(#temp#)> > <cfset client.LastCat = listLast(#temp#)> >
I was just about to ask about those variables...so what is probably happening... When you don't order, you get query results something like... cat_id category 1 DB9 2 V8 Vantage 3 Other 4 Vanquish S AND firstcat is equal to 1 and lastcat is equal to 4 WHEN you do order, your get query results cat_id category 1 DB9 2 V8 Vantage 4 Vanquish S 3 Other AND firstcat is equal to 1 and lastcat is equal to 3, thus vanquishing the vanquish. Rather than doing a BETWEEN, you could just change that to IN (#thelistofids#). ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:254602 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
