Web Wiz Support and Community Forums : Watch this Forum -Groups https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 16:36:28 +0000 Thu, 02 Dec 2004 15:40:54 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=12803 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Watch this Forum -Groups : sorry ment use SQL &#034;INSERT...]]> https://forums.webwiz.net/watch-this-forum-groups_topic12803_post70837.html#70837 Author: dj air
Subject: 12803
Posted: 02 December 2004 at 3:40pm

sorry ment use SQL "INSERT INTO "

it would work in both versions.






    
    'Initalise the SQL string with a query to get the email notify topic details
    If strDatabaseType = "SQLServer" Then
        strSQL = "EXECUTE " &strDbProc & "TopicEmailNotify @lngAuthorID = " &lngLoggedInUserID & ", @lngTopicID= " & lngTopicID
    Else
        strSQL = "SELECT " & strDbTable & "EmailNotify.*  "
        strSQL = strSQL & "FROM " & strDbTable & "EmailNotify "
        strSQL = strSQL & "WHERE "& strDbTable & "EmailNotify.Author_ID=" & lngLoggedInUserID& " AND " & strDbTable & "EmailNotify.Topic_ID=" &lngTopicID & ";"
    End If

    With rsCommon

        'Set the cursor type property ofthe record set to Dynamic so we can navigate through the record set
        .CursorType = 2

        'Set the Lock Type for therecords so that the record set is only locked when it is updated
        .LockType = 3
        
        'Query the database
        .Open strSQL, adoCon

            'Check to see if the user is allowed to view posts in this forum
            CallforumPermisisons(intForumID, intGroupID, intReadPermission, 0, 0, 0, 0,0, 0, 0, 0, 0)
            
            'If the user can read in this forum the add them
            If blnRead Then
                'Add new rs
                .AddNew
    
                'Create new entry
                .Fields("Author_ID") = lngLoggedInUserID
                .Fields("Topic_ID") = lngTopicID
    
                'Upade db with new rs
                .Update
                
                'Set the return value
                strReturnValue = "&EN=TS"
            End If


        'Clean up
        .Close

    End With



alll you need to do is add this to the section that changes group, use an If groupID = x then

code
end if


all you need to do is specify lngTopicID

also you may want to ad dmultipals of it to allow for extra forums or do a loop
]]> Thu, 02 Dec 2004 15:40:54 +0000 https://forums.webwiz.net/watch-this-forum-groups_topic12803_post70837.html#70837 <![CDATA[Watch this Forum -Groups : dj air wrote:if its not public.....]]> https://forums.webwiz.net/watch-this-forum-groups_topic12803_post70832.html#70832 Author: rhamlin
Subject: 12803
Posted: 02 December 2004 at 3:18pm

Originally posted by dj air dj air wrote:

if its not public.. why not set AN INSERT IN TO SQL

that adds a record automaticlly into the email notify table with the details of the forums.

do this when they are put into the Group.
 
How?
 
BTW I am using an access DB, Not SQL
]]> Thu, 02 Dec 2004 15:18:43 +0000 https://forums.webwiz.net/watch-this-forum-groups_topic12803_post70832.html#70832 <![CDATA[Watch this Forum -Groups : if its not public.. why not set...]]> https://forums.webwiz.net/watch-this-forum-groups_topic12803_post70831.html#70831 Author: dj air
Subject: 12803
Posted: 02 December 2004 at 2:37pm

if its not public.. why not set AN INSERT IN TO SQL

that adds a record automaticlly into the email notify table with the details of the forums.

do this when they are put into the Group.
]]> Thu, 02 Dec 2004 14:37:27 +0000 https://forums.webwiz.net/watch-this-forum-groups_topic12803_post70831.html#70831 <![CDATA[Watch this Forum -Groups : I think we should be able to add...]]> https://forums.webwiz.net/watch-this-forum-groups_topic12803_post70829.html#70829 Author: rhamlin
Subject: 12803
Posted: 02 December 2004 at 2:33pm

I think we should be able to add it and then they can unsubscribe if they dont want it. It should be up to the admin to turn it on or not. If this isnt a public forum then It wouldn't be considered spam.]]> Thu, 02 Dec 2004 14:33:59 +0000 https://forums.webwiz.net/watch-this-forum-groups_topic12803_post70829.html#70829 <![CDATA[Watch this Forum -Groups : no. they have to subscribe to...]]> https://forums.webwiz.net/watch-this-forum-groups_topic12803_post70824.html#70824 Author: dj air
Subject: 12803
Posted: 02 December 2004 at 2:16pm

no. they have to subscribe to it.

else it can be classed as a form of spam (i know silly) but its true.

unless they subscribe then no.
]]> Thu, 02 Dec 2004 14:16:08 +0000 https://forums.webwiz.net/watch-this-forum-groups_topic12803_post70824.html#70824 <![CDATA[Watch this Forum -Groups : Is there a way that as the admin...]]> https://forums.webwiz.net/watch-this-forum-groups_topic12803_post70814.html#70814 Author: rhamlin
Subject: 12803
Posted: 02 December 2004 at 12:30pm

Is there a way that as the admin of the forums, I can make sure that a specific "Group" receives email notification of new or updated posts in a particular forum.
 
If not, it would make a great addition to the member groups feature.
 
Just a thought.
]]> Thu, 02 Dec 2004 12:30:49 +0000 https://forums.webwiz.net/watch-this-forum-groups_topic12803_post70814.html#70814