[ic] (no subject)

[Kevin Walsh]

>
> How do I modify the following search in templates/components/random to do
> the sql equivalent of “
> Select p.* from products p, inventory i where p.sku=i.sku and i.quantity>0
> “
>
> [loop
>           random="[control matches 2]"
>           search="
>
>             fi=products
>             st=db
>             ra=yes
>             ml=[control pool 1000]
>
>         "]
>
> Moreover, is there a way to convert it to SQL so that it would be match more
> user friendly (at least for those of us using SQL database )?
>
You could use the [query] tag with your SQL.

--
   _/   _/  _/_/_/_/  _/    _/  _/_/_/  _/    _/
  _/_/_/   _/_/      _/    _/    _/    _/_/  _/   K e v i n   W a l s h
 _/ _/    _/          _/ _/     _/    _/  _/_/    kevin@cursor.biz
_/   _/  _/_/_/_/      _/    _/_/_/  _/    _/