[ic] query sql

Paul Jordan interchange-users@icdevgroup.org
Thu Dec 19 01:48:10 2002


> I'm trying to speed up my interchange by using the [query sql ...]
> tag instead of [loop search ...] and got it run in most cases
> (and it is about 200 times faster!!!) What I did is to change the
> 
> [loop search="se=dmm/sf=rub/ml=1"]
> ....
> [/loop]
> 
>  into 
> 
> [query sql = "SELECT code, thumb, ab_price, product 
>               FROM products 
>               WHERE rub = 'dmm'"
>               type=list]
> [list]
> ...
> [/list]
> [/query]
> 
> Now I got the problem that I need to search a substring
> and then I have to sort the results.
> 
> The [loop search .....] syntax I use is:
> 
> [loop search="se=dmd/sf=rub/su=yes/tf=rub/ml=15"]
> ...
> [/loop]
> 
> Is there any equivalent [query sql ....] tag for that???
> 
> I had no change with what I was trying:
> 
> [query sql = "SELECT code, thumb, ab_price, product 
>               FROM products 
>               WHERE rub LIKE 'dmd%'"
>               type=list
>               ml=15 ]
> [list]
> ...
> [/list]
> [/query]
> 
> Any ideas for doing better??
> How can I sort the result??
> 
> Thank you for your support
> 
> Frank

Try:

 [query 
         ml=15
         type=list
         sql="
               SELECT code, thumb, ab_price, product 
               FROM products 
               WHERE rub = 'dmm'
               ORDER BY rub
             "]

....rest of code


Paul