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> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:2491 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
