Print Page | Close Window

can’t post messages..pls help

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=4386
Printed Date: 02 April 2026 at 6:44am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: can’t post messages..pls help
Posted By: PrivateEye
Subject: can’t post messages..pls help
Date Posted: 20 July 2003 at 2:33pm

Hi - I am using wwf v 7.01 (SQL Server) I am getting problem with the posting. It is running well on my local machine, but displaying following error message in post_message.asp page when I run my forum on internet web server.

ADODB.Recordset error '800a0cb3'

Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.

post_message.asp, line 599

Line 599 looks like this:

'If this is a new topic then save the new subject heading and read back the new topic ID number

If strMode = "new" AND (blnPost = True OR (blnAdmin = True OR blnModerator = True)) Then

'Initalise the SQL string with a query to get the Topic details

strSQL = "SELECT TOP 1 " & strDbTable & "Topic.* FROM " & strDbTable & "Topic "

strSQL = strSQL & "WHERE Forum_ID =" & intForumID & " "

strSQL = strSQL & "ORDER By " & strDbTable & "Topic.Start_date DESC;"

With rsCommon

'Set the cursor type property of the record set to Dynamic so we can navigate through the record

set .CursorType = 2

'Set the Lock Type for the records so that the record set is only locked when it is updated

.LockType = 3

'Open the author table .Open strSQL, adoCon 'Insert the new topic details in the recordset

.AddNew (Line # 599)

I also re-uploaded the file but same problem. Any help is appreciated. Thank you.



-------------
The Judgement Day



Replies:
Posted By: MadDog
Date Posted: 20 July 2003 at 4:15pm
Change:

strSQL = "SELECT TOP 1 " & strDbTable & "Topic.* FROM " & strDbTable & "Topic "
strSQL = strSQL & "WHERE Forum_ID =" & intForumID & " "
strSQL = strSQL & "ORDER By " & strDbTable & "Topic.Start_date DESC;"


To:

strSQL = "SELECT " & strDbTable & "Topic.* FROM " & strDbTable & "Topic "
strSQL = strSQL & "WHERE Forum_ID =" & intForumID & ";"


-------------
http://www.iportalx.net" rel="nofollow">


Posted By: PrivateEye
Date Posted: 20 July 2003 at 4:19pm
I have fixed the bug by adding rsCommon.CursorLocation = 3 'Client Side cursor :)

-------------
The Judgement Day



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net