<% name=request.form("name") tel=request.form("tel") set conn=server.createobject("adodb.connection") conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("example3.mdb") exec="select * from guestbook where name='"+name+"' and tel='"+tel+"'" set rs=server.CreateObject("adodb.recordset") rs.open exec,conn,1,1 %>

请问高手我这里有没有错,为什么老是不行.

[此贴子已经被作者于2004-09-26 12:49:15编辑过]

<% name=request.form("name") set conn=server.createobject("adodb.connection") conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("example3.mdb") exec="select * from guestbook where name='"+name+"'" set rs=server.CreateObject("adodb.recordset") rs.open exec,conn,1,1 %>

而这样就可以查询,不要tel

<% name=request.form("name") tel=request.form("tel") set conn=server.createobject("adodb.connection") conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("example3.mdb") exec="select * from guestbook where name=' "+name+" ' and tel=' "+tel+" ' " ^(空格）　　　　　　 ^(空格） set rs=server.CreateObject("adodb.recordset") rs.open exec,conn,1,1 %>

多谢版主,我已改为:

<% name=request.form("name") tel=request.form("tel") set conn=server.createobject("adodb.connection") conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("example3.mdb") exec="select * from guestbook where name='"+name+"'and tel='"+tel+"'" set rs=server.CreateObject("adodb.recordset") rs.open exec,conn,1,1 %>

也不行,