Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old January 19th, 2016, 01:12 PM
Authorized User
Points: 483, Level: 7
Points: 483, Level: 7 Points: 483, Level: 7 Points: 483, Level: 7
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Apr 2007
Location: Edgewood, NY, USA.
Posts: 92
Thanks: 0
Thanked 0 Times in 0 Posts
Question FSO to check against MySQL

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??
Reply With Quote
  #2 (permalink)  
Old January 19th, 2016, 09:52 PM
Friend of Wrox
Points: 6,664, Level: 34
Points: 6,664, Level: 34 Points: 6,664, Level: 34 Points: 6,664, Level: 34
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2004
Location: Sydney, NSW, Australia.
Posts: 1,870
Thanks: 12
Thanked 20 Times in 20 Posts
Send a message via AIM to mat41
Default

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
__________________
Wind is your friend
Matt
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

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 09:39 AM
fso error merck_04 .NET Framework 1.x 0 October 18th, 2006 06: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 06:55 AM
FSO mikedeepak Classic ASP Databases 0 August 4th, 2004 01:35 AM



All times are GMT -4. The time now is 03:21 PM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.