按月统计问题
<%
Dim tSql
Dim rs
dim conn
set conn=server.CreateObject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.MapPath("data/data.mdb")
tSql="select month(date) as 月份,name_a as 硬件名称,type_a as 硬件型号,unit as 单位,sum(qty) as 数量 "
tSql=tSql&"from test"
tSql=tSql&"where year(date)=2007 group by month(date),name_a,type_a"
set rs=conn.execuet(tSql)
%>
错误类型:
ADODB.Connection (0x800A0BB9)
参数类型不正确,或不在可以接受的范围之内,或与其他参数冲突。
/test8.asp, 第 10 行