Charlie, Josh This worked perfectly... I didn't know that you just dump the query into the session scope
Thanks a million sas -- Scott Stewart ColdFusion Developer 4405 Oakshyre Way Raleigh, NC 27616 (h) 919.874.6229 (c) 703.220.2835 -----Original Message----- From: Charlie Griefer [mailto:charlie.grie...@gmail.com] Sent: Monday, March 09, 2009 2:40 PM To: cf-talk Subject: Re: CF Structures.. brain fried 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 <sstwebwo...@bellsouth.net>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:320299 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
