[ic] Left hand bar {loop-exec] tag question

Paul Stearns pauls@compuace.com
Sun, 26 Nov 2000 09:39:26 -0500


Jerry:

Is the tag te= or tf=, my book says tf=.

At any rate the problem is that the "new items" link on the left hand bar
searches the merchandising table and then the product table, so the sort tag
seems to have no affect. The url generated by the "new items" link is
http://.../scan/fi=merchandising/sf=featured/se=new.html?id=cZM58trZ. This
magically searches the merchandising table and then dumps the products on the
screen.

What I want to do is (Oracle sql syntax)

select * from products
    where sku in
        (select sku from merchandising
            where featured = 'new' and
                sysdate between start_dat and finish_date)
    order by category;

and pass this to the results page.

Paul

Jerry wrote:

> Without seeing how your building the links, my
> guess would be to add a: te=field_to_sort_on in
> your link. This will sort the results on whatever
> column you choose.
>
> Jerry
>
> > -----Original Message-----
> > From: interchange-users-admin@minivend.com
> > [mailto:interchange-users-admin@minivend.com]On Behalf Of Paul Stearns
> > Sent: Sunday, November 26, 2000 12:03 AM
> > To: interchange-users@minivend.com
> > Subject: [ic] Left hand bar {loop-exec] tag question
> >
> >
> > I have succeeded in doing what I wanted, which is to limit the
> > left hand bar to
> > "areas", except for specials. When you click on the "area" in the
> > left bar it
> > takes you to a results page for that category. My results page
> > displays the
> > image associated to the category three up with links to a results
> > page for the
> > individual category.
> >
> >  If anyone is interested in this code, I'm looking for a bribe...
> > I need to know
> > how to sort the Results from the "New Items" link in the left hand bar, by
> > category. Tell me how to do it and the code is yours...
> >
> > Just kidding about the bribe... Just ask me and I'll let you have
> > it, bugs and
> > all...
> >
> > Paul
> >
> >
> >
> >
> > _______________________________________________
> > Interchange-users mailing list
> > Interchange-users@www.minivend.com
> > http://www.minivend.com/mailman/listinfo/interchange-users
> >
>
> _______________________________________________
> Interchange-users mailing list
> Interchange-users@www.minivend.com
> http://www.minivend.com/mailman/listinfo/interchange-users