Rick,
What you have literally done is switch scopes on your query variable:
<cfquery name="get_agent" datasource="c21ar">
SELECT *
FROM our_agents
WHERE website = '#arguments.website#'
</cfquery>
<cfset session.get_agent = get_agent />
get_agent is actually, variables.get_agent, which is a query object.
You then copied it into the session scope. To break out all the
individual columns of the query into separate session vars you will
either need to hardcode each of them, or loop over the
queryname.columnlist and set each session var dynamically.
--
Alan Rother
Adobe Certified Advanced ColdFusion MX 7 Developer
Manager, Phoenix Cold Fusion User Group, AZCFUG.org
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307583
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
