数据录入的简单问题 急！

[drummerzww]

save.asp如下
<%
Set Conn=Server.CreateObject ("ADODB.Connection")
Conn.Open "driver={sql server};server=(local);uid=sa;pwd=123;database=db1"

set r=server.createobject("adodb.recordset")
sql1="insert into t1(name) values('" & trim(request("tou")) & "')"
conn.execute sql
r.close
set r=nothing
conn.close
set conn=nothing
%>
连接时显示 该页无法显示 请指点！ 谢谢！

[drummerzww]

上面写错了 应该是conn.execute sqll

[drummerzww]

等待－－－－－－－－

[laers]

你一步步测试吧,先看下你的连接数据库有没有连得上,可以的话再测你的sql语句!

[xj1122]

conn.Execute (Sql) 试试

[Ccode]

<%
Set Conn=Server.CreateObject ("ADODB.Connection")
Conn.Open "driver={sql server};server=(local);uid=sa;pwd=123;database=db1"
conn.execute ("insert into t1(name) values('" & trim(request("tou")) & "')")
conn.close
set conn=nothing
%>
这样试试

[shanxing]

学习