>How about
>
>INSERT INTO new_table SELECT * FROM old_table
Yep, that was it - thank you.
I had done:
insert into timesheets_tmp
(timesheet_id,id,date_added,entry_date,type,hours,minutes,notes,signoff)
(
select
timesheet_id,id,date_added,entry_date,type,hours,minutes,notes,signoff
from timesheets
)
I guess I wasn't thinking INSERT and I should've been.
thanks again -and a good weekend to y'all.
daniel
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Enterprise web applications, build robust, secure
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287526
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
