Snitz Forums 2000
Home
|
Profile
|
Register
|
Active Topics
|
Members
|
Search
|
FAQ
Username:
Password:
Save Password
Forgot your Password?
All Forums
Snitz Forums 2000 MOD-Group
MOD Add-On Forum (W/Code)
Front page top 5 active topics
New Topic
Topic Locked
Printer Friendly
Author
Topic
Medic397
New Member
80 Posts
Posted - 10 November 2002 : 19:59:22
Before I post what my problem is there a link to help me with this. I have searched for two and must not have put in the proper words or don't know how to work the search function.
Edited by - ruirib on 10 November 2002 22:10:14
Medic397
New Member
80 Posts
Posted - 10 November 2002 : 20:44:47
<%
Dim sQLQuery
Dim count
'set count to 1
count = "0"
sQLQuery = "select TOP 5 FORUM_TOPICS.TOPIC_ID, FORUM_TOPICS.T_SUBJECT, FORUM_TOPICS.T_MESSAGE," & _
" FORUM_TOPICS.T_DATE from FORUM_TOPICS" & _
" ORDER BY FORUM_TOPICS.TOPIC_ID DESC;"
Set dataConn = Server.CreateObject("ADODB.Connection")
dataConn.Open strConnString
Set RSlist = Server.CreateObject("ADODB.recordset")
Rslist.Open sqlQuery, dataConn
Do While Not RSlist.EOF
response.write "<a href=""/forum/topic.asp?TOPIC_ID=" & RSlist("TOPIC_ID") & " "" " & " class=""LINK"" > Subject : " & VBNewline & _
RSlist("T_SUBJECT") & "</a><BR>" & VBNewline
response.write "<span class=""MenuTopic""> " & Trim(Left(RemoveHTML(RSlist("T_MESSAGE")), 50)) & "....</span>" & "<BR>" & VBNewline
response.write "<span class=""MenuTopic2"">Posted : " & StrToDate(RSlist("T_DATE")) & "</span><BR>" & VBNewline
'increment count
count = count + 1
RSlist.Movenext
Loop%>
That is the code I am using. It works on earlier versions. Here is my problem.
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'RemoveHTML'
/inc_bottom.asp, line 38
DoraMoon
Average Member
Taiwan
661 Posts
Posted - 10 November 2002 : 20:51:15
i think it just mean it can't found the
RemoveHTML
function..
try copy this function from your earlier inc_functions.asp to your new inc_func_common.asp
Medic397
New Member
80 Posts
Posted - 10 November 2002 : 20:57:09
Thank you very much that solved my problem. :)
Topic
New Topic
Topic Locked
Printer Friendly
Jump To:
Select Forum
Announcements
Announcements: Security Related Bug Fixes
Announcements: Community
Announcements: New Releases
A Testing Area
Testing Forums
Help Groups for Snitz Forums 2000 Users
Help: General / MVC version(v1.XX)
Help: General / Classic ASP versions(v3.4.XX)
Help: General / Previous versions
Help: Database: MS Access
Help: Database: MS SQL Server
Help: Database: MySql
Help: Mail Configuration
Help: MOD Implementation
Help: Authentication: NT
Help: General / Current Version (Old)
Frequently Asked Questions
FAQ About This Site
HOW DO I FAQs
FAQs for Using Snitz with Access
FAQs for Using Snitz with mySQL
FAQs for Using Snitz with SQLServer
FAQ for Beginners to Snitz Forums
FAQ For Developers
FAQ for Webmasters
FAQ Addition Requests
Snitz Forums 2000 MOD-Group
Mod Integration Project (BUG Reports)
MOD Completed Add-Ons
MOD Add-On Forum (W/Code)
MOD Add-On Forum (W/O Code)
Community Forums
Graphics & Style in Snitz!
Suggest forum.snitz.com Content
Show-Off Your Forums
Code Support: ASP (Non-Forum Related)
Code Support: ASP.NET (Non-Forum Related)
Community Discussions (All other subjects)
Snitz Forums 2000 DOC-Group
DOC Discussion
DOC In-Box
DOC Out-Box
Snitz Forums 2000 DEV-Group
DEV Bug Reports (Open)
DEV Discussions (General)
DEV Discussions (Oracle)
DEV Discussions (VFP)
DEV Bug Reports (Closed)
DEV Internationalization (v4-archive)
DEV Internationalization (v4)
URLs and Other Resources
Snitz Forums 2000 - Classic ASP version
SnitzBitz
Snitz MVC development site
Snitz Downloads/etc...
SourceForge
--------------------
Home
Active Topics
Frequently Asked Questions
Member Information
Search Page
Snitz Forums 2000
© 2000-2021 Snitz™ Communications
This page was generated in 0.21 seconds.
Topic Locked
Posted - 10 November 2002 : 19:59:22
