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