Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: MOD Implementation
 How can I exclude a forum in the query string		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Nertz
Junior Member

Canada
341 Posts
Posted - 23 March 2004 :  10:57:05  Show Profile
In my rss output, I would like to exclude one forum from the search of recent posts. Using the example rssfeed.asp in http://forum.snitz.com/forum/topic.asp?TOPIC_ID=46136, how can I modify this line

strSql = strSql & " WHERE T.FORUM_ID = F.FORUM_ID"

to exclude one forum_ID? Is that the right line to modify?

My knowledge of ACCESS is very limited, and a search on these forums to exclude a forum from the query did not yield anything useful.

cheers,
Nat
Sadly, most Family Court Judges wrongfully reward opportunistic gold diggers
that use our children unjustly as "instruments" of power.

www.fathers-4-justice-canada.ca
Edited by - ruirib on 23 March 2004 11:01:36

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 23 March 2004 :  11:02:15  Show Profile  Send ruirib a Yahoo! Message
You need to add a condition to the already existing one? What is the forum_ID for the forum you want to exclude?

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

Nertz
Junior Member

Canada
341 Posts
Posted - 23 March 2004 :  11:13:05  Show Profile
quote:
Originally posted by ruirib

You need to add a condition to the already existing one? What is the forum_ID for the forum you want to exclude?


Forum_ID=21. I haven't been able to figure out how.

cheers,
Nat
Sadly, most Family Court Judges wrongfully reward opportunistic gold diggers
that use our children unjustly as "instruments" of power.

www.fathers-4-justice-canada.ca
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 23 March 2004 :  11:28:53  Show Profile  Send ruirib a Yahoo! Message 

   strSql = strSql & " WHERE T.FORUM_ID = F.FORUM_ID AND F.FORUM_ID=21"

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

davemaxwell
Access 2000 Support Moderator

USA
3020 Posts
Posted - 23 March 2004 :  11:34:12  Show Profile  Visit davemaxwell's Homepage  Send davemaxwell an AOL message  Send davemaxwell an ICQ Message  Send davemaxwell a Yahoo! Message
quote:
Originally posted by ruirib


   strSql = strSql & " WHERE T.FORUM_ID = F.FORUM_ID AND F.FORUM_ID=21"



shouldn't that be: F.FORUM_ID <> 21
Dave Maxwell
Barbershop Harmony Freak
Go to Top of Page

Nertz
Junior Member

Canada
341 Posts
Posted - 23 March 2004 :  11:50:42  Show Profile
Ruirib & Dave, thanks very much. it worked with the "<>21"!! much appreciate the help.

cheers,
Nat
Sadly, most Family Court Judges wrongfully reward opportunistic gold diggers
that use our children unjustly as "instruments" of power.

www.fathers-4-justice-canada.ca
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 23 March 2004 :  12:42:51  Show Profile  Send ruirib a Yahoo! Message
quote:
Originally posted by davemaxwell

quote:
Originally posted by ruirib


   strSql = strSql & " WHERE T.FORUM_ID = F.FORUM_ID AND F.FORUM_ID=21"



shouldn't that be: F.FORUM_ID <> 21


Indeed, thx. Don't know what I was thinking. Probably sleeping with my eyes open...

Snitz 3.4 Readme | Like the support? Support Snitz too
Edited by - ruirib on 23 March 2004 12:49:55
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.35 seconds. Powered By: Snitz Forums 2000 Version 3.4.07