[ic] [more] / [more-list] Alpha Numeric

Mike Heins interchange-users@interchange.redhat.com
Tue Oct 9 12:12:58 2001


Quoting Brian Kosick (briank@nacs.net):
> Speaking of the [more][more-list] tag, is there a way for it's alpha 
> numeric feature to be used in the [query] tag?  I have tried:
> 
> [query list=1 ml=50 more=1 st=db ma=yes mc=1 rf="code,desc" sql=|
>          SELECT p.code, p.name, p.short_desc,
>          p.price, p.qty, p.new_plant, p.avail,
>          p.disc
>          FROM products AS p, zip_zone AS z
>          WHERE z.zip = '[value search_zip]'
>          AND p.zones ~ z.zone
>          AND p.disc != '0'
>          ORDER BY p.name;
>          |
> ]
> 
> And variations on this, to no avail.

I think if you add:

	mv_sort_field=name

it might work. I don't believe I have ever tried this one, Racke
might have.

-- 
Red Hat, Inc., 3005 Nichols Rd., Hamilton, OH  45013
phone +1.513.523.7621      <mheins@redhat.com>

I don't buy from direct telephone or email marketers.  This makes it
hard for me to find a phone company. ;>