[thelist] ASP: Jump to specific record in recordset
Ken Kogler
gsls at kenkogler.com
Tue Mar 16 10:46:41 CST 2004
This is using ASP/SQL Server 2000 on a Win2k box in an interal dev
enviroment.
I'm bringing back a recordset that looks like this:
cID cName
--- -----
091 Jones, Bob
092 Joney, Jane
095 Kowalski, Kevin
099 Stein, Frank N.
In ASP, I want to just go right to row 95. Is there any way to do it
other than looping through the recordset until I get there?
I want to avoid this:
while not rs.eof
if rs("cID") <> 095 then
rs.moveNext
endif
response.write "I'm at 95!"
wend
Is there something like this?:
rs.goto("095")
response.write "I'm at 95!"
Thanks in advance, evolters!
--ken
More information about the thelist
mailing list