[thelist] SQL record filtering
dn at dittodesign.co.uk
dn at dittodesign.co.uk
Wed Sep 11 08:45:01 CDT 2002
Thanks Karen, joshua
> Which database?
Sorry should of said, Access.
> Defining the business rules will help here.
business rules ?
> How do you decide which of the
> products within a product type is appropriate to display on this page?
essentially any one product in the product types is suitable to use as a
link
to all the the matching products.
If that makes sense few to many products me thinks.
Maybe this url will make it a little clearer -
http://www.simply-connect.info/accessories_category.asp?Phone_Make=Nokia&Mas
ter_Category=Fascias&Phone_Model=3330
as you can see I get all records returned and would like just one from
each of the categories listed that could then be clicked on to show the
rest in that category.
Darren
----- Original Message -----
From: "Joshua Olson" <joshua at waetech.com>
To: <thelist at lists.evolt.org>
Sent: Wednesday, September 11, 2002 2:20 PM
Subject: Re: [thelist] SQL record filtering
> ----- Original Message -----
> From: <dn at dittodesign.co.uk>
> Sent: Wednesday, September 11, 2002 7:14 AM
>
>
> > Hi all,
> > Could somebody point me in the right direction with this one please.
> >
> > I'm working on a site at the moment that requires I pass variables over
> > a number of pages to filter a recordset on the final page depending on
> > the variable choices over the previous pages. Simple. ASP and Ultradev
> > by the way.
>
> Which database?
>
> > As simply as I can put it. I'm filtering down to 'Category' on the final
> > page. However Category could have up to six different product types.
> > I want to show just one record from each of these product types.
> > Rather than the whole lot in that Category. Clicking on that product
type
> > then brings up the associated products.
>
> Defining the business rules will help here. How do you decide which of
the
> products within a product type is appropriate to display on this page?
> Without that business logic established, this problem is really not
> correctly solvable. With that information, and the database employed, I
> think we'll be able to come up with a good solution.
>
> -joshua
>
> --
> 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