In <000201bfaec8$43a2d3e0$2c044ed8@bull-god>, Kris Seaney
([EMAIL PROTECTED]) in a fit of unbridled passion, wrote:
> 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?
So complicated.
Do a "select * from table1 into table2" .. customize to your particular
needs.
------------------------------------------------------------------------------
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.
