sql="select sum(pro_price) as pro_price from taborder_clild where pro_id=" & pro_id(i) & " and O_code in (select OrderCode from taborders where ispay=1 and dates between '" & ftime & "' and '" & ltime & "')"可是不出数据,哪出错了
调试欢乐多
select sum(pro_price*pro_number) as pro_price from taborder_clild where pro_id=448 and O_code in (select OrderCode from taborders where ispay=1 and dates between '2009-2-10' and '2009-4-10')
<%
dim ftime,ltime,pro_id,i,sql,rs
ftime=request.Form("ftime")
ltime=request.Form("ltime")
'response.Write ftime
pro_id=split(request.Form("pro_id"),",")
for i=0 to UBound(pro_id)
sql="select sum(pro_price*pro_number) as pro_price from taborder_clild where pro_id=" & pro_id(i) & " and O_code in (select OrderCode from taborders where ispay=1 and dates between '" & ftime & "' and '" & ltime & "')"
response.Write sql
'response.End()
set rs=server.CreateObject("adodb.recordset")
rs.open sql,conn,1,3%>
<tr>
<td>
<%
response.Write rs(0) & "111<br>"
%>
</td>
</tr>
<%next
很有可能是参数传反了, between 后面依次是开始时间, 结束时间, 确认ftime是开始时间?还是ltime为开始时间?