not seeing the need to convert the query to a struct.
<cfset session.myQuery = myQuery />
<cfoutput query="session.myQuery">
#session.myQuery.ID# #session.myQuery.name#<br />
(or, if you don't want to fully qualify the names...)
#ID# #name#<br />
</cfoutput>
depending on how your app is structured, you may need to do some checking
before placing the query into the session. maybe something like:
<cfif not structKeyExists(session, 'myQuery')>
<cfset session.myQuery = myQuery />
</cfif>
On Mon, Mar 9, 2009 at 11:33 AM, Scott Stewart <[email protected]>wrote:
>
> I've got a query that returns two fields for each record (id, name). There
> can be several records returned
>
> Because of the way that the site is set up I need to dump the results into
> the session scope and then loop over them on an output page
>
>
>
> I think I over complicated it by using Ben Nadel's QueryToStruct script.
>
>
>
> Is there a simple way to do this?
>
>
>
> --
> Scott Stewart
> ColdFusion Developer
> 4405 Oakshyre Way
> Raleigh, NC 27616
> (h) 919.874.6229 (c) 703.220.2835
>
>
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320297
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
