so whats the query that you have thats generating that page? On 2/7/07, John Eubanks <[EMAIL PROTECTED]> wrote: > > 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:2493 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
