listing a Directory files

[menotti08]

hello community
i want to make a directory list
i have pdf documents in a list
101_4326.pdf
101_4325.pdf
201_4324.pdf
201_4328.pdf
but i only want to show the pdf that have the same number that the client
example: id_client = 101 and the pdf is
101_4326.pdf how can i show the files and associate the files with the id?

[mpwoodward *TMM*]

menotti08 wrote:

> hello community
> i want to make a directory list
> i have pdf documents in a list
> 101_4326.pdf
> 101_4325.pdf
> 201_4324.pdf
> 201_4328.pdf
> but i only want to show the pdf that have the same number that the client
> example: id_client = 101 and the pdf is
> 101_4326.pdf how can i show the files and associate the files with the id?
>

You can probably use the filter function to do that (I'd have to
experiment to be sure):
[url]http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-a20.htm#wp1097918[/url]

I would think the filter could be something like #clientid#*

If not, cfdirectory returns a query object and you could run a query of
that query to filter.

Matt
--
Matt Woodward
[email]mpwoodward@gmail.com[/email]
Team Macromedia - ColdFusion

[Abinidi]

Try this:

<cfset id_client = "101">
<cfdirectory action="list" name="Qdir"
directory="C:\directory_path_to_pdf_files">
<cfquery dbtype="query" name="listfiles">
SELECT Name
FROM Qdir
WHERE (Name LIKE '#id_client#%')
</cfquery>
<cfdump var="#listfiles#">

[menotti08]

iu think this can help me thx
but i have to test it first
thx for your help
i will mark this when i test it

sorry for my english

[menotti08]

ok i have problems with this
<cfset DirList = "C:\Inetpub\wwwroot\test\pdf">

<cfset id_client = "101">
<cfdirectory action="list" name="Qdir" directory="DirList">
<cfquery dbtype="query" name="listfiles" result="menotti">
SELECT 101
FROM Qdir
<!--- WHERE (Name LIKE '#id_client#%') --->
</cfquery>
<cfoutput>#menotti.sql#</cfoutput>
<cfdump var="#listfiles#">
<cfoutput query="listfiles">#dirllist#</cfoutput>

the application dont show the conent of the carpet
the other problem is that i only want
that the application recognize the number 101, or 201 or any number that i
have in the file using the id, so i dont have to put <cfset id_client = "101">

[jdeline]

There are a few things wrong with what you have.
If you use a variable in the CFDIRECTORY to define the path, you have to wrap
it in #.
Your WHERE clause, commented out, is correct. Remove the comments.
Remove the RESULTS attribute in the CFQUERY. ColdFusion (at least version 5)
does not recognize this.
Change the way you are displaying your results. I have shown a CFOUTPUT loop
of the filename.
I removed the CFDUMP and the CFOUTPUT loop at the end of your code.


<cfset DirList = "C:\Inetpub\wwwroot\test\pdf">

<cfset id_client = "101">
<cfdirectory action="list" name="Qdir" directory="#DirList#">
<cfquery dbtype="query" name="listfiles">
SELECT 101
FROM Qdir
WHERE (Name LIKE '#id_client#%')
</cfquery>
<cfoutput>#name#<BR></cfoutput>