刚学asp，小疑点，送分，多谢
日期：2014-05-17 浏览次数：20685 次
刚学asp，小问题，送分，谢谢！
将文本框的值，写入数据库，如何做？
<SCRIPT LANGUAGE= "VBScript " Runat= "Server ">
Sub cmdChangeIt_onClick
dim connstr,conn,record,sql
connstr= "Driver={SQL Server};Server=.;Uid=sa;pwd=sa;Database=Lpos5_B_dingguagua; "
Set conn = Server.Createobject( "ADODB.Connection ")
conn.CommandTimeout = 2000
conn.open connstr
Set Record1=Server.CreateObject( "Adodb.Recordset ")
sql= "insert into w_b_fqs_m (billnum,midornigth,LastUpdateTime) values ( ' "& str & " ', "& txt.value & ",getdate()) " '不能引用文本框的值
Record1.Open sql,conn
End Sub
If Request.ServerVariables( "REQUEST_METHOD ") = "POST " Then
If Request.Form( "cmdChangeIt ") = "ent " Then
Call cmdChangeIt_onClick
End If
End If
</SCRIPT>
<HTML>
<HEAD> <TITLE> </TITLE>
</HEAD>
<BODY>
<HR>
<FORM id= "MyForm " name= "MyForm " method= "post " action= "test.asp ">
<INPUT TYPE= "submit " NAME= "cmdChangeIt " VALUE= "ent " />
<input name= "txt " type= "text " id= "txt " />
</FORM>
</BODY>
</HTML>
------解决方案--------------------
......
服务端和客户端概念 混淆的厉害
建议先搞清楚这2个的差别
------解决方案--------------------
document.txt.value
------解决方案--------------------
两年没玩ASP，不对别见怪。
先熟悉引号的转义，印象中记得，两双变一双，两单变一单。
要说字串“3” 那么 x = "3 ",
要说字串“456” 那么 x = "456 ",
要说字串“ '” 那么 x = " ' ' " ,或 x = " " ' " ,ASP中两个引号在一起，只看后面一个
要说字串“ "” 那么 x = " " " " ,或 x = " ' " " ,ASP中两个引号在一起，只看后面一个
要说字串“fs+ "4fs "” 那么 x = "fs+ " "4fs " " " ,或 什么自己试 ,
要说字串“ ' ' " " " ' ' ' ' " " " " " ' ' " "” 那么 x = "....... " ,.......不好意思，电脑出错了。
------解决方案--------------------
<FORM id= "MyForm " name= "MyForm " method= "post " action= "test.asp ">
//表单提交到test.asp是吧！！你有那个页面吗？？
//如果就是本页，那么你还要在服务器端获取表单传过去的值request( "value ");
//表单的输出填写是在客户端执行，而写入数据库更新数据是在提交后的服务器端执行
楼主补课吧！！嘿嘿～～～～～～～～
将文本框的值，写入数据库，如何做？
<SCRIPT LANGUAGE= "VBScript " Runat= "Server ">
Sub cmdChangeIt_onClick
dim connstr,conn,record,sql
connstr= "Driver={SQL Server};Server=.;Uid=sa;pwd=sa;Database=Lpos5_B_dingguagua; "
Set conn = Server.Createobject( "ADODB.Connection ")
conn.CommandTimeout = 2000
conn.open connstr
Set Record1=Server.CreateObject( "Adodb.Recordset ")
sql= "insert into w_b_fqs_m (billnum,midornigth,LastUpdateTime) values ( ' "& str & " ', "& txt.value & ",getdate()) " '不能引用文本框的值
Record1.Open sql,conn
End Sub
If Request.ServerVariables( "REQUEST_METHOD ") = "POST " Then
If Request.Form( "cmdChangeIt ") = "ent " Then
Call cmdChangeIt_onClick
End If
End If
</SCRIPT>
<HTML>
<HEAD> <TITLE> </TITLE>
</HEAD>
<BODY>
<HR>
<FORM id= "MyForm " name= "MyForm " method= "post " action= "test.asp ">
<INPUT TYPE= "submit " NAME= "cmdChangeIt " VALUE= "ent " />
<input name= "txt " type= "text " id= "txt " />
</FORM>
</BODY>
</HTML>
------解决方案--------------------
......
服务端和客户端概念 混淆的厉害
建议先搞清楚这2个的差别
------解决方案--------------------
document.txt.value
------解决方案--------------------
两年没玩ASP，不对别见怪。
先熟悉引号的转义，印象中记得，两双变一双，两单变一单。
要说字串“3” 那么 x = "3 ",
要说字串“456” 那么 x = "456 ",
要说字串“ '” 那么 x = " ' ' " ,或 x = " " ' " ,ASP中两个引号在一起，只看后面一个
要说字串“ "” 那么 x = " " " " ,或 x = " ' " " ,ASP中两个引号在一起，只看后面一个
要说字串“fs+ "4fs "” 那么 x = "fs+ " "4fs " " " ,或 什么自己试 ,
要说字串“ ' ' " " " ' ' ' ' " " " " " ' ' " "” 那么 x = "....... " ,.......不好意思，电脑出错了。
------解决方案--------------------
<FORM id= "MyForm " name= "MyForm " method= "post " action= "test.asp ">
//表单提交到test.asp是吧！！你有那个页面吗？？
//如果就是本页，那么你还要在服务器端获取表单传过去的值request( "value ");
//表单的输出填写是在客户端执行，而写入数据库更新数据是在提交后的服务器端执行
楼主补课吧！！嘿嘿～～～～～～～～
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
