[ic] QUERY tag hang on to respond

[Kevin Walsh]

Danilo [kosmo at trslab.it] wrote:
> 
> Hi, I use IC 4.8.7 on RH 8.0 with mysql 3.23.54 and when run this query 
> IC stop to respond.
> [query
>     list=1
>     ml=999
>     prefix=menu
>     sql="SELECT DISTINCT 
> categories.id_cat,categories.cat_name,categories.cat_icon
>         FROM subcategories,products,prodmods,categories
>         WHERE prodmods.id_model = '[value model]'
>         AND prodmods.id_product = products.id_product
>         AND products.id_scat = subcategories.id_scat
>         AND categories.id_cat = subcategories.id_cat
>         AND categories.active_cat = 1
>         ORDER BY categories.sort,cat_name ASC
>         ]
>     [list]
>     [menu-param id_cat], [menu-param cat_name], [menu-param scat_name], 
> [menu-param cat_icon]<br>
>     [/list]
> [/query]
> 
You've forgotten the closing double-quote:

         ...
         ORDER BY categories.sort,cat_name ASC
-->      "]
     [list]
     ...

-- 
   _/   _/  _/_/_/_/  _/    _/  _/_/_/  _/    _/
  _/_/_/   _/_/      _/    _/    _/    _/_/  _/   K e v i n   W a l s h
 _/ _/    _/          _/ _/     _/    _/  _/_/    kevin at cursor.biz
_/   _/  _/_/_/_/      _/    _/_/_/  _/    _/