Terry,
Try doing a Insert / Select query. The syntax is like this:
INSERT INTO TableName (Field1, Field2, Field3, Field4)
SELECT TableName.Field1, TableName.Field2, '#Form.FieldName#' AS Field3, (Attribute1 + Attribute2) AS Field4
FROM TableName
Basically, you can use any functions that are native to your DBMS in the select statement for the values. If you have form data or any plain text that you need to copy, refer to the example for field3. Same thing for your derived fields.
Jordan
Terry Blake <[EMAIL PROTECTED]> wrote:
Terry Blake <[EMAIL PROTECTED]> wrote:
Is there a way to copy a sql record(s)? Right now I just do a cfquery and then loop over <query>insert...</query> to create the new records. This works but there must be a better way.Thanks for any help!Terry
