[ic] QUERY tag hang on to respond

[Danilo]

damn!
thanks Kevin

Kevin Walsh wrote:

>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]
>     ...
>
>  
>