我学asp不久,照书编了一个小程序,却出了问题,找了半天也不知错在何方,请大虾帮小弟一把,不胜感激!
我编了一个数据库,有"name","password"两列,如果不用条件选择就没问题.用条件后在text1里输入:name = masun后,出现以下情况:
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e10'
[Microsoft][ODBC Microsoft Access 97 驱动程序] 参数不足，期待是
/index1.asp, 行16
我写的程序如下:
<%
name=request("text1")
password=request("text2")
sql = "select * from ""table"""
if name <> "" then
sql = sql & " where " & name
end if
if password <> "" then
sql = sql & " order by " & password
end if
%>
<%
set conn=server.createobject("adodb.connection")
cnpath="DBQ=" & server.mappath("db1.mdb")
conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; " & cnpath
set rs=conn.execute(sql)
%>

筛选数据:
排序数据:

<%
while not rs.eof
response.write ""
for i=0 to rs.fields.count-1
response.write ""
next
response.write ""
rs.movenext
wend
%>

" & rs.fields(i).value & "

请大侠帮忙!