[ic] QUERY tag hang on to respond

Danilo kosmo at trslab.it
Sat Aug 16 17:56:44 EDT 2003


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]

the same query works fine on the mysql console

mysql> SELECT DISTINCT 
`categories`.`id_cat`,`categories`.`cat_name`,`categories`.`cat_icon`
    -> FROM products,`subcategories`,`categories`,`prodmods`
    -> WHERE `prodmods`.`id_model`= 127
    -> 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;
+--------+--------------+-----------------------+
| id_cat | cat_name     | cat_icon              |
+--------+--------------+-----------------------+
|      4 | Cavalletti   | icon_cavalletti.gif   |
|      2 | Bulloneria   | icon_bulloneria.gif   |
|     17 | Accessori    | icon_accessori.gif    |
|     14 | Cerchi       | icon_ruote.gif        |
|     13 | Detergenti   | icon_detergenti.gif   |
|     10 | Elettronica  | icon_elettronica.gif  |
|      5 | Freni        | icon_freni.gif        |
|      6 | Frizioni     | icon_frizioni.gif     |
|     12 | Lubrificanti | icon_lubrificanti.gif |
|     19 | Manubri      | icon_manubri.gif      |
|     15 | Motore       | icon_motore.gif       |
|     18 | Pedane       | icon_pedane.gif       |
|     16 | Pneumatici   | icon_pneumatici.gif   |
|      8 | Scarichi     | icon_scarichi.gif     |
|      7 | Sospensioni  | icon_sospensioni.gif  |
|      9 | Trasmissioni | icon_trasmissioni.gif |
+--------+--------------+-----------------------+
16 rows in set (0.00 sec)

someone know something about this issue? can help me to solve this problem.
thanks in advance
danilo



More information about the interchange-users mailing list