I am going to try the different solutions suggested here and will get back to the list. So far, there's something missing in all the solutions, but I hope to have this worked through. Thanks for your patience.
Chris Lofback wrote: >How about a list loop like this: > ><SELECT NAME="Foo"> ><CFLOOP LIST="#MyQuery.ListField#" INDEX="Item"> > <OPTION>#Item#</OPTION> ></CFLOOP> ></SELECT> > >Or if you just want the items without the select, like this: > ><CFLOOP LIST="#MyQuery.ListField#" INDEX="Item"> > <BR>#Item# ></CFLOOP> > >Chris Lofback >Sr. Web Developer > >TRX Integration >28051 US 19 N., Ste. C >Clearwater, FL 33761 >www.trxi.com > > >>-----Original Message----- >>From: Shirley [mailto:[EMAIL PROTECTED]] >>Sent: Friday, September 20, 2002 8:20 AM >>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 >>> >>> >>> >>> >>> > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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
