Access.
Should I install MySQL for Windows?
--Original Message Text---
From: Billy Cravens
Date: Tue, 29 Oct 2002 11:46:56 -0600
Clean Clean DocumentEmail MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman";}
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?
---------------------------------------------------
Colonel Nathan R. Jessop
Commanding Officer
Marine Ground Forces
Guatanamo Bay, Cuba
---------------------------------------------------
---------------------------------------------------
Colonel Nathan R. Jessop
Commanding Officer
Marine Ground Forces
Guatanamo Bay, Cuba
---------------------------------------------------
