select * from cont order by itworkitem desc 这个应该可以查出最后一条哦
<% dim conn,sql,rs set rs = server.createobject("adodb.recordset") set conn = server.createObject("ADODB.Connection") conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("/database/data.mdb") sql = "select top 1 * from (select * from cont order by itworkitem asc)" rs.open sql,conn,1,1 %> <%=rs("itworkitem")%> <% rs.close set rs=nothing conn.close set conn=nothing %> 试过了,结果一样的,还是不知道读取的是中间的什么数据,头痛...
语法没有问题,其他原因,很可能不是执行这段代码(随便改下sql看是否执行到)
<% dim conn,sql,rs set rs = server.createobject("adodb.recordset") set conn = server.createObject("ADODB.Connection") conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("/database/data.mdb") exec = "select top 1 * from cont order by itworkitem Asc" rs.open exec,conn,1,1 %> <%=rs("itworkitem")%> <% rs.close set rs=nothing conn.close set conn=nothing %> 听了楼上两位的话,试了,还是不是最后一条纪录,在中间不知道怎么取的一条记录...郁闷了...
desc我也试了,结果是显示的数据库第一条记录...
select top 1 * from (
select * from cont order by itworkitem Asc)a
这样写的。。
楼主在宝安啊。。我在罗湖,从事DBA
SELECT 表1.编号, 表1.id, 表1.name
FROM 表1
WHERE (((表1.编号) Between 2 And 3))
ORDER BY 表1.编号 DESC;
有QQ吗?能帮我解决一下asp+access的问题吗?我非专业人士,只是想自己弄个项目的网站自己用...整好了我请你吃饭如何?可以的话加我QQ撒...
这个应该可以查出最后一条哦
dim conn,sql,rs
set rs = server.createobject("adodb.recordset")
set conn = server.createObject("ADODB.Connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("/database/data.mdb")
sql = "select top 1 * from (select * from cont order by itworkitem asc)"
rs.open sql,conn,1,1
%>
<%=rs("itworkitem")%>
<%
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
试过了,结果一样的,还是不知道读取的是中间的什么数据,头痛...
dim conn,sql,rs
set rs = server.createobject("adodb.recordset")
set conn = server.createObject("ADODB.Connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("/database/data.mdb")
exec = "select top 1 * from cont order by itworkitem Asc"
rs.open exec,conn,1,1
%>
<%=rs("itworkitem")%>
<%
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
听了楼上两位的话,试了,还是不是最后一条纪录,在中间不知道怎么取的一条记录...郁闷了...