[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
Re: [ic] [more] / [more-list] Alpha Numeric
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. ;>
_______________________________________________
interchange-users mailing list
interchange-users@interchange.redhat.com
http://interchange.redhat.com/mailman/listinfo/interchange-users