asp与数据库连接问题,急~!
来源:百度知道 编辑:UC知道 时间:2024/04/30 17:06:59
<%
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "driver={Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("data/56789.asp")
sql = "select p_id,p_name.p_pic,p_spec from p_info"
Set rs = Server.CreateObject("ADODB.RecordSet")
rs.Open sql,conn,1,1
Do While Not rs.Eof
Response.Write "<a href="showpic.asp?p_id=<%= n_rs("p_id") %>&path=<%= n_rs("p_pic") %>&pname=<%= n_rs("p_name") %>" target="_self"><img name="<%= n_rs("p_name") %>" src="UploadFile/<%= n_rs("p_pic") %>" alt="产品的名称:<%= n_rs("p_name") %>-型号:<%= n_rs("p_spec") %>" border="1" style="border-style: solid; border-color: #000000"></a>"
rs.MoveNext
Loop
rs.C
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "driver={Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("data/56789.asp")
sql = "select p_id,p_name.p_pic,p_spec from p_info"
Set rs = Server.CreateObject("ADODB.RecordSet")
rs.Open sql,conn,1,1
Do While Not rs.Eof
Response.Write "<a href="showpic.asp?p_id=<%= n_rs("p_id") %>&path=<%= n_rs("p_pic") %>&pname=<%= n_rs("p_name") %>" target="_self"><img name="<%= n_rs("p_name") %>" src="UploadFile/<%= n_rs("p_pic") %>" alt="产品的名称:<%= n_rs("p_name") %>-型号:<%= n_rs("p_spec") %>" border="1" style="border-style: solid; border-color: #000000"></a>"
rs.MoveNext
Loop
rs.C
"select p_id,p_name.p_pic,p_spec from p_info"
________________↑
这里把“,”写成“.”了
补充上面仁史的答复
n_rs记录集在哪里??
没定义吧?还是写错了