Recordset Count Question

[gio2888]

Hi, I am trying to display 10 sets of records at once....so this is basically what I am trying to do. At the reponse.write statement, how do I specify the recordset based on the count...like rs1, rs2, rs3...etc? what is the syntax like? Also if my sql statement is select *, then how do I for example return the "title" field of the 8th row in the recordset. Thanks!



count = 0

while not rs.eof and count < 10

response.write rs <----?????

 

[onpnt]

that's a pretty broad syntax orientated question or more so answer

first the loop to use
I would use the for as that is more counter orientated
for x = 0 to 10 stuff

then simple point to the column in which you want
for x = 0 to 10
if x = 8 then
response.write rs(&quot;column name&quot
end if
x = x + 1
next

validate EOF of course after the execute of the RS
there's fifty ways to do this really. the best is up to you but the basic pseudo is rate there for you loop through the RS
if counter = 8
write the record
iterate
.............
hope that helps

_____________________________________________________________________
[sub]Where have all my friends gone to????[/sub]

http://www.onpntwebdesigns.com

 

[gio2888]

How do I know that doing it this way the rs will return the right range...because I am trying to display 10 records at once...so the first set will be 1-10, and then 11-20...etc?

 

[onpnt]

now it sounds like you're trying to page the recordset. correct?



_____________________________________________________________________
[sub]Where have all my friends gone to????[/sub]

http://www.onpntwebdesigns.com

 

[gio2888]

Yea, basically I need to show 10 results per page...and so I need each page to show the correct range. Thanks for the help!

 

[100dtl]

Still need help or have you done it?

 

[gio2888]

still need help...trying to show the correct range...is there a way to say like rs(10), rs(11), rs(12)...etc to show rows 10, 11, 12 and so on?

Is that even right syntax rs(10) equals to the tenth row?

 

[onpnt]

there's two main ways to apge a recordset
1) getrows()

http://www.roksteady.net/database/getrowspaging.asp

2) setting pagesize , pagecount etc.. in the paging prop's of a recordset

http://www.juicystudio.com/tutorial/asp/paging.asp

hope that gets you going.

_____________________________________________________________________
[sub]Where have all my friends gone to????[/sub]

http://www.onpntwebdesigns.com

 

[gio2888]

Yes, thanks so very very very much...now its time to implement and test!!!