HI, all.
When I click a link a the page containing the code below, I don't
get a change of client information to the new client, whose Client_ID
is contained in the clicked URL.
The information on the screen remains the same.
Could that be a problem with this query? Should it be a left join
instead of an outer join?
I checked to see if the Client_ID was being passed and reassigned
to the Session.Client_ID variable and it is.
Could it be this query?
Thanks,
Rick
<CFQUERY Name="Get_Client" Datasource="#DSN#">
Select C.*, FG.*, E.*
from clients C
inner join family_groups FG, employers E
on C.Family_ID = FG.Family_ID
and C.Employer_ID = E.Employer_ID
where C.Family_ID =
(Select Family_ID
from clients
where Client_ID = '#Session.Client_ID#')
and C.Employer_ID =
(Select Employer_ID
from clients
where Client_ID = '#Session.Client_ID#')
</CFQUERY>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263551
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
