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

Stefan Hornburg Racke interchange-users@interchange.redhat.com
Tue Oct 9 12:02:00 2001


Brian Kosick <briank@nacs.net> writes:

> 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.

In any case you need tf= set for the alpha numeric features,
like tf=desc, and the field in tf must be a subset of rf=.

Ciao
        Racke

-- 
Racke happily hacks Interchange and maintains Debian packages like Courier.

For projects and other business stuff please refer to COBOLT NetServices
(URL: http://www.cobolt.net; Email: info@cobolt.net; Phone: 0041-1-3884400)