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

Jerry jerry@data-logic.com
Sun, 26 Nov 2000 11:45:19 -0500


It was early Sunday morning... what can I say.
Yep it's tf= for sure.

I have to think about the other problem. :)

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 9:39 AM
> To: interchange-users@minivend.com
> Subject: Re: [ic] Left hand bar {loop-exec] tag question
>
>
> 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
>
>
> _______________________________________________
> Interchange-users mailing list
> Interchange-users@www.minivend.com
> http://www.minivend.com/mailman/listinfo/interchange-users
>