I build up a query where everything is applied dynamically. <cfquery name="alphas" datasource="#dsn#"> SELECT #alpha# FROM #table# ORDER BY #alpha# </cfquery>
Works great and returns what I want. If I use this I can loop over the query and output the contents. <cfloop query="alphas"> <cfoutput>#Evaluate(alpha)#</cfoutput><br> </cfloop> I could use this to build a list as well but would rather use the intrinsic functions but I can't figure out what to pass to valueList. Any ideas? Shawn McKee Manager, Web Development NewsStand, Inc. 8620 Burnet Rd., Suite 100 Austin, TX 78757 USA 512-334-5100 Read newspapers and magazines from around the world in a whole new way. NewsStand delivers them to your PC without paper and without delay! Try: http://www.newsstand.com?NSEMC=EMNSI000001 ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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