Solved

QoQ error

Posted on 2004-10-07
2
148 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
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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Periodically we have to update or add SSL certificates for customers. Depending upon your hosting plan you may be responsible for the installation and/or key generation. In the wake of Heartbleed many sites were forced to re-key. We will concen…
Introduction This article explores the design of a cache system that can improve the performance of a web site or web application.  The assumption is that the web site has many more “read” operations than “write” operations (this is commonly the ca…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

770 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