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