[thelist] SQL record filtering

dn at dittodesign.co.uk dn at dittodesign.co.uk
Thu Sep 12 08:24:01 CDT 2002

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-)


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.


Darren Yates
dn at 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 !

More information about the thelist mailing list