28,391
社区成员
发帖
与我相关
我的任务
分享
order_sum_sql=conn.execute("SELECT COUNT(DISTINCT pro_id) FROM taborder_product WHERE pro_id IN (SELECT id FROM tabproduct WHERE ManageName_id =" & Session("ManageName_id") & "")
response.Write order_sum_sql(0)
order_sum_sql="select count(pro_id) from taborder_product where pro_id in (select id from tabproduct where ManageName_id= " & Session("ManageName_id")
set rs_update=CreateObject("adodb.Recordset")
rs_update.open order_sum_sql,conn,1,3
if not rs_update.eof then
response.Write "<<<>>><br>"
response.Write "<<<" & rs_update(0) & ">>>"
response.Write "<br>" & order_sum_sql
else
response.Write order_sum_sql
END IF
这样输出的是 , 第二行还是空,到底是怎么回事啊
<<<>>>
select count(pro_id) from taborder_product where pro_id in (select id from tabproduct where ManageName_id= 5