Thanks Dave for your reply....

Well, in fact what I am doing is....
I have a GuestBook.HTML page where it alows the page visitor to view the GuestBook database file... the idea is :
1. One record will be displaied when the page opened for the first time
2. The "SELECT" statment will sort the records as "DESC" sort so the first record displyed is the last one in the database
3. At the end of the page 2 buttons available to move "Next" & "Previous" to displsy and move around the GuestBook database.

So I am using ".Find" when the visitor click "Next" or "Previous", as tracking the current record ID and move Forwor or Backword.

This what I am doing, if you like to review my Code let me know, and I'll send a copy to you.

Thanks again
Ahmad




>I have never used the bookmark, but the client-side cursor that you are creating should support it.
>
>http://www.learnasp.com/learn/adocursortypes.asp
>http://www.devguru.com/Technologies/ado/quickref/recordset_bookmark.html
>
>Using the .sort and .find methods will probably let you do what you want. The only issue that I can think of is that you want to have the database back end doing as much work as possible to leave the web server free for processing. So you want to do as much sorting and filtering as possible in your select statements, not in your ADO cursor. However, if manipulating a cursor gives you the what you need, go for it.
>
>
>-Dave
>
>>Thanks Dave,
>>I added the values and it's working fine.
>>
>>But I am stuck with the rst.BookMark, according to my manuals that ADO it does support the .BookMark, but in the code it's giving me an error
>>rstGuestBook.BookMark = varBookMar
>>and is't recomended to use the .Find in the web development ?
>>
>>Can you advice me what I am missing ?
>>
>>
>>
>>Many thanks again to you....
>>
>>Ahmad
>>
>>
>>>adUseClient, adOpenStatic, and adLockOptimistic are constants. Make sure you include adovbs.inc in you web page or just use their values. I think the values are 3 for all three constants.
>>>
>>>If you are using Interdev, there is also a way to include the constants in all your ASP pages if you include a reference to the ADO 2.5 or 2.6 library in your global.asa file. You can check www.4gusyfromrolla.com for those instructions.
>>>
>>>-Dave