Hi Karen, > Very interested to see if/how you get it done. I tried Joshuas code first as it was a case of cut and paste almost. I had a few bugs and turned to your idea. I tried DISTINCTROW without much success I'm also doing other filtering on the same page and couldn't slot it in place. I then tried DISTINCT which was ideal as it returned one record from each of the categories rather than all but again I couldn't get it working with the recordsets I was already using on the page. Tried a few ultradev extensions which turned out to be a dead end Finally returned to Joshuas code this morning and with a few tweaks got the thing running perfectly.Yeehaw ! =8-) http://www.simply-connect.info/mobile_phone_accessories.htm to perform this trick the magic words are - SELECT Small_Image, Phone_Model, Sale_Price, Master_Category, Category, ID FROM accessories WHERE ID IN ( SELECT Min(ID) FROM accessories WHERE Master_Category = 'MMColParam' AND Phone_Model = 'MMColParamC' GROUP BY Category ) MMColParam = Request.QueryString("Master_Category") MMColParamC = Request.QueryString("Phone_Model" Thanks Joshua for the life line and thanks again Karen for the suggestions. regards, Darren Yates dn at dittodesign.co.uk http://dittodesign.co.uk ----- Original Message ----- From: "Karen J. Bowen" <lists at miinx.com.au> To: <thelist at lists.evolt.org> Sent: Thursday, September 12, 2002 3:37 AM Subject: Re: [thelist] SQL record filtering > dn at dittodesign.co.uk wrote: > > Looks promising, although boolean value setting is a bit beyond me > > as would be introducing a Master Category - Category table. > > Adding a table in at this stage would be nightmare & I probably wouldn't > recommend it. > > The boolean value setting I could help with, but I think using the > DISTINCTROW ideas would be a neater solution, with the same effect. > > > thanks for taking the time Karen. > > No problem. :) > > Very interested to see if/how you get it done. > > Good luck, > Karen > ------- > Miinx Design & Development > e :: karen at miinx.com.au > p :: 0413.880.302 > w :: www.miinx.com.au > > > -- > For unsubscribe and other options, including > the Tip Harvester and archive of thelist go to: > http://lists.evolt.org Workers of the Web, evolt !