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
-----Original Message-----
From: alex poyaoan [mailto:[EMAIL PROTECTED]
Sent: 23 April 2008 09:42
To: CF-Talk
Subject: problem with passing variables to action template
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:304053
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
