 |
|
8000XXXX Errors Alerts ASP.NET 2.0 Classic ASP 1.0
Databases Access DB & ADO General SQL Server & Access Articles MySQL Other Articles Schema Tutorials Sql Server 2000 Sql Server 2005 General Concepts Search Engine Optimization (SEO)Search
ASP FAQ Tutorials :: Databases :: General SQL Server & Access Articles :: Why does AbsolutePosition return as -1?
Why does AbsolutePosition return as -1?
This could be because the provider you selected doesn't support AbsolutePosition. But it is more likely that you are not opening the cursor with the correct properties. Make sure you are using a dynaset or snapshot cursor; this means that adOpenForwardOnly should be used in place of adOpenStatic, and the CursorLocation should be set to adUseClient.
Rather than demonstrate with a code sample, I am going to assume you are trying to implement a paging mechanism (e.g. 20 rows per page); please see Article #2120 for some better approaches than using these heavy client-side recordset properties.
Rather than demonstrate with a code sample, I am going to assume you are trying to implement a paging mechanism (e.g. 20 rows per page); please see Article #2120 for some better approaches than using these heavy client-side recordset properties.
Related Articles
Can I fix this mm/dd/yyyy <-> dd/mm/yyyy confusion once and for all? Could I get some help with JOINs? How can I tell which version of MDAC I'm running? How do I access MIN, MAX, SUM, COUNT values from SQL statements? How do I change column order in a table structure? How do I change the order of columns in a table? How do I concatenate strings from a column into a single row? How do I convert columns of values into a single list? How do I determine if a database exists? How do I document / compare my SQL Server database(s)? How do I get the IDENTITY / AUTONUMBER value for the row I inserted? How do I solve 'ADO Could Not Find The Specified Provider'? Should I use BETWEEN in my database queries? Why can't I use the * wildcard in a database search? Why do I get 'Syntax Error in INSERT INTO Statement' with Access? Why do I get weird results when using both AND and OR in a query? Why do some SQL strings have an 'N' prefix? Why doesn't SQL Server allow me to separate DATE and TIME? Why is Query Analyzer only returning 255 characters? Why should I avoid NULLs in my database? How do I deal with an apostrophe (') in a SQL statement?