[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