Web Wiz Forums - search string

Print Page | Close Window

search string

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=17165
Printed Date: 18 April 2026 at 1:38am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: search string

Posted By: dfrancis
Subject: search string
Date Posted: 07 November 2005 at 10:00am

This may seem list a stupid question but I have been emersed in regex for the past two days and I forgot.

I want to prevent my moderator topic from searched and I thought editing the sql query would solve it for now. I just can remember how to write the query condtion.

Something like

If intForumID <> 0 OR NOT intForumID = 4 Then

' 4 being my moderator foum.

Replies:

Posted By: WebWiz-Bruce
Date Posted: 07 November 2005 at 10:31am

If intForumID <> 0 OR intForumID <> 4 Then

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: dfrancis
Date Posted: 07 November 2005 at 11:07am

Thanks borg, I think that negates itself doesn't it?

Anyway, where I'm working is around line 490-500 on the search.asp page. I'm trying to catch the forum ID in there but the intForumID is not passing through. Any ideas?

What I want is, no display if forum id = 4 otherwise normal.

Posted By: dj air
Date Posted: 07 November 2005 at 11:42am

ad the line

strSQL = strSQL & " AND NOT (" & strDBTable &"Forum.forum_ID = 4 OR " & strDBTable &"Forum.forum_ID = 0) "

that added to the query will take out the forums with ID 4 or 1 .. you can use if blnAdmin = False then strSQL .... ..