[ic] complex sql query in a scan link

Chen Naor interchange-users@icdevgroup.org
Wed Oct 2 17:38:01 2002


Hi
Using ic-4.8.6
pgsql 7.2
RH 7.3

Is it posible to make a complex sql query in a scan link ? (I need to query
from 2 diferent tables)
for example:
<a href="[area href=scan
        arg=|
        st=sql
        sq=select distinct products.* from products,prod_tech  where
products.sku=prod_tech.sku and products.category='BOGI' and
(products.countries like '%ZZ%' or products.countries like 'E %') and
prod_tech.tech1='big' order by products.sort
        sp=results_bo_p3
        ml=6
            |]">show</a>

The query is working fine in pgsql.

Thanks

Chen