[ic] query sql

Frank interchange-users@icdevgroup.org
Thu Dec 19 01:13:03 2002


Hello List,

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