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