https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 08 Apr 2026 22:54:08 +0000 Sun, 08 Oct 2006 21:47:12 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=21258 https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ https://forums.webwiz.net/move-individual-post_topic21258_post115158.html#115158 Author: WebWiz-Bruce
Subject: 21258
Posted: 08 October 2006 at 9:47pm

In the move_post.asp page find the part that moves the post using ADO and replace with:-

'Initliase SQL upadte
        strSQL = "UPDATE " & strDbTable & "Thread " & _
        "SET " & strDbTable & "Thread.Topic_ID = " & lngTopicID & " " & _
        "WHERE " & strDbTable & "Thread.Thread_ID = "  & lngPostID & ";"
       
        'Execute SQL
        adoCon.Execute(strSQL)   

This will work for mySQL but if te code won't work with Access due to time delays in Access being to slow to update.
]]> Sun, 08 Oct 2006 21:47:12 +0000 https://forums.webwiz.net/move-individual-post_topic21258_post115158.html#115158 https://forums.webwiz.net/move-individual-post_topic21258_post115152.html#115152 Author: lydbury
Subject: 21258
Posted: 08 October 2006 at 6:25pm

Not to hassle - but any news on this?

Thanks

Duncan
]]> Sun, 08 Oct 2006 18:25:09 +0000 https://forums.webwiz.net/move-individual-post_topic21258_post115152.html#115152 https://forums.webwiz.net/move-individual-post_topic21258_post113898.html#113898 Author: lydbury
Subject: 21258
Posted: 11 September 2006 at 9:50am

Thank you. ]]> Mon, 11 Sep 2006 09:50:49 +0000 https://forums.webwiz.net/move-individual-post_topic21258_post113898.html#113898 https://forums.webwiz.net/move-individual-post_topic21258_post113893.html#113893 Author: WebWiz-Bruce
Subject: 21258
Posted: 11 September 2006 at 8:35am

There is a bug in mySQL version which does this and a fix is being worked on for the next version.]]> Mon, 11 Sep 2006 08:35:56 +0000 https://forums.webwiz.net/move-individual-post_topic21258_post113893.html#113893 https://forums.webwiz.net/move-individual-post_topic21258_post113850.html#113850 Author: lydbury
Subject: 21258
Posted: 09 September 2006 at 3:54pm

How does one move an individual post? The move button underneath the individual post still seems to move the whole thread.

Version 8.04 MySQL

Duncan


Edited by lydbury - 09 September 2006 at 5:07pm]]> Sat, 09 Sep 2006 15:54:20 +0000 https://forums.webwiz.net/move-individual-post_topic21258_post113850.html#113850