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 .... ..



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net