From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ajas
Mohammed
Here is my assumption for your scenario. Lets say datasource1 is for
database A, and the other datasource2 is for database B.
If you want to copy a table from datasource1 to datasource2, I would do
this in SQL Server(I dont know what db you are using)
<cfquery datasource="#dsn#"
select * into B..testdummy
from A..testdummy
</cfquery>
I havent done this in CF, but I do this a lot in Query Analyzer. Helps
me create a table with same definition/structure in another database. If
you dont want to import data, then you can add a where clause like this
Okay, let me confirm I understand.
<cfquery name="PSAD" datasource="DS1">
Select * FROM table1
</cfquery>
<cfquery name="PSA2" datasource="DS2">
Select * FROM table2
</cfquery>
PSAD.RecordCount = 10,032
PSA2.RecordCount = 0
Column Names are the same.
You are saying I can do ...
<cfquery name="PSA2" datasource="DS2">
Select * into ds2..table2 FROM ds1..table1
</cfquery>
Hmmm. Gave me an error.
-------------------------------------------------------------
Annual Sponsor FigLeaf Software - http://www.figleaf.com
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-------------------------------------------------------------
