Filter Query

[menotti08]

ok i have this

<cfset mypdf = "name">
<cfset mypdf = GetToken(mypdf, 1, "_")>
<cfoutput>#mypdf#</cfoutput>
<cfset session.fkcliente = "name">

<cfset DirList = 'D:\MyAccount\admin\Facturas'>
<cfscript>
if (NOT structKeyExists(form, 'fileExt')) form.fileExt = "*";
</cfscript>

<!--- get the list of text files. this assumes they will all be in a directory
called 'textfiles' under the web root --->
<cfdirectory action="list" directory="#DirList#" name="fileList"
filter="#form.fileExt#">

<style type="text/css">
<!--
body,td,th {
font-family: Verdana;
font-size: 12px;
color: #006699;
}
a:link {
color: #006699;
text-decoration: none;
}
a:visited {
text-decoration: none;
}
a:hover {
text-decoration: underline;
}
a:active {
text-decoration: none;
}
-->
</style>

<table style="width:500px;" cellpadding="1" cellspacing="1">
</table>

<table style="width:500px; border:1px #000000 solid;" cellpadding="1"
cellspacing="1">
<tr style="background-color:#cccccc;">
<td style="font-weight:bold;">File Name&nbsp;&nbsp;</td>
<td style="font-weight:bold; width:80px; text-align:right;">File
Size&nbsp;&nbsp;</td>
<td style="font-weight:bold; width:150px;">Last Modified&nbsp;&nbsp;</td>
</tr>
<cfoutput query="fileList">

<cfif left(fileList.name, 1) IS NOT ".">
<!--- this condition does NOT need to be included in CF MX!! --->
<tr style="background-color:<cfif currentRow MOD
2>##ffffff<cfelse>##ececec</cfif>;">
<td><a href="facturas/#name#">#name#</a>&nbsp;&nbsp;</td>
<td style="text-align:right;">#int(evaluate(size/1024))#
KB&nbsp;&nbsp;</td>
<td>#dateFormat(dateLastModified, 'mm/dd/yyyy')#
#timeFormat(dateLastModified, 'h:mm tt')#&nbsp;&nbsp;</td>
</tr>
</cfif>
</cfoutput>
</table>

it work, but i get this query

[url]http://img332.imageshack.us/img332/4696/query4ta.jpg[/url]

but i only want the initial number depend of the user id

if i login with an id like 206 i only wnat to show the pdf files that start
with 206

[mxstu]

Use a Query of Query to filter the listing on the current #loginID# (ex. 206)

<cfdirectory action="list" directory="#DirList#" name="fileList"
filter="#form.fileExt#">
<cfquery name="filteredList" dbtype="query">
SELECT *
FROM fileList
WHERE Name LIKE '#loginID#%'
</cfquery>

[menotti08]

i put your code and he post all the files yet

[mxstu]

Are you using the new query "filteredList" in your CFOUTPUT statement?

<cfoutput query="filteredList">
<cfif left(fileList.name, 1) IS NOT ".">
... other code ....
</cfif>
</cfoutput>