Re: CF Structures.. brain fried
not seeing the need to convert the query to a struct. #session.myQuery.ID# #session.myQuery.name# (or, if you don't want to fully qualify the names...) #ID# #name# depending on how your app is structured, you may need to do some checking before placing the query into the session. maybe something like: On Mon, Mar 9, 2009 at 11:33 AM, Scott Stewart 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
RE: CF Structures.. brain fried
Probably you can just assign the query to a session variable: Then output the query: You don't need to change the query itself into structures. -- Josh -Original Message- From: Scott Stewart [mailto:sstwebwo...@bellsouth.net] Sent: Monday, March 09, 2009 11:33 AM To: cf-talk Subject: CF Structures.. brain fried 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:320298 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CF Structures.. brain fried
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. #session.myQuery.ID# #session.myQuery.name# (or, if you don't want to fully qualify the names...) #ID# #name# depending on how your app is structured, you may need to do some checking before placing the query into the session. maybe something like: On Mon, Mar 9, 2009 at 11:33 AM, Scott Stewart 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
Re: CF Structures.. brain fried
Scott Stewart wrote: > Charlie, Josh > > This worked perfectly... I didn't know that you just dump the query into the > session scope You can dump anything into the session scope. ~| 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:320301 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF Structures.. brain fried
Scott Stewart wrote: > Charlie, Josh > > This worked perfectly... I didn't know that you just dump the query into the > session scope You can dump anything into the session scope. ~| 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:320303 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4