I know this isn't exactly what you want, but don't forget you can dump one row, the top row, if you use top=1 in your cfdump tag. It will limit the dump of the query to 1 row. Useful for seeing a part of the query in your dump.
On Tue, Jan 6, 2009 at 8:25 AM, Andy Matthews <[email protected]> wrote: > 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:317456 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
