cfoutput queries

hi.

i'm testing my components by invoking them from within CF. everything is working except on certain components i am getting this error:

Complex object types cannot be converted to simple values.

is there a way around this so i can see the values i'm trying to return?

what i'm looking for it to return is this:

windows xp

OS version

and my query looks like this:

SELECT event_data, event_type, COUNT(*) AS count
FROM myTable

where event_data would return "windows xp" and event_type would return "OS version".

thanks for any help.

fumeng.

wait -- i'm now using cfdump var and it's returning my arrays perfectly. one little issue, though:

COUNT EVENT_DATA EVENT_TYPE
13 Windows XP OS version

it returns the above. any way to easily remove the extra text and only return "Windows XP" and "OS version"??

thanks again!

You cant remove labels from a cfdump, cfdump is only used for debugging.

You can however loop over structures using cfloop
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-p81.htm

You can also reference an item in a structure by its location.
This might be what your looking for
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/reusec13.htm

hi atomi. i just wanted to say thanks for passing along these links...very helpful. i appreciate your reply.

fumeng.

Sounds good, thank you.