var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Selecting specific number of rows from a table
Is there a way one can specify the number of rows to be selected.
Reason being I'm displaying results in multiple pages.
Say I want to select rows 20-30 from the recordset.
Currently I'm using a variable to keep track of the FromRow and scrolling to that Row, however is there a way to directly jump to that row?
how you do (effectively) will depend on the particular database system you're using
in MySQL, you can use LIMIT 19,11
there's nothing in standard SQL
see, this is why it helps to post in the correct forum -- the SQL forum is not for Microsoft SQL Server, it is for the SQL language
You could look into using a cursor. Fetch the number of rows you want. If you want some more rows, leave the cursor open and fetch some more.