ASP数据库操作
请大家帮我看一下我的这段代码错在哪里?----真有点无从下手的感觉.
<%
dim connstr
connstr="provider=microsoft.jet.oledb.4.0;data source=" & server.mappath("../alldata.mdb")
set conn = server.createobject("ADODB.Connection")
conn.open connstr
set rs1=server.createobject("adodb.recordset")
rs1.open "select * from test",conn
response.write "ok" ''''''测试读取
response.write "rs1("t_name"&"<br>")"
response.write "rs1("t_sex" )"
response.write "rs1("t_id" )"
%>
<%=rs1("t_name")&"<br>"%>''''如果我只要这个输出,不要上面的输出就没有问题.那些数据库的字段都没有错.
运行结果:
错误类型：
Microsoft VBScript 编译器错误 (0x800A0401)
语句未结束
/test/test.asp, line 11, column 21
response.write "rs1("t_name"&"<br>")"
--------------------^
参考答案:response.write "rs1("t_name"&"<br>")"
改成
response.write rs1("t_name")&"<br>"
后面两行改成
response.write rs1("t_sex" )
response.write rs1("t_id" )