You might consider this appraoch as recommended by Jeff Beer:
And I quote......................
------------------------------------
You could do the same thing in CF like this:
<cfquery name="qryName" datasource="myDSN">
INSERT INTO tblAll (fieldname1, fieldname2, fieldname3 [...])
VALUES (SELECT fieldname1, fieldname2, fieldname3 [...] FROM tblCurrent)
</cfquery>
Just be sure the field names are in the same order in both lists.
------------------------------------------------------------
All the best,
Steve
> I want this data to go into a new table,
> <cfquery name="new" datasource="healthmart98" dbtype="ODBC">
> SELECT
>
Provider,DRGCD,Total_Cases,PCDTHS,Expected_PCDTH,PCDTH_Rating,AvgLOS,MedLOS,
>
MaxLOS,MinLOS,Expected_LOS,LOS_Rating,AvgCHG,MedCHG,MaxCHG,MinCHG,Expected_C
> HG,CHG_Rating
> FROM Region10Hospitals
> </cfquery>
> <cfinsert datasource="healthmart98" tablename="region10severity"
> dbtype="ODBC" dbname="healthmart98"
>
formfields="Provider,DRGCD,Total_Cases,PCDTHS,Expected_PCDTH,PCDTH_Rating,Av
>
gLOS,MedLOS,MaxLOS,MinLOS,Expected_LOS,LOS_Rating,AvgCHG,MedCHG,MaxCHG,MinCH
> G,Expected_CHG,CHG_Rating">
>
>
>
> Is this right?
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
