quote:

---

Look at the portion:

<% ' ##### Poll Mod #######
if trim(rs("answer1")) = "" then %>
<font color="<% =strForumFontColor %>" face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>"><% =formatStr(rs("T_MESSAGE")) %></font></td>
<% end if %>

Go ahead and delete it :)

Look down about 60 lines you will see a section :

</td>
</tr>
</table>
<% end if %>
<% end if %>

Insert the red codes so it look like this:

</td>
</tr>
</table>
<% end if %>
<% else %>
<font color="<% =strForumFontColor %>" face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>">
<% =formatStr(rs("T_MESSAGE")) %>
</font>
<% end if %>

---

quote:

---

Is there a full zipped version of the above mentioned forum that I can download?
I'm doing a new install and your forum seems to have everything!!!.

---

Not yet Still working out a few display issues.

quote:

---

1-The first message in the topic is always blank.
2-User should not be allowed to take a poll unless logged in.

---

As for number 2 that would be a nice option to have in the control panel. I like polls because it's an easy way for people to get involved. Hopefully if they do a little voting in the polls, they will register and become active members.

#1 seems to be an issue so I am digging into this more now. Hope to have a fix in the next 15 minutes.

Scott LeMieux
NDesigns.net

<!--#INCLUDE FILE="config.asp" -->
<%

dim hithere
hithere = "' '"

set my_Conn = Server.CreateObject("ADODB.Connection")
my_Conn.Open strConnString

'## Forum_SQL
strSql = "UPDATE " & strTablePrefix & "TOPICS "
strSql = strSql & " SET " & strTablePrefix & "TOPICS.answer1 = " & hithere
strSql = strSql & " WHERE " & strTablePrefix & "TOPICS.answer1 IS NULL"

my_conn.Execute (strSql)

set rs = nothing
my_conn.Close

Response.Write("<center><b>That should do it!!</b><br>keep your fingers crossed:)</center>")

%>

quote:

---

How have you done:
1) the online users-thing
2) the poll
at http://209.35.175.12/snitz/ !? Just could you write down the exact way to do that!?

cheers
/CHEETAH

---

quote:

---

quote:

---

I've installed the mod per the instructions at http://209.35.175.12/snitz/polls.txt. The error with the featured topic appears to be fixed. However, I am still getting the error with the first message in each thread displaying a blank message. Any ideas?

HR

---

Hellrazor, this is an MS SQL server specific problem.

If you look at the SELECT statement in topic.asp in Sub GetFirst() make sure that "TOPICS.T_MESSAGE " is the very last field before the FROM.
You probably added something after it and that is what's causing the topic message to be blank.

---

quote:

---

Sorry for using bandwidth. This fix is included in the polls.txt (see first message of this topic) - but I had installed from the ZIPed files and ran into several problems with them.

---

quote:

---

Okay.

I finally got the poll info to show up on the admin options, which is much beeter that where I was yesterday. Now when I select the Set Feature Poll option and I get to the Poll Configuration page, is shows that they are no Polls listed (which is understandable).

What happens is that when I click on the Set Active Poll button I get the following error

******************
Microsoft OLE DB Provider for ODBC Drivers error '80040e10'

[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

/betabulletin/admin_poll.asp, line 22
******************************

Please tell me what to do to fix this problem.

Thanks in advance.

---