点按钮,执行数据的添加?

[KinGboY16]

以下代码向 SQL Server200 的'model' 下的 '购书' 表 添加记录

添加的代码没有错,我试过了,可以添加 现在就是想点击按钮后再执行添加就无法执行了,

大哥们帮我看下是怎么回事

<html>
<body>
<%
sub go()
set conn=server.createobject("adodb.connection")
strprovider="provider=sqloledb.1;data source=JIANGHAITENG;database=model;uid=sa;pwd=;"
conn.open strprovider
app="f:\"
bookname="火拼时速"
price="10.00元"
num="10"
conn.begintrans
commandtext="insert into 购书 values('"+app+"','"+bookname+"','"+price+"','"+num+"')"
conn.execute commandtext,recordsaffected,adcmdtext
if conn.errors.count=0 then
conn.committrans
else
conn.rollbacktrans
end if
end sub
%>
<input type="button" name="button1" value="提交" onclick="go()">
</body>
</html>

[sh_city]

<input type="button" name="button1" value="提交" onclick="go()">
这是客户端的go();不是服务器上的.请改为:

<html>
<body>
<%
if request("action") = "add" then
go()
end if
sub go()
set conn=server.createobject("adodb.connection")
strprovider="provider=sqloledb.1;data source=JIANGHAITENG;database=model;uid=sa;pwd=;"
conn.open strprovider
app="f:\"
bookname="火拼时速"
price="10.00元"
num="10"
conn.begintrans
commandtext="insert into 购书 values('"+app+"','"+bookname+"','"+price+"','"+num+"')"
conn.execute commandtext,recordsaffected,adcmdtext
if conn.errors.count=0 then
conn.committrans
else
conn.rollbacktrans
end if
end sub
%>
<form action="?action=add" method="post">
<input type="submit" name="button1" value="提交" />
</form>
</body>
</html>

[KinGboY16]

没人会吗?

[windwl]

<form action="me.asp" method="post">
<input type="submit" name="button1" value="提交" />
</form>
</body>
</html>

[KinGboY16]

我改成如下 但还是不行

<html>
<body>
<%
if request.form("button1") = "提交" then
set conn=server.createobject("adodb.connection")
strprovider="provider=sqloledb.1;data source=JIANGHAITENG;database=model;uid=sa;pwd=;"
conn.open strprovider
app="f:\"
bookname="火拼时速"
price="10.00元"
num="10"
conn.begintrans
commandtext="insert into 购书 values('"+app+"','"+bookname+"','"+price+"','"+num+"')"
conn.execute commandtext,recordsaffected,adcmdtext
if conn.errors.count=0 then
conn.committrans
else
conn.rollbacktrans
end if
end if
%>
<form action="me.asp" method="post">
<input type="button" name="button1" value="提交">
</form>
</body>
</html>