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

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: MOD Implementation
 Autolock Topics MOD Error		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

richfed
Average Member

United States
999 Posts
Posted - 08 November 2003 :  11:11:09  Show Profile  Visit richfed's Homepage
Trying to implement this, but receive this error when attempting to post:


Microsoft OLE DB Provider for SQL Server error '80040e14'

There are more columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement.

/messageboard/post_info.asp, line 1136


Text version of my post_info.asp: post_info.txt

I believe the cause may be in this step:

quote:
(Step 4)

approx line 844, you will find :



strSql = strSql & ", 0"



after that line add :



strSql = strSql & ", '" & Request.Form("AutoLock") & "'"


Since my line numbers don't even come close, I couldn't figure out where to put this - there are multiple instances of this code & no reference points to go by.

Any ideas?
Edited by - richfed on 08 November 2003 11:33:21

laser
Advanced Member

Australia
3859 Posts
Posted - 08 November 2003 :  16:50:12  Show Profile
richfed, change your code here (lines 1116-1119) : 


		strSql = strSql & ", 1 "
		strSQL = strSQL & ", 0 "
		strSQL = strSQL & ", 0 "
		strSql = strSql & ", " & cLng(Request.Form("strMessageIcon"))


and insert the line to make lines 116-1120 look like this :


		strSql = strSql & ", 1 "
		strSQL = strSQL & ", 0 "
		strSQL = strSQL & ", 0 "
		strSQL = strSQL & ", '" & Request.Form("AutoLock") & "'"
		strSql = strSql & ", " & cLng(Request.Form("strMessageIcon"))
Go to Top of Page

richfed
Average Member

United States
999 Posts
Posted - 08 November 2003 :  17:56:46  Show Profile  Visit richfed's Homepage
That did the trick, laser ... thanks for that!

Two things I noticed -

1 - ANYONE can lock these topics it appears. Is that correct?

2 - When posting replies the option also appears. Is THAT correct?
Go to Top of Page

laser
Advanced Member

Australia
3859 Posts
Posted - 08 November 2003 :  18:01:09  Show Profile
1. The thread creator has control - that could be anyone.

2. Yep, I should clean that up a bit ... thanks for the tip.
Go to Top of Page

richfed
Average Member

United States
999 Posts
Posted - 16 November 2003 :  07:50:36  Show Profile  Visit richfed's Homepage
Hi laser -

So, are you "cleaning this up"? Any plans for an Admin option? Like unlocking, or restricting only to Events, and the like?

Thanks for the MOD.
Rich
[size=1]A Complete Idiot's Guide to MOD Implementation || On the Trail of the Last of the Mohicans[/size=1]
Go to Top of Page

laser
Advanced Member

Australia
3859 Posts
Posted - 16 November 2003 :  07:56:24  Show Profile
At the moment an Admin &/or Mod can change this setting by editting the topic.

Restricting to events I think is a personal thing, but you could quite easily make the locking optional to events only.

I still have to find (the few minutes it will take) to turn off the locking option when it is a reply. It should really only be visible on topic creation, and not on replying.
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.34 seconds. Powered By: Snitz Forums 2000 Version 3.4.07