OK, going on 2.5 hrs with no luck trying to update one table's state field from another table (only matching field is company name).. any pointesr would be appreciated:
<cfquery name="david" datasource="#SalesPerson_DB#"> SELECT state, companyname FROM davids_excel where companyname=companyname </cfquery> <cfquery name="contact_detail" datasource="#SalesPerson_DB#"> SELECT state, company_name FROM contact_detail where company_name=company_name </cfquery> <CFLOOP Query="contact_detail"> <CFQUERY NAME="david" DATASOURCE="#SalesPerson_DB#"> UPDATE contact_detail SET state=#state# where '#contact_detail.company_name#'='#david.companyname#' </cfquery> </CFLOOP> Tim ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187799 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54