FSO to check against MySQL

melkin · January 19th, 2016, 01:12 PM

Hi.

I am successful in fetching folder names on my server directory... but I need the folder names to NOT display if the folder name resides in a field in a MySQL database...

How do I do this??

mat41 · January 19th, 2016, 09:52 PM

Your post is a bit vague IMO to be honest. In future you should post code which is your attempt to solve your issue asking for help. This way it shows you 'had a go' and just need help improving it........

So conceptional this is what I would do:

1..query the mySQL DB to get the fieldNames which should not show. Place these in a comer delimited string e.g: (or it could be array...)

blackListStr = "folderName1,folderName2"

2..now inside your existing For loop whee you are displaying folder names use the instr function (will be 0 if not found others wise > 0) to see if your folder name is in the string. If not show if so dont show e.g

Code:

if instr(subFolder, blackListStr ) = 0 then
     response.write subFolder & "<BR>"
else
    'do nothing becasue the subFolder is in the blackList string
end if