| Author |
 Topic  |
|
|
jaydeeplusZzZ
Starting Member
39 Posts |
 Posted - 05 August 2002 : 22:29:45
|
ummm i don't kno if it is a problem.....all i kno is that i got this error at the bottom of poll config page. and i was wondering if this might effect something major
Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 9.
/board1/admin_poll.asp, line 210
now i'm looking at it and this is what is on line 210
this is from 194 to 217
quote:
<%
'## Forum_SQL - Find all records with the search criteria in them
strSql = "SELECT " & strTablePrefix & "FORUM.FORUM_ID, " & strTablePrefix & "FORUM.F_SUBJECT, " & strTablePrefix & "FORUM.CAT_ID, " & strTablePrefix & "TOPICS.TOPIC_ID, " & strTablePrefix & "TOPICS.T_SUBJECT, " & strTablePrefix & "TOPICS.T_STATUS, " & strTablePrefix & "TOPICS.T_LAST_VOTE," & strTablePrefix & "TOPICS.T_REPLIES, " & strMemberTablePrefix & "MEMBERS.MEMBER_ID, " & strMemberTablePrefix & "MEMBERS.M_NAME, "
strSql = strSql & strTablePrefix & "TOPICS.answer1, " & strTablePrefix & "TOPICS.count1, " & strTablePrefix & "TOPICS.answer2, " & strTablePrefix & "TOPICS.count2, " & strTablePrefix & "TOPICS.answer3, " & strTablePrefix & "TOPICS.count3, " & strTablePrefix & "TOPICS.answer4, " & strTablePrefix & "TOPICS.count4, " & strTablePrefix & "TOPICS.answer5, " & strTablePrefix & "TOPICS.count5, " & strTablePrefix & "TOPICS.answer6, " & strTablePrefix & "TOPICS.count6, " & strTablePrefix & "TOPICS.answer7, " & strTablePrefix & "TOPICS.count7, " & strTablePrefix & "TOPICS.answer8, " & strTablePrefix & "TOPICS.count8 "
strSql = strSql & "FROM " & strMemberTablePrefix & "MEMBERS, " & strTablePrefix & "FORUM, "
strSql = strSql & strTablePrefix & "TOPICS, " & strMemberTablePrefix & "MEMBERS AS " & strMemberTablePrefix & "MEMBERS_1 "
strSql = strSql & "WHERE " & strTablePrefix & "TOPICS.T_LAST_POST_AUTHOR = " & strMemberTablePrefix & "MEMBERS_1.MEMBER_ID "
strSql = strSql & "AND " & strTablePrefix & "FORUM.FORUM_ID = " & strTablePrefix & "TOPICS.FORUM_ID "
strSql = strSql & "AND " & strTablePrefix & "FORUM.CAT_ID = " & strTablePrefix & "TOPICS.CAT_ID "
strSql = strSql & "AND " & strMemberTablePrefix & "MEMBERS.MEMBER_ID = " & strTablePrefix & "TOPICS.T_AUTHOR "
strSql = strSql & "AND " & strTablePrefix & "TOPICS.T_ISPOLL = " & 1
if nDays > 0 then
strSql = strSql & " AND (T_LAST_VOTE > '" & defDate & "')"
end if
strSql = strSql & " ORDER BY " & strTablePrefix & "TOPICS.FORUM_ID, " & strTablePrefix & "TOPICS.T_LAST_VOTE DESC"
set rs = my_Conn.Execute(strSql)
Dim vAnswers(8)
Dim vCount(8)
Dim nCount
Dim nTotal
%>
"set rs = my_Conn.Execute(strSql)" is line 210 .......is there something wrong with that?
|
|
|
jaydeeplusZzZ
Starting Member
39 Posts |
Posted - 05 August 2002 : 22:33:19
|
i looked around my forum. i see little small problems. like instead of just " new topic new poll"
there is "new topic new poll
new topic"
did i do something wrong in coding for my default.asp or forum.asp?
|
 |
