using tables in multiple databases

[davejoyce]

Is there a way to select data from a table in database a and insert into a table in database b. For use in archiving for instance. Each database has a seperate DSN.<br><br>&lt;CFQUERY NAME=&quot;GetStatusData&quot; DATASOURCE=&quot;Sites&quot;&gt;<br>INSERT INTO GeneralArchive.StatusSnapshot_tbl (SnapshotDate, Plant, week, status, statusdate)<br> SELECT #Now()#, plant, '1',<br>&lt;!--- #DateDiff(&quot;WW&quot;, Start_Date, Now())# + 1, ---&gt;<br> status, status_date<br> FROM&nbsp;&nbsp;checklist_tbl<br> where N1 &lt;&gt; 'C' <br> ORDER by plant<br>&lt;/cfquery&gt;<br><br>&nbsp;&nbsp;&nbsp;&nbsp; <p>Dave Joyce<br><a href=mailtoaveJoyce@hotmail.com>DaveJoyce@hotmail.com</a><br><a href= > </a><br>

 

[SnakeHollywood]

Yes you simply do<br>&lt;cfoutput query=&quot;query1&quot;&gt;<br><br>&lt;cfquery&gt;<br>INSERT into table2 (column1)<br>VALUES(query1column1)<br>&lt;/cfquery&gt;<br><br>&lt;/cfoutput&gt;<br><br>In query1 just give your columns an alias so that they are not the same name as the table you are inserting into.<br><br> <p>Russ Michaels<br><a href=mailto:russ@satachi.com>russ@satachi.com</a><br><a href=

http://www.satachi.com>Satachi

Internet Development</a><br>For my personal book recommendations visit

http://www.satachi.com/books.html<br>

<br>