[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-)
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 !
More information about the thelist
mailing list