I am using CFDIRECTORY ACTION LIST to look for files in a directory. Then I am using a query of queries to limit which files are shown. The search in the name field is returning things like
# 367lh_02142011_1144AM.pdf (02/14/2011)
despite the like is for 367_ or 367lh_... What am I doing wrong?
<CFdirectory action="list" directory="#application.systempath#memberpdfs\" name="Printers" filter="">
SELECT * FROM Printers
WHERE name like '367_%' or name like '367lh_%'