I'm trying to do a query of a query returned through CFDIRECTORY. What, if any, functions are permitted in such a query? I need to use the first four characters of the file name in the WHERE clause.
<!--- Get a directory listing of all area photos ---> <cfdirectory action="list" directory="#photos#" name="dirlisting"> <!--- Pull out only photos of desired areas ---> <cfquery dbtype="query" name="r"> SELECT * FROM dirlisting WHERE Left(name, 4) IN (#PreserveSingleQuotes(areas)#) ORDER BY name </cfquery> If this isn't doable, is there another way, short of looping over the directory listing? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138221 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm