Daniel,
You need to manually convert it to a query, here's some code:
<cfset qryStruct = getMetaData(myQuery)>
<cfset metaQry = queryNew("IsCaseSensitive,Name,TypeName")>
<cfset QueryAddRow(metaQry, arrayLen(qryStruct))>
<cfloop from="1" to="#arrayLen(qryStruct)#" index="i">
<cfset QuerySetCell(metaQry, "IsCaseSensitive",
qryStruct[i]["IsCaseSensitive"],i)>
<cfset QuerySetCell(metaQry, "Name",
qryStruct[i]["Name"],i)>
<cfset QuerySetCell(metaQry, "TypeName",
qryStruct[i]["TypeName"],i)>
</cfloop>
Now you can do a q of q on 'metaQry' like so:
<cfquery name="QofQ" dbtype="query">
select * from metaQry
order by Name
</cfquery>
On 12/8/06, daniel kessler <[EMAIL PROTECTED]> wrote:
>
> >Have you tried making the structure into a query and doing a QoQ in your
> >sorted order?
>
> I've adjusted it (see below) but still it seems to be a problem. It
> doesn't recognize the results of getMetaData as a query, I guess. I had
> done a query, used getMetaData to pull the array of structs from the query
> and put that in a var "j". If I use j as my table, it fails, but if I put
> in the query itself instead of the metadata, then it doesn't give an
> error. Of course, it doesn't sort the metadata either. My code.
>
> <cfset j= GetMetaData(getExportSearchItem)>
> <cfdump var="#j#">
> <cfquery dbtype="query" name="sorted">
> SELECT *
> FROM j
> </cfquery>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263343
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
