Look into the ValueList() function, which takes a query.column and converts
it into a comma-delimited list/string. If you want each list item to be
quoted, than use the QuotedValueList() function. So, your code would look
like:
<cfquery name="GetEnv" datasource="database-name" dbtype="ODBC">
SELECT strVar,strDestination
FROM users
</cfquery>
<CFSET results = ValueList(GetEnv.strVar)>
--
Mosh Teitelbaum
evoch, LLC
Tel: (301) 625-9191
Fax: (301) 933-3651
Email: [EMAIL PROTECTED]
WWW: http://www.evoch.com/
> -----Original Message-----
> From: FlashGuy [mailto:flashmx@;rogers.com]
> Sent: Tuesday, October 22, 2002 12:33 PM
> To: CF-Talk
> 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
