又出问题了!!!
<% id1=Request.Form("slt1")
id2=Request.Form("slt2")
%>
<% strcnn = "Driver={SQL Server};Server=huangfr;Database=atm;UID=sa;PWD=147852;OLE DB Services=-1;"
Set cnn = Server.CreateObject("ADODB.Connection")
cnn.Open strcnn
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open "SELECT * FROM flight where start='"&id1&"' and arrive='"&id2&"'" ,cnn ,1,1 (预览总是提示这一行出错!请各位大侠帮忙解决一下?)
f = rs("flightno")
rs.close
set rs=noting
%>
还有一个问题就是如果查询结果是多条记录该如何显示?各位千万要帮帮我这个笨小孩!!!