That's your update query, however where's the query that shows the information? On the previous page? http://inside.3i-online.com/reps_test/GetReps_Query_Next.cfm?CFID=1983502&CFTOKEN=22280223
Are you using <cflocation> ? On 2/8/07, John Eubanks <[EMAIL PROTECTED]> wrote: > >so whats the query that you have thats generating that page? > > > >On 2/7/07, John Eubanks <[EMAIL PROTECTED]> wrote: > >> > Greg, > > Here is the query: > > <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:2495 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
