>How are you getting from page one to page two? > >You're using URL vars in the second page so I'm guessing a link of some >sort? > >Page 1: > >QUERY HERE > ><cfloop query="yourQuery"> > <a href="page2.cfm?tid=#yourQuery.tid#">Do something</a><br /> ></cfloop> > >If that's not enough, supply more info about your problem. > >Adrian
that solved it thanks > >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# ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:304055 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
