If it's in the DB as a list, why not pull it out and then loop through it putting a <br> after each iteration of the loop?
Ade -----Original Message----- From: Shirley [mailto:[EMAIL PROTECTED]] Sent: 20 September 2002 13:20 To: CF-Talk Subject: Re: Looping 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 > > > > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
