Author |
Topic  |
DJSOUNDS
Starting Member
33 Posts |
Posted - 15 May 2003 : 03:15:36
|
quote: Originally posted by Davio
This is what the sql query is after creating a new poll:
INSERT INTO FORUM_POLLS (CAT_ID, FORUM_ID, TOPIC_ID, P_WHOVOTES, ANSWER1, COUNT1, ANSWER2, COUNT2, ANSWER3, COUNT3, ANSWER4, COUNT4, ANSWER5, COUNT5, ANSWER6, COUNT6, ANSWER7, COUNT7, ANSWER8, COUNT8) VALUES (3, 21, 393, 'everyone', '', 0, '', 0, '', 0, '', 0, 'yep', 0, '', 0, '', 0, '', 0)
As you can see, it is only submitting the 5th answer. The other answers are blank, although I entered something in them.
We are getting somewhere. Starting at line 841, you will find this bit of code:if Request.Form("poll") = "1" then
ReDim txtAns(strMaxVotes)
for i = 1 to strMaxVotes
if trim(Request.Form("answer" & CStr(i))) <> "" then
txtAns(i) = chkString(Request.Form("answer" & CStr(i)),"SQLString")
Response.Write i & ":" & chkString(Request.Form("answer" & CStr(i)),"SQLString") & "<br>"
else
txtAns(i) = ""
end if
next
end if Add the code in red. This is still in the post_info.asp file.
Done  |
 |
|
Davio
Development Team Member
    
Jamaica
12217 Posts |
Posted - 15 May 2003 : 03:25:08
|
I haven't figured it out yet, but I have been online for quite a long time for today. I'll continue with this later. I need to get some sleep. (after 2 am here) |
Support Snitz Forums
|
 |
|
DJSOUNDS
Starting Member
33 Posts |
Posted - 15 May 2003 : 03:26:36
|
quote: Originally posted by Davio
I haven't figured it out yet, but I have been online for quite a long time for today. I'll continue with this later. I need to get some sleep. (after 2 am here)
Same time here. Thank You very much for helping me with this. I feel we are getting close. |
 |
|
Davio
Development Team Member
    
Jamaica
12217 Posts |
Posted - 15 May 2003 : 11:32:17
|
Ok, the last code I asked you to add to line 841, change it to this:Response.Write i & ":" & Request.Form("answer" & CStr(i)) & "<br>" |
Support Snitz Forums
|
 |
|
DJSOUNDS
Starting Member
33 Posts |
Posted - 15 May 2003 : 12:36:18
|
quote: Originally posted by Davio
Ok, the last code I asked you to add to line 841, change it to this:Response.Write i & ":" & Request.Form("answer" & CStr(i)) & "<br>"
Done  |
 |
|
Davio
Development Team Member
    
Jamaica
12217 Posts |
Posted - 15 May 2003 : 14:27:08
|
Ok, in post.asp (not post_info.asp) line 556, you will see this bit of code:" <form name=""PostTopic"" method=""post"" action=""post_info.asp""" Change the text in red to get. |
Support Snitz Forums
|
 |
|
DJSOUNDS
Starting Member
33 Posts |
Posted - 15 May 2003 : 15:53:17
|
quote: Originally posted by Davio
Ok, in post.asp (not post_info.asp) line 556, you will see this bit of code:" <form name=""PostTopic"" method=""post"" action=""post_info.asp""" Change the text in red to get.
Done  |
 |
|
DJSOUNDS
Starting Member
33 Posts |
Posted - 15 May 2003 : 22:48:41
|
Now what? |
 |
|
Davio
Development Team Member
    
Jamaica
12217 Posts |
Posted - 16 May 2003 : 01:46:22
|
Good question. 
The debugging showed that only one 1 answer field from the form is being retrieved. Although I entered data in more than 1 field. I told you to change the form action to "get", so I can see what data is being sent from the form. But all the data is being sent ok. What makes it even puzzling is your code in your files are correct. So it should work.
Is there anyway you can give me temporary access to your test forum folder? Also admin access to your test forum. |
Support Snitz Forums
|
 |
|
DJSOUNDS
Starting Member
33 Posts |
Posted - 16 May 2003 : 03:03:18
|
quote: Originally posted by Davio
Good question. 
The debugging showed that only one 1 answer field from the form is being retrieved. Although I entered data in more than 1 field. I told you to change the form action to "get", so I can see what data is being sent from the form. But all the data is being sent ok. What makes it even puzzling is your code in your files are correct. So it should work.
Is there anyway you can give me temporary access to your test forum folder? Also admin access to your test forum.
Check your email.  |
 |
|
DJSOUNDS
Starting Member
33 Posts |
Posted - 17 May 2003 : 01:33:57
|
I'm here.....Davio?  |
 |
|
DJSOUNDS
Starting Member
33 Posts |
Posted - 17 May 2003 : 08:13:19
|
Decided to pull a backup from 5 months ago that has no Poll Mod. Added new version of Poll and it works fine on the test forum. Will add back the other mods and switch the forum once completed and tested.
Thanks Davio for all the great help you gave me. I don't want to take up anymore of your time on this and I know there's more people who need your help.  |
 |
|
Topic  |
|