This is DB specific. What database are you using?
**************************
Billy Cravens
Web and Software
consulting
www.Architechx.com
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf
Of FlashGuy
Sent: Tuesday, October 29, 2002
11:12 AM
To: FlashMX
Subject: Reading database and
inserting fields into another database
HI,
I need to read in the field "env_var" from one database
("data1") and insert the results into another database as a
comma-delimited text.
<cfquery name="GetAlias" datasource="data1"
dbtype="ODBC">
SELECT env_var
FROM data1
</cfquery>
Output example:
file1 file2 file3 file4 file5 etc...
Insert results of GetAlias.env_var into database ("data2") into field
"strVar" as a comma-delimited field.
strVar = "file1,file2,file3,file4,file5,etc...
Can I do this with just one <cfquery or do I need antoerh <cfquery with a
INSERT?
