Web Wiz Support and Community Forums : Post in forum, from outside forum. https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 10:18:50 +0000 Thu, 22 Jun 2006 10:18:22 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=20377 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Post in forum, from outside forum. : Cool ]]> https://forums.webwiz.net/post-in-forum-from-outside-forum_topic20377_post109459.html#109459 Author: WebWiz-Bruce
Subject: 20377
Posted: 22 June 2006 at 10:18am

Cool ]]> Thu, 22 Jun 2006 10:18:22 +0000 https://forums.webwiz.net/post-in-forum-from-outside-forum_topic20377_post109459.html#109459 <![CDATA[Post in forum, from outside forum. : okay then its not realy a problem....]]> https://forums.webwiz.net/post-in-forum-from-outside-forum_topic20377_post109432.html#109432 Author: BrownGhost
Subject: 20377
Posted: 21 June 2006 at 7:37pm

okay then its not realy a problem. all is good, and i want to thank you for all your help.. :)

Making a new site for a costumer of mine thy want forum also, so im buying more forum later this week :)

thanks...
]]> Wed, 21 Jun 2006 19:37:30 +0000 https://forums.webwiz.net/post-in-forum-from-outside-forum_topic20377_post109432.html#109432 <![CDATA[Post in forum, from outside forum. : It should be fine how it is.If...]]> https://forums.webwiz.net/post-in-forum-from-outside-forum_topic20377_post109427.html#109427 Author: WebWiz-Bruce
Subject: 20377
Posted: 21 June 2006 at 7:18pm

It should be fine how it is.

If by some 1 million to 1 chance another user posted at the same time as you and the database updated their stats in a million second before yours then you would just have the wrong poster displayed as the last poster in that topic, this will be updated when a new user posts or you use the admin button to update the topic.

By the way for performance reasons the database isn't locked during this process in version 8 anyway.

Most 'updates' are now row locks, and most 'reads' are now 'dirty' reads were the database is not locked during the read. This hasn't seemed to create a problem, but does increase performance.


Edited by -boRg- - 21 June 2006 at 7:20pm]]> Wed, 21 Jun 2006 19:18:37 +0000 https://forums.webwiz.net/post-in-forum-from-outside-forum_topic20377_post109427.html#109427 <![CDATA[Post in forum, from outside forum. : Humm that gave me an idear for,...]]> https://forums.webwiz.net/post-in-forum-from-outside-forum_topic20377_post109424.html#109424 Author: BrownGhost
Subject: 20377
Posted: 21 June 2006 at 6:30pm

Humm that gave me an idear for, changing my code at bit. its now working..

strSQL = _
        "INSERT INTO tblTopic(Forum_ID,Poll_ID,Moved_ID,Subject,Start_Date,Last_Entry_Date,No_Of_Views,Locked,Priority,NewsID) " & _
        "VALUES("& intForumID &",0,0,'" & strTitleName & "',GetDate(),GetDate(),0,0,0," & lngNewsID & ")"
    objConn.Execute strSQL
   
   
    strSQL = "SELECT Max(Topic_ID) AS ID FROM tblTopic"
    lngTopicID = objConn.Execute(strSQL)("ID")
   
    strSQL = _
        "INSERT INTO tblThread(Topic_ID,Author_ID,Message,Message_Date,Show_Signature,IP_Addr) " & _
        "VALUES(" & lngTopicID & "," & strTeamUserID & ",'" & strTeaser & "',GetDate(),0,'')"
    objConn.Execute strSQL
Else
    lngTopicID = rsTopic("Topic_ID")
End If

   
    strSQL = "SELECT Max(Thread_ID) AS ID FROM tblThread"
    lngThreadID = objConn.Execute(strSQL)("ID")


strSQL = "UPDATE tblTopic SET Start_Thread_ID=" & lngThreadID & ", Last_Thread_ID=" & lngThreadID & " WHERE Topic_ID=" & lngTopicID
        objConn.Execute strSQL

Response.Redirect "/forum/forum_posts.asp?TID=" & lngTopicID


Now i set the Start_Thread_ID and Last_Thread_ID at the end of my code.
But Qcustion is, what if some other user makes new thred at the same time ??

Can i Lock the tabel until im don running my code..
And how do one do this?

Thx
im not proff programmer as you, so i need some help.
]]> Wed, 21 Jun 2006 18:30:12 +0000 https://forums.webwiz.net/post-in-forum-from-outside-forum_topic20377_post109424.html#109424 <![CDATA[Post in forum, from outside forum. : Have a look in the files new_post.asp,...]]> https://forums.webwiz.net/post-in-forum-from-outside-forum_topic20377_post109395.html#109395 Author: WebWiz-Bruce
Subject: 20377
Posted: 21 June 2006 at 10:24am

Have a look in the files new_post.asp, and delete_post.asp handle the insert and deletion of posts. This should give you some idea of what to do.]]> Wed, 21 Jun 2006 10:24:58 +0000 https://forums.webwiz.net/post-in-forum-from-outside-forum_topic20377_post109395.html#109395 <![CDATA[Post in forum, from outside forum. : Post in forum, from outside...]]> https://forums.webwiz.net/post-in-forum-from-outside-forum_topic20377_post109374.html#109374 Author: BrownGhost
Subject: 20377
Posted: 20 June 2006 at 10:19pm

Post in forum, fromoutside forum.

 

We have made afunction in version 7.1 where visitors could comment news written on my page.

When selecting tocomment a post was made in forum, in a category we already have decided whatwas. And it would post as the news writer as we include his id and stuff.

All working great.

 

Now after we haveupdated to V 8.2 this function still works, except, the post don’t show op inthe forum, if you select that category. If I track the post via ID I can seeits there. But its not showing up in forum. I know what the problem is, but don’thow to fix it.

 

The problem was whenwe make a post in forum via our news page it did not create: Start_Thread_ID Last_Thread_ID

 

So I try the codebelow to fix that problem.

Works until some one deletesa post, then its not right any more.

 

Lets say Thread_ID 12was deleted.

Then next Thread_ID willbe 13
But my code will look in forum see that 11 is there + 1 and assume its 12.

And use 12 for my post:(

 

 

 

            strSQL = "SELECTMax(Thread_ID+1) AS ID FROM tblThread"

            lngThreadID =objConn.Execute(strSQL)("ID")

           

           

            strSQL = _

                        "INSERT INTOtblTopic(Forum_ID,Poll_ID,Moved_ID,Subject,Start_Date,Last_Entry_Date,No_Of_Views,Locked,Priority,NewsID,Start_Thread_ID,Last_Thread_ID)" & _

                        "VALUES("&intForumID &",0,0,'" & strTitleName &"',GetDate(),GetDate(),0,0,0," & lngNewsID & ","& lngThreadID & "," & lngThreadID & ")"

            objConn.Execute strSQL

           

           

            strSQL = "SELECT Max(Topic_ID)AS ID FROM tblTopic"

            lngTopicID =objConn.Execute(strSQL)("ID")

           

            strSQL = _

                        "INSERT INTOtblThread(Topic_ID,Author_ID,Message,Message_Date,Show_Signature,IP_Addr)" & _

                        "VALUES("& lngTopicID & "," & strTeamUserID & ",'"& strTeaser & "',GetDate(),0,'')"

            objConn.Execute strSQL

 

 

Can you think of a wayi can fix this problem?

Thanks a lot.

]]> Tue, 20 Jun 2006 22:19:04 +0000 https://forums.webwiz.net/post-in-forum-from-outside-forum_topic20377_post109374.html#109374