Wrox Programmer Forums
Classic ASP Basics For beginner programmers starting with "classic" ASP 3, pre-".NET." NOT for ASP.NET 1.0, 1.1, or 2.0
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old January 19th, 2016, 01:12 PM
Authorized User
Join Date: Apr 2007
Posts: 92
Thanks: 0
Thanked 0 Times in 0 Posts
Question FSO to check against MySQL


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??
Old January 19th, 2016, 09:52 PM
Friend of Wrox
Join Date: Jan 2004
Posts: 1,870
Thanks: 12
Thanked 20 Times in 20 Posts
Send a message via AIM to mat41

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

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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Need Help!! on Checkbox click how to check from database whether clicked check match. damandeep BOOK: Beginning PHP5, Apache, and MySQL Web Development ISBN: 978-0-7645-7966-0 1 March 14th, 2011 08:39 AM
fso error merck_04 .NET Framework 1.x 0 October 18th, 2006 05:53 AM
capture check box data into mysql osemollie PHP How-To 0 January 30th, 2006 12:18 PM
FSO mikedeepak Classic ASP Databases 5 August 4th, 2004 05:55 AM
FSO mikedeepak Classic ASP Databases 0 August 4th, 2004 12:35 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.