|
|
fido
Starting Member
30 Posts |
Posted - 05 August 2002 : 23:25:33
|
quote:
i looked around my forum. i see little small problems. like instead of just " new topic new poll"
there is "new topic new poll
new topic"
did i do something wrong in coding for my default.asp or forum.asp?
I had the same problem when I added the poll mod to my forum. I had to change some of the code around. Here is what my sub PostNewTopic() looks like:
quote:
sub PostNewTopic()
%>
<font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>">
<% if Cat_Status = 0 or Forum_Status = 0 then
if (AdminAllowed = 1) then %>
<a href="post.asp?method=Topic&FORUM_ID=<% =Forum_ID%>&CAT_ID=<% =Cat_ID%>&Forum_Title=<% =ChkString(Forum_Subject,"urlpath") %>"><img src="icon_folder_locked.gif" alt="Category Locked" height=15 width=15 border=0></a> <a href="post.asp?method=Topic&FORUM_ID=<% =Forum_ID%>&CAT_ID=<% =Cat_ID%>&Forum_Title=<% =ChkString(Forum_Subject,"urlpath") %>">New Topic</a><br>
<% ' #################### Poll Mod ##################### %>
<a href="post.asp?poll=1&method=Topic&FORUM_ID=<% =Forum_ID%>&CAT_ID=<% =Cat_ID%>&Forum_Title=<% =ChkString(Forum_Subject,"urlpath") %>"><img src="pin.gif" alt="Add Poll" height=15 width=15 border=0></a> <a href="post.asp?poll=1&method=Topic&FORUM_ID=<% =Forum_ID%>&CAT_ID=<% =Cat_ID%>&Forum_Title=<% =ChkString(Forum_Subject,"urlpath") %>">Add Poll</a>
<% ' ################################################### %>
<% else %>
<img src="icon_folder_locked.gif" alt="Category Locked" height=15 width=15 border=0> Category Locked
<% end if
else
if Forum_Status <> 0 then %>
<% ' #################### Poll Mod ##################### %>
<a href="post.asp?method=Topic&FORUM_ID=<% =Forum_ID%>&CAT_ID=<% =Cat_ID%>&Forum_Title=<% =ChkString(Forum_Subject,"urlpath") %>"><img src="icon_folder_new_topic.gif" alt="New Topic" height=15 width=15 border=0></a> <a href="post.asp?method=Topic&FORUM_ID=<% =Forum_ID%>&CAT_ID=<% =Cat_ID%>&Forum_Title=<% =ChkString(Forum_Subject,"urlpath") %>">New Topic</a>
<% if (strUserPolls = "1") or (AdminAllowed = 1) then %>
<a href="post.asp?poll=1&method=Topic&FORUM_ID=<% =Forum_ID%>&CAT_ID=<% =Cat_ID%>&Forum_Title=<% =ChkString(Forum_Subject,"urlpath") %>"><img src="pin.gif" alt="Add Poll" height=15 width=15 border=0></a> <a href="post.asp?poll=1&method=Topic&FORUM_ID=<% =Forum_ID%>&CAT_ID=<% =Cat_ID%>&Forum_Title=<% =ChkString(Forum_Subject,"urlpath") %>">Add Poll</a>
<% end if
' ################################################### %>
<!--- <a href="post.asp?method=Topic&FORUM_ID=<% =Forum_ID%>&CAT_ID=<% =Cat_ID%>&Forum_Title=<% =ChkString(Forum_Subject,"urlpath") %>"><img src="icon_folder_new_topic.gif" alt="New Topic" height=15 width=15 border=0></a> <a href="post.asp?method=Topic&FORUM_ID=<% =Forum_ID%>&CAT_ID=<% =Cat_ID%>&Forum_Title=<% =ChkString(Forum_Subject,"urlpath") %>">New Topic</a><br>--->
<% else %>
<img src="icon_folder_locked.gif" alt="FORUM Locked" height=15 width=15 border=0> Forum Locked
<% end if
end if
' DEM --> Start of Code added to handle subscription processing.
if (strSubscription < 4 and strSubscription > 0) and (Cat_Subscription = 1 or Cat_Subscription = 2) and Forum_Subscription = 1 then
CheckSubscription "FORUM", MemberID, Cat_ID, Forum_ID, 0, "", ""
end if
' DEM --> End of code added to handle subscription processing.
%>
</font>
<%
end sub
And... I don't remember if I had to modify the code in topic.asp or not, but this is what my section looks like - and it's working properly:
quote:
<% ' ################ Poll Mod ###################
if (strUserPolls = "1") or (AdminAllowed = 1) then %>
<a href="post.asp?poll=1&method=Topic&FORUM_ID=<% =Forum_ID %>&CAT_ID=<% =Cat_ID %>&Forum_Title=<% =ChkString(Forum_Subject,"urlpath") %>"><img src="pin.gif" height=15 width=15 alt="Add Poll" border=0></a> <a href="post.asp?poll=1&method=Topic&FORUM_ID=<% =Forum_ID %>&CAT_ID=<% =Cat_ID %>&Forum_Title=<% =ChkString(Forum_Subject,"urlpath") %>">Add Poll</a><br>
<% end if
' ############################################ %>
<% else
if (AdminAllowed = 1) then %>
<a href="post.asp?<%= ArchiveLink %>method=Topic&FORUM_ID=<% =Forum_ID %>&CAT_ID=<% =Cat_ID %>&Forum_Title=<% =ChkString(Forum_Subject,"urlpath") %>"><img src="icon_folder_locked.gif" height=15 width=15 border=0></a> <a href="post.asp?<%= ArchiveLink %>method=Topic&FORUM_ID=<% =Forum_ID %>&CAT_ID=<% =Cat_ID %>&Forum_Title=<% =ChkString(Forum_Subject,"urlpath") %>">New Topic</a>
<% ' ################ Poll Mod ################### %>
<a href="post.asp?poll=1&method=Topic&FORUM_ID=<% =Forum_ID %>&CAT_ID=<% =Cat_ID %>&Forum_Title=<% =ChkString(Forum_Subject,"urlpath") %>"><img src="pin.gif" height=15 width=15 alt="Add Poll" border=0></a> <a href="post.asp?poll=1&method=Topic&FORUM_ID=<% =Forum_ID %>&CAT_ID=<% =Cat_ID %>&Forum_Title=<% =ChkString(Forum_Subject,"urlpath") %>">Add Poll</a><br>
<% ' ############################################ %>
Maybe this will help you with at least one of your problems.
|
|
|
|
jaydeeplusZzZ
Starting Member
39 Posts |
Posted - 05 August 2002 : 23:49:15
|
ok that first coding.....what .asp file is that?
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 06 August 2002 : 07:44:24
|
Jay, would you be willing to email me your ftp details? And I will install the mod for you. And whatever other problems you are having with the other mods.
«-----------------------------------»
Join the Snitz Forums WebRing ! |
|
|
| |
Topic |
|
|
|
Topic Locked
