[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