Part of my problem is database design, where CSV lists are allowed in a field name. I know I have to correct this and create a separate table.
However, for now, some of the records are quite long. For example here's the unabridged record that I alluded to in my previous message: Tall Whitetop, Tall Pepperweed, Perennial Pepperweed, Giant Whiteweed, Perennial Peppergrass, Slender Perennial Peppergras, Broadleaf, Broad-leaved Pepperweed, Ironweed). So, you can imagine this list would stretch across the screen. So, that's why I need to break apart the list. If the entires were shorter, I would use the simple method you pointed out. Any other suggestions? Thanks. Thomas Chiverton wrote: >>After querying the database, I want to loop over these records and >>output them in the following format, so that I can use them in a Select >>List: >> > >Any reason not to just do something like this, or use <cfselect> : > ><select> ><CFOUTPUT QUERY="getcommonnames"> > <option>#Common_Names#</option> ></CFOUTPUT> ></select> > >? > >Tom Chiverton >You don't have to be a mad scientist to believe in ColdFusion > > > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
