Snitz Forums 2000 - Error on voting ...

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Help Groups for Snitz Forums 2000 Users

Help: MOD Implementation

Error on voting ...

New Topic

Topic Locked

Printer Friendly

Author

Topic

nathansym
Junior Member

163 Posts

Posted - 15 August 2002 : 15:59:23

When I try to vote in a poll on my site I get the following error ....

----------------------------------------
Microsoft JET Database Engine error '80040e57'

The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.

/topic.asp, line 431
----------------------------------------

Here is the ASP Code ......

----------------------------------------
if strWhoVotes = "members" then
if trim(mpoll) <> "" then
mpoll = mpoll & "|" & Topic_ID
else
mpoll = Topic_ID
end if

'## Forum_SQL -
strSql = "UPDATE " & strMemberTablePrefix & "MEMBERS "
strSql = strSql & " SET M_POLL = '" & mpoll & "'"
strSql = strSql & " WHERE MEMBER_ID = " & Request.Form("MEMBER_ID")

my_Conn.Execute (strSql) ' <==// Line 431 //==
----------------------------------------

I have checked the M_POLL field and it is set to accept 255 ....

Everyone else on the site can vote fine and I can view results but I cant vote ....

If I change it to a memo field will that mess up the POLL mod?
Will it even fix the problem?

Posted by ruirib: Please post all questions on implementation issues in the Help: MOD Implementation forum

- Thanks
- Nathan
- www.gunslackers.com

Edited by - ruirib on 15 August 2002 16:22:39

Rasco
Advanced Member