I want to say thanks in advance for any help. I have searched the many cfdirectory results and can not get what I need.
I am doing a simple CFDIRECTORY tag. See below.
<cfdirectory directory="MyDirectory\Statements\" action="list" name="Get_Statements" filter="*.pdf" recurse="no"> Then I am making a query of the directory list.
<cfquery name="dbQuery" dbtype="query"> SELECT * FROM Get_Statements </cfquery> <cfdump var="#dbQuery#">
My dump gives me the correct results.
Now I am doing a query to get only the files I need out of the CFDIRECTORY results.
<cfquery name="qoq" dbtype="query"> SELECT * FROM dbQuery WHERE '#SESSION.auth.Owner#' IN ('#Get_Statements.name#') </cfquery> <cfdump var="#qoq#">
Here I dump the results, but only see the first file in the CFDIRECTORY. I should have multiple results. So this is the first part of my problem.
Then I do the output.
<cfloop query="qoq"> <cfoutput><a href="#qoq.name#" target="_new">#qoq.name#</a><br> </cfoutput> </cfloop>
Here I do not get any results at all.
So, I have two issues on this. One, I am not getting the results from my query named "qoq". Two, I am not getting any output at all in my final output tag.
Any help is greatly appreciated.