cfoutput queries

[fumeng]

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.

 

[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!

 

[Harrison]

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

 

[fumeng]

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

fumeng.

 

[Harrison]

Sounds good, thank you.