I'd like to copy some data from one table to another.
The tables are in separate datasources.
If they were in the same DSN, I'd do:
INSERT INTO TABLEB (
SELECT * FROM TABLE A WHERE COLUMN = 'CONDITION'
)
Since they're in separate DSN's, is there any way I can do this without
doing one query, and looping over it with an insert?
Thanks,
Evan
--
-=-=-=-=-=-=-=-=-=-
Evan Lavidor
Circle.com Boston
Tel: 617-585-3107
Fax: 617-585-3091
-=-=-=-=-=-=-=-=-=-
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
