Here's code on CFLib which converts a query row into a struct. You could then dump the struct:
http://cflib.org/udf/QueryRowToStruct andy -----Original Message----- From: Dave Watts [mailto:[email protected]] Sent: Monday, January 05, 2009 10:11 PM To: cf-talk Subject: Re: How to cfdump a single row in a query? > I'm using cfloop to go through a query result set. Some of the data > is giving me trouble...is there a way to use cfdump to dump out the > contents of the current row in the recordset? No, I don't think so. There's no object that corresponds to a row, within a query object. That said, you could put something together pretty quickly to do this. It would simply loop over the column list, then use array notation to display the current row's value for each column. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:317448 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
