> I was thinking there is a problem with the display user page.. > I choose "edit", "southeast", "Joe Radman" and nothing gets displayed > on the next page... > When I choose Jon-Erik Eide a bunch of rows show up for him.. > I clicked the top one, changed his last name of Eide2 and > here's the generated query..... > Update RepFinder_Basic.FirstName,RepFinder_Basic.LastName, > RepFinder_Basic.Region,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 = > 'Jon-Erik,Jon-Erik,Jon-Erik,Jon-Erik,Jon-Erik,Jon-Erik,Jon-Erik, > Jon-Erik,Jon-Erik',RepFinder_Basic.LastName > = 'Eide2,Eide,Eide,Eide,Eide,Eide,Eide,Eide,Eide',RepFinder_Basic. > Region > = '843,843,843,843,843,843,843,843,843',RepFinder_Basic.RepId = > '7149,7149,7149,7149,7149,7149,7149,7149,7149',RepFinder_Ext. > FirstName > = 'Jon-Erik,Jon-Erik,Jon-Erik,Jon-Erik,Jon-Erik,Jon-Erik,Jon-Erik, > Jon-Erik,Jon-Erik',RepFinder_Ext.LastName > = 'Eide2,Eide,Eide,Eide,Eide,Eide,Eide,Eide,Eide',RepFinder_Ext. > Region > = '843,843,843,843,843,843,843,843,843',RepFinder_Ext.RepId = > '7149,7149,7149,7149,7149,7149,7149,7149,7149',RepFinder_Ext.Phone = > '800-443-8166,800-443-8166,800-443-8166,800-443-8166,800-443-8166, > 800-443-8166,800-443-8166,800-443-8166,800-443-8166',RepFinder_Ext > = '5235,5235,5235,5235,5235,5235,5235,5235,5235',RepFinder_BegZip = > '32000,32600,32949,32959,32972,32977,32979,34400,34700',EndZip = > '32399,32947,32956,32959,32975,32977,32999,34499,34799' WHERE > RepFinder_Basic.RepId IN > (7149,7149,7149,7149,7149,7149,7149,7149,7149) > > probably not what you want to see...... > > > > On 2/7/07, John Eubanks <[EMAIL PROTECTED]> wrote: > > >need to see your query.. I'm betting a join is off or something > simple like that > > > > > >On 2/7/07, John Eubanks <[EMAIL PROTECTED]> wrote: > > >> > > Here is the query: It is long, but I wasn't sure what else to do. > > > > <cfquery name="Update" datasource="3iReps"> > > Update RepFinder_Basic.FirstName, > RepFinder_Basic.LastName,RepFinder_Basic.Region,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 = '#Form. > RepFirstName#',RepFinder_Basic.LastName = '#Form.RepLastName#', > RepFinder_Basic.Region = '#Form.RepRegion#',RepFinder_Basic.RepId = > '#Form.RepId#',RepFinder_Ext.FirstName = '#Form.RepFirstName#', > RepFinder_Ext.LastName = '#Form.RepLastName#',RepFinder_Ext.Region = > '#Form.RepRegion#',RepFinder_Ext.RepId = '#Form.RepId#',RepFinder_Ext. > Phone = '#Form.Phone#',RepFinder_Ext = '#Form.Ext#',RepFinder_BegZip = > '#Form.BegZip#',EndZip = '#Form.EndZip#' > > WHERE RepFinder_Basic.RepId IN (#Form. > RepId#) > > </cfquery> > > > > And, that is the page where I am having the issues. With the multiple checkboxes. If I just check one or check all of them to update, then it is the processing of that query to do the update.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:2492 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
