Thank you all who answered! This list would probably be up to 350 items.. so I was thinking that might be a bit much.
I suspect if I dig around with the SQL a bit more, I can get the results I desire... Yves On Fri, 4 Feb 2005 14:54:08 -0500, Jim Davis <[EMAIL PROTECTED]> wrote: > > -----Original Message----- > > From: Yves Arsenault [mailto:[EMAIL PROTECTED] > > Sent: Friday, February 04, 2005 2:43 PM > > To: CF-Talk > > Subject: A brief question about lists > > > > Hello, > > > > I was wondering if there are any guidelines, or limits in how many > > items can be in a list in a CF variable. > > I don't believe there is a limit (beyond hardware system limits) for size. > > I once ran a code challenge to tally the number of words in an arbitrary > piece of text (for example "the" appears 35 times, "We" appears 3 times, > etc) > > This was in CF 4.5/5.0 at the time (but I don't think it mattered) but one > of the entries treated the text as a space-delimited list and looped over > it. It worked just fine (and was actually one of the fastest entries) with > text strings as large as the full novel "Call of the Wild". > > I've also successfully done log file parsing in CF treating log files (even > large ones) as carriage-return-delimited lists. > > In other words list can be very, very large. ;^) > > Jim Davis > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193133 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54