(0x80040E14)错误如何解决!
<%
set conn=server.CreateObject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.MapPath("data/data.mdb")
exec="select month(mydate) as rf,bb as ma,sum(myqty) as cl, from zmp grouq by month(mydate)"
set rs=server.CreateObject("adodb.recordset")
rs.open exec,conn,2,3
%>
<table width="200" border="1" cellspacing="0" cellpadding="0">
<%do while not rs.eof%><tr>
<td><%=rs("rf")%></td>
<td><%=rs("ma")%></td>
<td><%=rs("cl")%></td>
</tr>
</table>
<%
rs.movenext
loop
%>
<%
conn.close
set conn=nothing
rs.close
set rs=nothing
%>
set conn=server.CreateObject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.MapPath("data/data.mdb")
exec="select month(mydate) as rf,bb as ma,sum(myqty) as cl, from zmp grouq by month(mydate)"
set rs=server.CreateObject("adodb.recordset")
rs.open exec,conn,2,3
%>
<table width="200" border="1" cellspacing="0" cellpadding="0">
<%do while not rs.eof%><tr>
<td><%=rs("rf")%></td>
<td><%=rs("ma")%></td>
<td><%=rs("cl")%></td>
</tr>
</table>
<%
rs.movenext
loop
%>
<%
conn.close
set conn=nothing
rs.close
set rs=nothing
%>
错误类型:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] SELECT 子句中包含一个保留字、拼写错误或丢失的参数,或标点符号不正确。
/test8.asp, 第 6 行
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] SELECT 子句中包含一个保留字、拼写错误或丢失的参数,或标点符号不正确。
/test8.asp, 第 6 行