search string

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
dfrancis Members Profile Find Members Posts Senior Member Joined: 16 March 2005 Location: United States Status: Offline Points: 442	Post Options Post Reply Quote dfrancis Report Post Thanks(0) Quote Reply Topic: search string 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.

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply Posted: 07 November 2005 at 10:31am
	If intForumID <> 0 OR intForumID <> 4 Then
	Web Wiz Forums Hosting ASP.NET Web Hosting

dfrancis Members Profile Find Members Posts Senior Member Joined: 16 March 2005 Location: United States Status: Offline Points: 442	Post Options Post Reply Quote dfrancis Report Post Thanks(0) Quote Reply 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.

dj air Members Profile Find Members Posts Senior Member Joined: 05 April 2002 Location: United Kingdom Status: Offline Points: 3627	Post Options Post Reply Quote dj air Report Post Thanks(0) Quote Reply 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 .... ..

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.