Re: How to cfdump a single row in a query?
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 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:dwa...@figleaf.com] > 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
RE: How to cfdump a single row in a query?
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:dwa...@figleaf.com] 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
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:317443 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How to cfdump a single row in a query?
try myQuery[myQuery.CurrentRow] 2009/1/6 Pete Ruckelshaus > 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? > > Thanks > > Pete > > ~| 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:317440 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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? Thanks Pete ~| 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:317439 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4