> Seems like everytime I try to do this, I muck the syntax or can't quite > find the exact documentation. How do you treat a query as a structure:
> <cfquery ... name="test"> > SELECT field1, field2 FROM myTable WHERE 0 = 0 > </cfquery> > <!--- these all return false ---> > <cfoutput> > #isStruct(test)#<br> > #isArray(test)#<br> > <br><br> > #isStruct(test['field1'])#<br> > #isArray(test['field1'])#<br> > </cfoutput> Hmm... Well... The array functions can be used on query columns, although I don't think IsArray() would work, or for that matter isStruct()... If you declare isStruct(queryname) or isArray(queryname) they're going to be false because you're passing them a query. If you delcare isArray(queryname['columnname']) it's going to return false because it's going to evaluate the _value_ contained in the first row of that column of that query, which is going to be a string rather than an array... Is there a particular reason you need to get the "isarray" information from a query column? or can you just use the other array functions to get what you need? The easiest way to actually create an array is to use ListToArray(ValueList(myquery.mycolumn)) if necessary... I wouldn't expect there to be much in the way of documentation on this issue specifically ... There's documentation on each of the functions and on queries of course, but I wouldn't expect any of that documentation to cover this explicitely... Isaac Dealey Certified Advanced ColdFusion Developer www.turnkey.to 954-776-0046 ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
