Solved

QoQ error

Posted on 2004-10-07
2
152 Views
Last Modified: 2013-12-24
I am doing a query of a query and getting the following error

______
Error Executing Database Query.  

Query Of Queries runtime error.

Query Of Queries runtime error.
Unrecognized java type  
_____

The query is simple
<cfquery dbtype="query" name="qTest">
SELECT *
FROM test
</cfquery>

When I do a dump of test it is definately a query..

The query is returned from a CFC - test = objFileSystem.getDirectoryTreeAsQuery(application.setting.pathRoot, true );

The code that creates query (just incase) part of it anyway, is:

<cfscript>
            arguments.depth = arguments.depth + 1;

            objFolderCollection = getSubFolderCollection( arguments.directory );
            for ( objFolder in objFolderCollection )
            {
                  arguments.level = arguments.level + 1;
                  queryAddRow( this.result );
                  querySetCell( this.result, "path", objFolder.path );
                  querySetCell( this.result, "name", objFolder.name );
                  querySetCell( this.result, "level", arguments.level );
                  querySetCell( this.result, "depth", arguments.depth );
                  querySetCell( this.result, "dateCreated", objFolder.dateCreated );
                  if ( arguments.showDetail )
                  {
                        querySetCell( this.result, "dateLastAccessed", objFolder.dateLastAccessed );
                        querySetCell( this.result, "dateLastModified", objFolder.dateLastModified );
                        querySetCell( this.result, "size", objFolder.size );
                  }
                  myDirectory = arguments.directory & objFolder.name & "\";
                  // Traverse
                  traverseDirectory( directory = myDirectory, level = arguments.level, depth = arguments.depth );
            }
            </cfscript>
0
Comment
Question by:Tacobell777
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 9

Accepted Solution

by:
CFDevHead earned 500 total points
ID: 12259717
you probally need to do something like this
thisQuery=objFolderCollection.TheQuery

I can't really tell what you are doing from your code.
0
 
LVL 17

Author Comment

by:Tacobell777
ID: 12262965
yes I think you are right, can't test right now - I guess thats what yu get on a Friday afternoon, stupid mistakes ;-))
But I reckon you are right.

Cheers, will test on monday.
0

Featured Post

Turn Insights into Action

Communication across every corner of your business is essential to increase the velocity of your application delivery and support pipeline. Automate, standardize, and contextualize your communication processes with xMatters.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is a guide to setting up a new WHM/cPanel Server to be used for web hosting accounts. It is intended for web hosting company administrators and dedicated server owners. For under $99 per month (considering normal rate of Big Data Cetnters like …
Lease-to-own eliminates the expenditure of hardware replacement and allows you to pay off the server over time. Usually, this is much cheaper than leasing servers. Think of lease-to-own as credit without interest.
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question