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

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/O Code)
 How to tell if topic has been replied to....		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

dibley
New Member

United Kingdom
91 Posts
Posted - 09 April 2004 :  11:46:56  Show Profile  Visit dibley's Homepage
Please can anybody tell me how I can tell if a topic has been replied to by the current member? (given by the strDBNTUserName variable)

Any help appreciated...
.:dib:.

www.nightsouls.co.uk - Uk clubber & music forum.
www.animatronica.co.uk - Creators of themepark animatronics.
Edited by - ruirib on 09 April 2004 14:53:44

Ryan
Average Member

USA
858 Posts
Posted - 09 April 2004 :  12:30:23  Show Profile  Visit Ryan's Homepage
Could you give more information??
The Poultry Link - "Serving the best of the fancy with the best of the web"
Forum Setup Help
Go to Top of Page

dibley
New Member

United Kingdom
91 Posts
Posted - 09 April 2004 :  12:59:34  Show Profile  Visit dibley's Homepage
What I am trying to achieve is a count of records in a recordset where the topic subject contains the current member's name and none of the topic replies have been posted by the current member.

So far I can get a count of only the topics that have the member's name in with the following sql statement

quote:

strSql = "SELECT COUNT(TOPIC_ID) AS FAO_COUNT "
strSql = strSql & "FROM " & strMemberTablePrefix & "TOPICS "
strSql = strSql & "WHERE " & strMemberTablePrefix & "TOPICS.T_SUBJECT Like '%" & strDBNTUserName & "%' "
strSql = strSql & ";"


I assume I need to traverse two tables within my sql statement, some how? Any ideas? Am I going about it the wrong way?

This is for a small mod I am trying to create which will allow a member to see if someone has posted an FAO to them in the private message row by a small counter in the private messages area.
.:dib:.

www.nightsouls.co.uk - Uk clubber & music forum.
www.animatronica.co.uk - Creators of themepark animatronics.
Go to Top of Page

dibley
New Member

United Kingdom
91 Posts
Posted - 09 April 2004 :  16:53:41  Show Profile  Visit dibley's Homepage
Using
quote:

'## Gives list of topics where reply has been done.
strSql = "SELECT COUNT(" & strMemberTablePrefix & "TOPICS.TOPIC_ID) AS [FAO_COUNT] "
strSql = strSql & "FROM " & strMemberTablePrefix & "TOPICS, " & strMemberTablePrefix & "REPLY "
strSql = strSql & "WHERE (" & strMemberTablePrefix & "TOPICS.T_SUBJECT Like '%" & strDBNTUserName & "%' "
strSql = strSql & "AND (" & strMemberTablePrefix & "TOPICS.TOPIC_ID = " & strMemberTablePrefix & "REPLY.TOPIC_ID "
strSql = strSql & "AND " & strMemberTablePrefix & "REPLY.R_AUTHOR = " & strMemberTablePrefix & "TOPICS.T_AUTHOR))"
strSql = strSql & ";"


I have managed to get it to count the right topics, BUT only the ones which the MEMBER has repied to. I cannot get my head round how to get what I require! I guess I'll have to resort just displaying the count of topic since the members last visit, similar to active topics, unless any one can help?
.:dib:.

www.nightsouls.co.uk - Uk clubber & music forum.
www.animatronica.co.uk - Creators of themepark animatronics.
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.31 seconds. Powered By: Snitz Forums 2000 Version 3.4.07