I there a way to break it up the list? Some form of categories, perhaps?
For instance, if a bookstore just put books in one big pile on the
floor, they would never sell anything because they wouldn't be able to find
it. Typically they are categorized (Fiction, non-fiction at the most basic
level, then other categories.. fiction is general fiction, mystery sci-fi..
non-fiction is health, self-help.., then by author's last name underneath
that).
Other businesses have similar forms of categorization. Just an idea. I
imagine that if the client has that much inventory it must already be
categorized in some way.
At 06:18 PM 04/11/2001 -0500, you wrote:
>I wanted to get everyones input on this as Im sure this is a pretty common
>scenario. I have plenty of clients that have e-commerce sites or intranet
>sites that need to pull large recordsets. For Example, they might need to
>view their inventory so they can edit or delete one record. The problem is,
>once the inventory gets to 1000 or 5000 records or more, downloading this as
>one big list is unrealistic. I have done the whole NEXT--> 10 records or
>whatever (which I hate), and I could also do a search so they can search by
>product name or ID. But is there a better way to pull this kind of data and
>how do you manage the updates/inserts? Could you use a java/wddx thing to
>download the recordset once and then browse it on the client side (I think
>Ben Fortas Advanced CF Construction Kit has something like this) and Ive
>also seen an ActiveX/VBScript version of this.
>
>So what is an easy, intuitive way for the client to manage these large
>recordsets and perform updates/deletes?
>
>Please reply to [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> . Any code or
>examples would be appreciated.
>
>Thanks,
>-Craig
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists