asp中连接数据库

来源：百度知道 编辑：UC知道 时间：2024/06/08 22:35:36
dim conn
dim connstr
dim db
db="aspdata/data/userdatas.mdb"
Set conn = Server.CreateObject("ADODB.Connection")
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(""&db&"")
conn.Open connstr
sql="update userdata set nmb="& sum&"where uname="& session("gxinxiuangyida")&""
conn.execute(sql)
怎么不对啊 高手给指点下

dim conn
dim connstr
dim db
db="aspdata/data/userdatas.mdb"
Set conn = Server.CreateObject("ADODB.Connection")
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(""&db&"")
conn.Open connstr
sql="update userdata set nmb="& sum &" where uname='"& session("gxinxiuangyida")&"'"
conn.execute(sql)

sql="update userdata set nmb="& sum&"where uname="& session("gxinxiuangyida")&""

改成

sql="update userdata set nmb="& cint(sum) & " where uname='"& session("gxinxiuangyida") & "'"

wainnnni 的正解
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(db)