Web Wiz Support and Community Forums : search string https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 18 Apr 2026 01:44:42 +0000 Mon, 07 Nov 2005 11:42:54 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=17165 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[search string : ad the line strSQL = strSQL...]]> https://forums.webwiz.net/search-string_topic17165_post93423.html#93423 Author: dj air
Subject: 17165
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 .... ..
]]> Mon, 07 Nov 2005 11:42:54 +0000 https://forums.webwiz.net/search-string_topic17165_post93423.html#93423 <![CDATA[search string : Thanks borg, I think that negates...]]> https://forums.webwiz.net/search-string_topic17165_post93420.html#93420 Author: dfrancis
Subject: 17165
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.
]]> Mon, 07 Nov 2005 11:07:47 +0000 https://forums.webwiz.net/search-string_topic17165_post93420.html#93420 <![CDATA[search string : If intForumID &lt;&gt; 0 OR intForumID...]]> https://forums.webwiz.net/search-string_topic17165_post93419.html#93419 Author: WebWiz-Bruce
Subject: 17165
Posted: 07 November 2005 at 10:31am

If intForumID <> 0 OR intForumID <> 4 Then]]> Mon, 07 Nov 2005 10:31:44 +0000 https://forums.webwiz.net/search-string_topic17165_post93419.html#93419 <![CDATA[search string : This may seem list a stupid question...]]> https://forums.webwiz.net/search-string_topic17165_post93414.html#93414 Author: dfrancis
Subject: 17165
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.
 
 
]]> Mon, 07 Nov 2005 10:00:07 +0000 https://forums.webwiz.net/search-string_topic17165_post93414.html#93414