| Author |
 Topic  |
|
|
Syedur
New Member
USA
93 Posts |
 Posted - 02 June 2001 : 17:12:25
|
Hi guys,
I added the poll mod to my forum.
Everything is running fine so far, I guess.
Except for I can't edit any posts.
I can post a new message, but when I try to edit a post message it give me the following error.Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/e-syednet/forums/post.asp, line 386
What I have on my line 386 is this line...
set rs = my_Conn.Execute (strSql)
Thanks a lot.
|
|
|
Syedur
New Member
USA
93 Posts |
Posted - 02 June 2001 : 17:20:59
|
Um.. Guys
Add another problem to this.
When I try to post a poll question eveytime it takes me to YOU MUST POST AT LIST ONE POLL ANSWER even though I have filled out 1 or more answer fields.
Thanks a lot.
http://64.23.82.10/e-syednet/forums/default.asp
|
 |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 02 June 2001 : 18:28:23
|
Sounds like you didn't add all the code to the files or you added them incorrectly.
For your first problem, can you post like the first 10 lines before the line 386 in your post.asp file.
The code "set rs = my_Conn.Execute (strSql)" is when the page executes the "strSql" command, that was written before it. So what I need is the strSql statements that came before that line.
For your second problem, I'll take a look at your forums to see what might be the problem. The only reason it would tell you that message is if the first text box is empty.
|
|
|
|
Iron Heart
New Member
USA
66 Posts |
Posted - 02 June 2001 : 18:51:11
|
Both errors are clearly due to an overlook of some bit of code. Go through the instructions again and check the code you've added at every step.
S.P.S.W. - My Forums |
|
|
|
Syedur
New Member
USA
93 Posts |
Posted - 02 June 2001 : 19:05:38
|
Ok..
For the second problem, yes I did fill out the first input field.
....
For the second problem, here are what you asked for...
case "Forum"
Msg = Msg & "<b>Note:</b> You must be an administrator to create a new forum.<br>"
case "URL"
Msg = Msg & "<b>Note:</b> You must be an administrator to create a new web link.<br>"
case "Edit"
Msg = Msg & "<b>Note:</b> Only the poster of this message, and the Moderator can edit the message."
case "EditTopic"
Msg = Msg & "<b>Note:</b> Only the poster of this message, and the Moderator can edit the message."
case "EditForum"
Msg = Msg & "<b>Note:</b> Only the Moderator can edit the message."
case "EditCategory"
Msg = Msg & "Note: Only an administrator can edit the subject."
end select
if strRqMethod = "Edit" or _
strRqMethod = "ReplyQuote" then
'## Forum_SQL
' ############## Poll Mod - 1 line #################
strSql = "SELECT " & strTablePrefix & "TOPICS.CAT_ID, " & strTablePrefix & "TOPICS.FORUM_ID, " & strTablePrefix & "TOPICS.TOPIC_ID, " & strTablePrefix & "TOPICS.T_SUBJECT, " & strTablePrefix & "TOPICS.T_AUTHOR, " & strTablePrefix & "TOPICS.T_MAIL, " & strTablePrefix & "TOPICS.answer1, " & strTablePrefix & "TOPICS.answer2, " & strTablePrefix & "TOPICS.answer3, " & strTablePrefix & "TOPICS.answer4, " & strTablePrefix & "TOPICS.answer5, " & strTablePrefix & "TOPICS.answer6, " & strTablePrefix & "TOPICS.answer7, " & strTablePrefix & "TOPICS.answer8, " & strTablePrefix & "TOPICS.T_MESSAGE "
strSql = strSql & " FROM " & strTablePrefix & "REPLY "
strSql = strSql & " WHERE " & strTablePrefix & "REPLY.REPLY_ID = " & Request.QueryString("REPLY_ID")
set rs = my_Conn.Execute (strSql)
strAuthor = rs("R_AUTHOR") my post.asp page line 386 and down. (counting from the bottom).
Later.
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 02 June 2001 : 19:15:23
|
You placed the poll mod code incorrectly into the file.
You see this code:if strRqMethod = "Edit" or _
strRqMethod = "ReplyQuote" then If you look a few lines below that you will see this code:if strRqMethod = "EditTopic" or _
strRqMethod = "TopicQuote" then That's where you need to put the poll mod code. After that "if...else" statement.
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 02 June 2001 : 19:19:14
|
Also could you give me a username|password to your forum so i can test the "YOU MUST POST AT LIST ONE POLL ANSWER" error problem?
I tried to register but I got an error.
|
|
|
|
Syedur
New Member
USA
93 Posts |
Posted - 02 June 2001 : 22:05:27
|
Hey Davio!
Sorry about the trouble...
I do believe that I fixed the sign up error. It was the same error line
set rs = my_Conn.Execute (strSql)
that is really strange... because I didn't modify register.asp file.
Anyway, I had a backup file that I uploaded and it works now.
--------------
As for the post.asp page... Thanks man.
I got carried away... I just don't know what I was thinking...!!!
I have fixed it.
Thank You.
|
|
|
|
Syedur
New Member
USA
93 Posts |
Posted - 03 June 2001 : 14:44:10
|
Ok...
Thank you guys.
I fixed my problem anyway...
I re-edited post.asp and post_info.asp
Thanks a lot.
Later.
There is a time in every man’s education when he arrivers at the conviction that envy is ignorance; that imitation is suicide. |
|
|
| |
Topic |
|
Topic Locked
