Hi Bud,
I believe what you could do is an INSERT with a select command embedded into
it.
For example:
INSERT INTO (column list)
VALUES (select column list from whatever where whatever condition)
Of course, the syntax isn't right, but the concept should work.
---mark
------------------------------------
Mark Warrick - Fusioneers.com
Email: [EMAIL PROTECTED]
Phone: 714-547-5386
http://www.fusioneers.com
http://www.warrick.net
====================================
> -----Original Message-----
> From: Bud [mailto:[EMAIL PROTECTED]]
> Sent: Monday, May 28, 2001 9:35 AM
> 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
