[ic] (no subject)

Xin Xu interchange-users@icdevgroup.org
Tue Jun 10 09:34:01 2003


Hi,

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 )?

Thanks
-Xin