If I do a SQL query something like SELECT TOP 5, then how might I select the various records within that range?
For example, if the query was for the top 5 member names with the most posts and I wanted to single out just the 3rd position, how would I identify which one was the third as opposed to say, the 5th?
A SELECT TOP requires an ORDER BY clause, so the third will be the 3rd record in the recordset and so on. You will need to navigate to the record position you want.
Don't know what you mean. Anyway, you will need to use the recorsed.movenext method twice to get to the 3rd record and then you can do whatever you want to do with the record.
Etymon, to use your example, you'll be looking at something like this:
strSQL = "SELECT TOP 5 * FROM FORUM_MEMBERS ORDER BY M_POSTS DESC;"
Set rs = Server.CreateObject("ADODB.RecordSet")
rs.Open strSQL, my_Conn
rs.MoveNext
rs.MoveNext
'Now you're in the third record, so you can do whatever you want with it
rs.Close
Set rs = Nothing
This is basically what ruirib is referring to.
Bill Parrott Senior Web Programmer, University of Kansas Co-Owner and Code Monkey, Eternal Second Designs (www.eternalsecond.com) Personal Website (www.chimericdream.com)
Bill Parrott Senior Web Programmer, University of Kansas Co-Owner and Code Monkey, Eternal Second Designs (www.eternalsecond.com) Personal Website (www.chimericdream.com)
Topic Locked
Posted - 19 November 2007 : 03:31:35
