>to update multiple rows?
>Do a google search for something like "coldfusion update multiple form rows"
>
>You'll get some good ideas there
>
>
>On 2/8/07, John Eubanks <[EMAIL PROTECTED]> wrote:
>>
Greg, thanks for the help. It is very much appreciated. I got most of it
working. However, this is the error I get now. Any ideas?
###################################################################################
Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near
','.
The error occurred in E:\InetUsers\CIC\reps_test\GetReps_Action_Next.cfm: line
18
16 : Update
RepFinder_Basic.FirstName,RepFinder_Basic.LastName,RepFinder_Basic.Region,RepFinder_Basic.RepId,RepFinder_Ext.FirstName,RepFinder_Ext.LastName,RepFinder_Ext.Region,RepFinder_Ext.RepId,RepFinder_Ext.Phone,RepFinder_Ext.Ext,RepFinder_Ext.BegZip,RepFinder_Ext.EndZip
17 : 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)#'
18 : WHERE RepFinder_Ext.BegZip = #Evaluate("Form.BegZip" &
ThisRow)# AND RepFinder_Ext.EndZip = #Evaluate("Form.EndZip" & ThisRow)#
19 : </cfquery>
20 : </cfloop>
--------------------------------------------------------------------------------
SQL Update
RepFinder_Basic.FirstName,RepFinder_Basic.LastName,RepFinder_Basic.Region,RepFinder_Basic.RepId,RepFinder_Ext.FirstName,RepFinder_Ext.LastName,RepFinder_Ext.Region,RepFinder_Ext.RepId,RepFinder_Ext.Phone,RepFinder_Ext.Ext,RepFinder_Ext.BegZip,RepFinder_Ext.EndZip
Set RepFinder_Basic.FirstName = 'Jaso',RepFinder_Basic.LastName =
'Brown',RepFinder_Basic.Region = '842',RepFinder_Basic.RepId =
'7110',RepFinder_Ext.FirstName = 'Jaso',RepFinder_Ext.LastName =
'Brown',RepFinder_Ext.Region = '842',RepFinder_Ext.RepId =
'7110',RepFinder_Ext.Phone = '800-443-8166',RepFinder_Ext =
'5267',RepFinder_BegZip = '29000',EndZip = '29699' WHERE RepFinder_Ext.BegZip =
29000 AND RepFinder_Ext.EndZip = 29699
DATASOURCE 3iReps
VENDORERRORCODE 102
SQLSTATE HY000
####################################################################################
It looks like it is having issues with the Where clause, but everything looks
fine.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:2503
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
