主题 : jspgou, java.lang.Integer cannot be cast to [Ljava.lang.Object;报这个错 |
级别: 举人
|
1# 发表于:2015-08-15 11:31:19 IP:61.85.*.*
|
||||
---|---|---|---|---|---|
级别: 举人
|
3# 发表于:2015-08-15 11:34:17 IP:61.85.*.*
这是我写的,sql语句,select count(*) from (select b.*,ISNULL((select pp.shunxu from jc_shop_sp pp where b.ztdaihao=pp.shangpingid and b.attr_value='26'),0) shunxu ,(select jw.suffix from jc_core_website jw where b.website_id=jw.website_id) suffix , (select jw.is_relative_path from jc_core_website jw where b.website_id=jw.website_id) is_relative_path , (select jw.domain from jc_core_website jw where b.website_id=jw.website_id) domain , (select jcy.path from jc_shop_category jcy where b.category_id=jcy.category_id) path , (select jg.context_path from jc_core_global jg where b.website_id=jg.global_id) context_path , (select jg.port from jc_core_global jg where b.website_id=jg.global_id) port, (select jt.cover_img from jc_shop_product_ext jt where b.product_id=jt.product_id) cover_img, dbo.quannian(b.ztdaihao) quannian from ( select MAX(js.name) name,MAX(je.attr_value)attr_value ,producttex2_.ztdaihao ,MAX(js.product_id) product_id,MAX(js.sale_price) sale_price , MAX(js.website_id) website_id,MAX(js.category_id) category_id from jc_shop_product js join jc_shop_product_exended je on js.product_id=je.product_id cross join jc_shop_product_text producttex2_ where js.product_id=producttex2_.product_id and je.attr_name='qikanfenlei' and je.attr_value='26' and js.on_sale='1' and producttex2_.qishu is not null and producttex2_.qishu='1' group by producttex2_.ztdaihao) b ) c 在数据库中,是可以执行成功的
|
||
---|---|---|---|
1
共1页