> At 8:45 +0500 7/23/03, Shahid M. Syed wrote:>Hello > >Does any version (production or future) of mysql supports Bookmarks?
What is "Bookmark" capability in a database context?
You can use the Bookmark property to set a bookmark (Bookmark: A property of a Recordset object or a form that contains a binary string identifying the current record.) that uniquely identifies a particular record in the form's underlying table, query, or SQL statement. Read/write Variant.
Example: In VB6, I can read a bookmark in a variant like varBookmark = rsName.Bookmark Where varBookmark is a variant and rsName is a adodb recordset.
Later I can go back to the same record by rsName.Bookmark = varBookmark
This sounds like a client-side mechanism, not a capability of the database server.
In ASP, I'm trying to come up with a better solution where there is too much data in recordset to display at once in a web page. Exactly like when you search on Yahoo and at bottom its gives links like: Next, Next 10 and also page links like 1,2,3.... 14.
LIMIT may help you here. You can use it to have the server send you a small section of the records selected by a query.
http://www.mysql.com/doc/en/SELECT.html
If you know any other or better way for doing this, please let me know.
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
