UC知道ASP按照时间比较排序，我用ACCESS数据库
来源：百度知道 编辑：UC知道 时间：2024/09/25 16:41:48
我的代码如下
===============================
<%
dim Answ1,Answ2,Answ3,Answ4,Answ5,UserName,phone,email,UserNumber,regdate
Answ1=request.form("Answ1")
Answ2=request.form("Answ2")
Answ3=request.form("Answ3")
Answ4=request.form("Answ4")
Answ5=request.form("Answ5")
UserName=request.form("UserName")
phone=request.Form("phone")
email=request.Form("email")
UserNumber=request.form("UserNumber")
SqlInsert="Insert into Information(Answ1,Answ2,Answ3,Answ4,Answ5,UserName,phone,email,UserNumber,regdate) Values('"&Answ1&"','"&Answ2&"','"&Answ3&"','"&Answ4&"','"&Answ5&"','"&UserName&"','"&phone&"','"&email&"','"&UserNumber&"',getdate())"
conn.execute SqlInser
===============================
<%
dim Answ1,Answ2,Answ3,Answ4,Answ5,UserName,phone,email,UserNumber,regdate
Answ1=request.form("Answ1")
Answ2=request.form("Answ2")
Answ3=request.form("Answ3")
Answ4=request.form("Answ4")
Answ5=request.form("Answ5")
UserName=request.form("UserName")
phone=request.Form("phone")
email=request.Form("email")
UserNumber=request.form("UserNumber")
SqlInsert="Insert into Information(Answ1,Answ2,Answ3,Answ4,Answ5,UserName,phone,email,UserNumber,regdate) Values('"&Answ1&"','"&Answ2&"','"&Answ3&"','"&Answ4&"','"&Answ5&"','"&UserName&"','"&phone&"','"&email&"','"&UserNumber&"',getdate())"
conn.execute SqlInser
很简单的，现在数据库表新建一列 叫做 uptime
然后你的代码修改成
<%
dim Answ1,Answ2,Answ3,Answ4,Answ5,UserName,phone,email,UserNumber,regdate
Answ1=request.form("Answ1")
Answ2=request.form("Answ2")
Answ3=request.form("Answ3")
Answ4=request.form("Answ4")
Answ5=request.form("Answ5")
UserName=request.form("UserName")
phone=request.Form("phone")
email=request.Form("email")
UserNumber=request.form("UserNumber")
uptime=now
SqlInsert="Insert into Information(Answ1,Answ2,Answ3,Answ4,Answ5,UserName,phone,email,UserNumber,regdate) Values('"&Answ1&"','"&Answ2&"','"&Answ3&"','"&Answ4&"','"&Answ5&"','"&UserName&"','"&phone&"','"&email&"','"&UserNumber&"','"&uptime&"'