Just be careful. You can't use SELECT * .... if you have a primary key
(I know YOU didn't use select * . I added this comment for those who might
fall into that trap like I did the first time)
Don
----- Original Message -----
From: "Duane Boudreau" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, May 28, 2001 10:32 PM
Subject: RE: Duplicating database row
> 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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists