| Author |
 Topic  |
|
Rrok007
Junior Member
USA
149 Posts |
 Posted - 02 June 2003 : 08:04:56
|
Okay, well that solved that issue. But now I'm getting the other error
Microsoft JET Database Engine error '80040e14'
Number of query values and destination fields are not the same.
/korloch/batleth/forum/post_info.asp, line 943
I checked, Line 943 starts the include for smilies....? |
Believe disbelief and contemplate the simple. |
 |
|
|
Rrok007
Junior Member
USA
149 Posts |
Posted - 02 June 2003 : 08:25:40
|
| That error also appears with posting new topics. Quick replies and normal replies don't have the error, nor do creating new categories or topics. I'm thinking it might have to do with the check boxes at the bottom, seeing as it only appears when there are more than the two (include sig and lock topic) main choices at the bottom of the page where you write you're post. |
Believe disbelief and contemplate the simple. |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 02 June 2003 : 11:04:44
|
| I need to see your post.asp file. Post a link to a txt version of it. |
Support Snitz Forums
|
|
|
|
Rrok007
Junior Member
USA
149 Posts |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 02 June 2003 : 17:01:58
|
oh shoot, I meant the post_info.asp file. lol
You already posted a link to post.txt already earlier up in the topic.  |
Support Snitz Forums
|
|
|
|
Rrok007
Junior Member
USA
149 Posts |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 02 June 2003 : 17:49:47
|
On line 904 in your post_info.asp file add this code:if Request.Form("poll") = "1" then
strSql = strSql & ", " & 1
else
strSql = strSql & ", " & 0
end if
if Request.Form("lockpoll") = "1" then
strSql = strSql & ", " & 0
else
strSql = strSql & ", " & 1
end if |
Support Snitz Forums
|
|
|
|
Rrok007
Junior Member
USA
149 Posts |
Posted - 02 June 2003 : 22:22:45
|
Okay, so 904 was right in the middle of the strSql = strSql statements, so I dropped to the end of those, to line 910, just before the if Request.Form ("lock") since it looked similar.
Now when I try posting, I get:
Microsoft JET Database Engine error '80040e14'
Number of query values and destination fields are not the same.
/korloch/batleth/forum/post_info.asp, line 953
I looked there and this is what is there:
my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords |
Believe disbelief and contemplate the simple. |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 02 June 2003 : 22:38:47
|
When I looked at your file, line 904 was an empty line:strSql = strSql & ", '" & txtMessage & "'"
line 904
strSql = strSql & ", " & rs("MEMBER_ID")So i told you to put the code there. |
Support Snitz Forums
|
|
|
|
Rrok007
Junior Member
USA
149 Posts |
Posted - 03 June 2003 : 08:20:17
|
Okay, well I went back and took the code you suggested and moved it to line 904. I removed it from 910. Same thing. It is now coming up with the error:
Microsoft JET Database Engine error '80040e14'
Number of query values and destination fields are not the same.
/korloch/batleth/forum/post_info.asp, line 953
And so the next step......?
|
Believe disbelief and contemplate the simple. |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 03 June 2003 : 12:50:51
|
I don't see a problem with the code. Update your post_info.txt file.
|
Support Snitz Forums
|
|
|
|
Rrok007
Junior Member
USA
149 Posts |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 03 June 2003 : 13:52:42
|
On line 912, you left off the letter "s".if Request.Form("lockpoll") = "1" then
strSql = strSql & ", " & 0
else
strSql = strSql & ", " & 1
end if |
Support Snitz Forums
|
|
|
|
Rrok007
Junior Member
USA
149 Posts |
Posted - 03 June 2003 : 15:27:00
|
Cool seems to work now. Does everyone allow even those who haven't registered to vote. I set the poll to everyone, and my non admin account "korloch" couldn't vote. I set it to members only, and then the account could vote. Is there something wrong or is it working right?
|
Believe disbelief and contemplate the simple. |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 03 June 2003 : 16:33:26
|
Yes, "Everyone" mode allows registered members and non-registered members to vote in the poll.
In "Everyone" mode, if you voted when you were logged in as Admin then, then you won't be able to vote again, even if you log out. You don't want users vote when logged in then vote again when they log off. |
Support Snitz Forums
|
|
|
|
Topic |
|
Topic Locked
