Fw: [thelist] SQL record filtering

[dn at dittodesign.co.uk]

better url to see the thing in action -

http://www.simply-connect.info/accessories_category.asp?Phone_Make=Nokia&Mas
ter_Category=Fascias&Phone_Model=3330

or try choosing nokia and fascias from the accessories link.

Darren Yates
dn at dittodesign.co.uk
http://dittodesign.co.uk

----- Original Message -----
From: <dn at dittodesign.co.uk>
To: <thelist at lists.evolt.org>
Sent: Thursday, September 12, 2002 2:23 PM
Subject: Re: [thelist] SQL record filtering


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