?
Solved

QoQ error

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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

Have you ever sent email via ColdFusion and thought of tracking this mail to capture the exact date and time when the message was opened ?  If yes, then this article is for you ! First we need a table user_email with columns user_id , email , sub…
One of the typical problems I have experienced is when you have to move a web server from one hosting site to another. You normally prepare all on the new host, transfer the site, change DNS and cross your fingers hoping all will be ok on new server…
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: …
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Suggested Courses
Course of the Month12 days, 15 hours left to enroll

777 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