?
Solved

QoQ error

Posted on 2004-10-07
2
Medium Priority
?
159 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 2000 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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

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

Most ColdFusion developers get confused between the CFSet, Duplicate, and Structcopy methods of copying a Structure, especially which one to use when. This Article will explain the differences in the approaches with examples; therefore, after readin…
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.
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

850 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