RE: [Rainbowportal-devel] record paging, advise wanted.

[Thierry \(Tiptopweb\) <th...@ti...>]

There is a paging interface in the UI directory of Rainbow project
It is working on datalist I think and you just have to inherit from it and
add an event handler from what I can remember.
It is used for the Picture module.
Would that be good enough?
Thierry

-----Original Message-----
From: rai...@li...
[mailto:rai...@li...]On Behalf Of
Chris Farrell
Sent: Tuesday, 20 April 2004 6:04 AM
To: rai...@li...
Subject: [Rainbowportal-devel] record paging, advise wanted.


Has anyone implemented paging for records?

I have found several methods, most are inadequate.
1:  It is a datalist not a datagrid.  The datagrid has built in paging,
data list does not.  I would
prefer to stick with a datalist as it is faster and means less re-writing
of code.  Worst case senario
I'll use this.

2:  Some methods that work at the sproc level assume a contigious identity
field.  Something
like SELECT * FROM table WHERE IdentityField > start AND IdentityField < end
What if I delete records 1-5, then page 1 only returns 5 records.

3:  Creating an entire temp table with its own Identity field, copying ALL
records and using that table
for the query shown in #2 so that you are guaranteed to get the right
number of records even if there
are holes in the original table's identity field from deleted records.  I
highly doubt that there is a worse
solution than this.

There has got to be a way to do this.  It is just too common of a problem
to not have an available solution.
I would be surprised if this is a feature not addressed in SQL Server but I
cannot find it.

Help!

Chris Farrell




-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
_______________________________________________
Rainbowportal-devel mailing list
Rai...@li...
https://lists.sourceforge.net/lists/listinfo/rainbowportal-devel