源码:
Sql = "select * from LF188_Card where Time = #"&JDate&"# "
sql = sql & " order by id" 按id进行排序
sql = sql & " order by Time" 按时间进行排序 ——注:去掉这行后,程序则可无错执行,只要加上这行就提示如下错误!
Set rs = Server.CreateObject("Adodb.Recordset")
rs.Open sql, Conn, 1, 1 错误信息:
Microsoft JET Database Engine 错误 '80040e14'
ORDER BY 子句语法错误。
Sql = "select * from LF188_Card where Time = #"&JDate&"# "
sql = sql & " order by id" 按id进行排序
sql = sql & " order by Time" 按时间进行排序 ——注:去掉这行后,程序则可无错执行,只要加上这行就提示如下错误!
Set rs = Server.CreateObject("Adodb.Recordset")
rs.Open sql, Conn, 1, 1 错误信息:
Microsoft JET Database Engine 错误 '80040e14'
ORDER BY 子句语法错误。
sql = sql & " order by Time" 估计是ID与TIME 2者起冲突了。
ID 2 2010-07-01
ID 3 2010-07-03SQL怎么排?
sql = sql & " order by Time, id"
Sql = "select * from LF188_Card where Time = #"&JDate&"# "
sql = sql & " order by Time asc, id"……………………………………………………………………………………时间降序
Sql = "select * from LF188_Card where Time = #"&JDate&"# "
sql = sql & " order by Time desc, id"