Snitz Forums 2000 - Post Reply Query

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Help Groups for Snitz Forums 2000 Users

Help: General / Classic ASP versions(v3.4.XX)

Post Reply Query

New Topic

Topic Locked

Printer Friendly

Author

Topic

david4021
Starting Member

11 Posts

Posted - 25 January 2006 : 08:44:59

I've looked at the datamodel but it's not clear how I can construct a query to determine if a post by a member has been responded to. The scenario is a moderated board where I need to build a list of replies for specific individuals who monitor category / forums and must reply to posts
Any suggestions?

thanks

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 25 January 2006 : 09:03:15

By "a post by a member" I admit that you're talking about a topic started by a member. All you need to do to find that is query FORUM_REPLY to find out whether there are records WHERE FORUM_REPLY.TOPIC_ID=desired_topic_id.

Snitz 3.4 Readme | Like the support? Support Snitz too

Nertz
Junior Member

Canada
341 Posts

Posted - 25 January 2006 : 09:20:25

Have a look at Onewaymule's unanswered topics mod, it might give you ideas to build what you are looking for.

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

david4021
Starting Member

11 Posts

Posted - 25 January 2006 : 11:13:43

This is exactly what I needed, just had to update the query to avoid posts by moderators and bingo!

thanks

Topic

New Topic

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.99 seconds.