Use ValueList() e.g
<cfset myList = ValueList(GetEnv.strVar)> ----- Original Message ----- From: "FlashGuy" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, October 22, 2002 12:33 PM Subject: Read from database and insert into string > Hi, > > I need to read from my database the field strVar. I have 500+ entries. I need to read every line from the database, grab the contents of that field and put all the data into a > variable called "results". They must all be comma delimited. > > <cfquery name="GetEnv" datasource="database-name" dbtype="ODBC"> > SELECT strVar,strDestination > FROM users > </cfquery> > > Do I need to loop through it? > > Example: > > variable = "var1,var2,var3,var4...etc" > > > > > > --------------------------------------------------- > Colonel Nathan R. Jessop > Commanding Officer > Marine Ground Forces > Guatanamo Bay, Cuba > --------------------------------------------------- > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
