What about:
INSERT INTO table1 (col1, col2, col3... )
SELECT col1, col2, col3....
FROM table2
HTH,
Duane Boudreau,
Chief Techical Re-Director
HexaInteractive, LLC
http://www.hexainteractive.com
603.620.8797
-----Original Message-----
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 28, 2001 12:35 PM
To: CF-Talk
Subject: Duplicating database row
Howdy all. Is there an easy way to duplicate a row in a database
rather than querying for a record then doing an insert of a new
record with identical data? Something that will work in both Access
and SQL Server would be great.
Thanks,
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
