在线等!ASP中插入数据库出现错误!!

来源:百度知道 编辑:UC知道 时间:2024/06/06 02:23:55
<%
'读取用户登录时的时间
set conn = Server.CreateObject("ADODB.Connection")
conn.Open("driver={Microsoft Access Driver (*.mdb)};dbq=" &_
Server.MapPath("qwang2006/#superking401954.asp"))
set rs = Server.CreateObject("ADODB.Recordset")
sql = "SELECT * FROM ftime where username='"&session("username")&"' ORDER BY 编号 DESC"
rs.Open sql, conn, 1

'现在的时间减去登录时间即为学时
dim shour,t1,t2
t1 = rs("ftime")
t2 = Now()
shour = DateDiff("n",CDate(t1),t2)
username = Request("username")
shour = Request("shour")

'将用户名和学时插入到数据库
set conn = Server.CreateObject("ADODB.Connection")
conn.Open("driver={Microsoft Access Driver (*.mdb)};dbq=" &_
Server.MapPath("qwang2006/#superking401954.asp"))
SQL = "INSERT INTO total(username,shour) VALUES('&

'现在的时间减去登录时间即为学时
dim shour,t1,t2
t1 = rs("ftime")
t2 = Now()
shour = DateDiff("n",CDate(t1),t2)
username = Request("username")
shour = Request("shour")
这里为什么要request
直接username=session("username")一个赋值就可以了
你前面没有传递这两个变量过来,这里用了request获取了一下,两个值当然为空了,你试试我给你说的!