ok, I had been trying to write out a query when you sent that, so I was atleast
sort of on the right path.
Yours worked great. It was no longer a struct in each place so I changed some
of the code that referenced it. First I had rebuilt it as an array with
structs, after the query sort, but then decided that was too many lines when I
could just change the reference.
And I understand a whole area now that I had never had to approach.
thank you - and thanks everyone who chimed in.
Have a nice weekend!
>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:
>>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:263361
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
