Would this part of a cffunction create
individual session variables from the query?
<cfquery name="get_agent" datasource="c21ar">
SELECT *
FROM our_agents
WHERE website = '#arguments.website#'
</cfquery>
<cfset session.get_agent = get_agent />
<cfif get_agent.recordCount>
<cfreturn session.get_agent/>
Back on the invoking page, the returnvariable
is 'get_agent'.
I've tried to access the specific field data
from the cfreturn as session variables, such as:
session.agent_header (agent_header is defined by the query)
but I'm getting an error that session.agent_header isn't defined.
Based on the cfdump data, it looks like the entire query is becoming
a session variable (???) rather than getting all the query data
defined as individual session variables.
I'm trying to get...
session.agent_header = '#get_agent.agent_header#'
session.first_name = '#get_agent.first_name#'
without manually coding all the variables.
etc.
Thanks,
Rick
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:307582
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
