Hi every body have this problem and couldn't find the solution have one table to update with data from another table
have two templates the first has two queries which are <cfquery name="get" datasource="source"> select tid, name FROM info WHERE 1id=10 </cfquery> <CFQUERY NAME="Check" datasource="source"> SELECT 1id, 2id FROM tb2 WHERE Nome LIKE '%#RECORD#%' </CFQUERY> on the second template I have this update query but data should be coming from the first template how could I pass the values of 1id and 2 id to update it on the info table? will i use cfparam for it UPDATE info SET 1ID=#url.id1# WHERE tid=#url.tid# AND 2ID=#url.id2# WHERE tid=#url.tid# thanks ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304049 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4