[ic] Static Pages listing items by sku - rephrased

[Marty Tennison]

You might be missing the forest.   Instead of thinking about how code a page
to display individual items, think about how to "classify" individual items
in different ways so that you can use your relational database and pre-built
pages to display certain types of items.

Here is one way to do it:
You could use the featured column of the products table to specify a
particular search string then simply pass that sting in a query.  You could
also specify a different results page than the normal results.html
scan/st=db/co=yes/ml=10/sf=featured/sp=<SOME_RESULTS_PAGE>/se=<SOME_SEARCH_S
TRING>


BTW...You're right, doing a bunch of loops in a page would be very
inefficient.  Your much better off to do a single loop with search criteria.

Marty Tennison
marty@sediva.com

> -----Original Message-----
> From: interchange-users-admin@interchange.redhat.com
> [mailto:interchange-users-admin@interchange.redhat.com]On Behalf Of
> Steve Graham
> Sent: Tuesday, December 04, 2001 3:56 PM
> To: interchange-users@interchange.redhat.com
> Subject: Re: [ic] Static Pages listing items by sku - rephrased
>
>
> Hello,
>
> I'm looking for something which I thought was very basic - I need to show
> item 18143 on a static page (one that I hand coded, eg.
> test.html), showing
> the sku number, selling price, order button, and a tumbnail
> image. Just like
> the random items showing on the main Interchange index.html page.
>
> The code below is a way to do this, but doesn't seem an efficient method.
> Any other simple way to make this function call?
>
> I suggested something like [display-item "18143"] just as an
> example of what
> MIGHT be available.
>
> Thanks,
> -Steve
>
>
> >From: cfm@maine.com
> >Reply-To: interchange-users@interchange.redhat.com
> >To: interchange-users@interchange.redhat.com
> >Subject: Re: [ic] Static Pages listing items by sku(2)
> >Date: Tue, 4 Dec 2001 09:07:35 -0500
> >
> >On Tue, Dec 04, 2001 at 01:47:52PM +0000, Steve Graham wrote:
> > >
> > > Hello,
> > >
> > > I have both dynamic and static pages in my web site.
> > >
> > > On the static pages I would like to display a few items showing
> > > their price,
> > > description, and an order button.
> > >
> > > I know I can use something like this for each item:
> > > item code is 18143
> > >
> > > [loop search="se=18143"]
> > >  [loop-field description]
> > >  [loop-field price]
> > >  [/loop]
> > > [order "18143"]Order This</a>
> > >
> > > Isn't there a simple way like [display-item "18143"] to include all
> > > the
> > > above, or more in a neat clean format?
> > >
> > > Thanks,
> > > Steve
> >
> >Yes, we see you've asked several times.  Maybe it's clear to everyone
> >else, but I find the question confusing so I skip it.  Maybe if you
> >clarified what you mean by static and dynamic someone might help.
> >
> >cfm
> >
> >--
> >
> >Christopher F. Miller, Publisher
> >cfm@maine.com
> >MaineStreet Communications, Inc           208 Portland Road, Gray, ME
> >04039
> >1.207.657.5078
> >http://www.maine.com/
> >Content/site management, online commerce, internet integration, Debian
> >linux
> >_______________________________________________
> >interchange-users mailing list
> >interchange-users@interchange.redhat.com
> >http://interchange.redhat.com/mailman/listinfo/interchange-users
>
>
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
>
> _______________________________________________
> interchange-users mailing list
> interchange-users@interchange.redhat.com
> http://interchange.redhat.com/mailman/listinfo/interchange-users
>