An easy ASP database question...

[Eek]

Here's something that should be easy to answer.

Here's a loop that will print ALL the 'comments' records.....how can I only print the last record ? And if possible how can I only print the last 2 records ?


Do While not rsGuestbook.EOF
Response.Write (rsGuestbook("Comments"))
Loop

 

[Eek]

oh yeah I forgot.... the above is a Cut & PAste of an ASP that connects to an Access DB to get the COMMENTS record

 

[DreXor]

rsguestbook.movelast (last record)
rsguestbook.moveprevious (one before the last)

what you're after might be easier to achieve with getrows, then you can reference any part of the array at any given point so you can shift around all you want in a non-linear form.

ps, there's no movenext in that loop, and without it will cause an infinite loop/timeout/lockup

DreX
aKa - Robert