>If you got an error message about the where statement, it may also mean >that there is a problem in the query that ends with the where statement. >So, it may not be the where clause that is causing the problem. > >1) Are you updating the name in two different tables? What about >normalization? > >2) I tried using this query on some test data and finally got it to >work. But I had to remove all apostrophes in my data. For instance, >O'Bryan had to be changed to Obryan and Renee' had to be changed to >Renee. Anyone know how to fix this? I tried preservesinglequotes, but >that did not work. >Zelda > >Zelda,
Yes, I am trying to do an update on two tables. However, I was told that the only way to do this is to run two cfquery's and perform two updates within the same cfloop. I would think there would be an easier way to do it. > > >-----Original Message----- >From: John Eubanks [mailto:[EMAIL PROTECTED] >Sent: Thursday, February 08, 2007 12:01 PM >To: CF-Newbie >Subject: Re: Extreme Help > > >Wilfred, > >Many thanks for the insight. I have it pulling everything through the >form, but for some reason it gets stuck on the where clause: > > <cfloop from = "1" to = "#LoopCount#" index="ThisRow"> > <cfquery name="Update" datasource="3iReps"> > Update RepFinder_Basic.*,RepFinder_Ext.* > Set RepFinder_Basic.FirstName = >'#Evaluate("Form.FirstName" & ThisRow)#',RepFinder_Basic.LastName = >'#Evaluate("Form.LastName" & ThisRow)#',RepFinder_Basic.Region = >'#Evaluate("Form.Region" & ThisRow)#',RepFinder_Basic.RepId = >'#Evaluate("Form.RepId" & ThisRow)#',RepFinder_Ext.FirstName = >'#Evaluate("Form.FirstName" & ThisRow)#',RepFinder_Ext.LastName = >'#Evaluate("Form.LastName" & ThisRow)#',RepFinder_Ext.Region = >'#Evaluate("Form.Region" & ThisRow)#',RepFinder_Ext.RepId = >'#Evaluate("Form.RepId" & ThisRow)#',RepFinder_Ext.Phone = >'#Evaluate("Form.Phone" & ThisRow)#',RepFinder_Ext = >'#Evaluate("Form.Ext" & ThisRow)#',RepFinder_BegZip = >'#Evaluate("Form.BegZip" & ThisRow)#',EndZip = '#Evaluate("Form.EndZip" >& ThisRow)#' > WHERE RepFinder_Ext.BegZip = '#Evaluate("BegZip" >& ThisRow)#' AND RepFinder_Ext.EndZip = '#Evaluate("EndZip" & ThisRow)#' > </cfquery> > </cfloop> > >value="#getQuery.id#"> >></cfoutput> >> >>You will need to know how many records you will be updating. So make a > >r ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2509 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
