Print Page | Close Window

Newest topics--Marquee

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=2324
Printed Date: 31 March 2026 at 4:31pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Newest topics--Marquee
Posted By: somy
Subject: Newest topics--Marquee
Date Posted: 30 April 2003 at 12:43pm

hello i tried to make a marquee with the newest posts but i get Error when using this code <Not Syntax Error>


when i click on a topic , it display the next one, not it


for example:


the marquee is


 Topic 1  ::: Topic2::: topic3


when i click on topic2 it displays topic 3


so what's wrong, here is my codes


file attached.....


<%
Dim rsLastestPostsMod
Dim strSQLMod
Dim adoConMod
Dim strModCon
Dim strTopicSubject

'Database connection
'-----------------------------
'-----------------------------
strModCon = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & .MapPath("**************.mdb")
'-----------------------------
'-----------------------------

Set rsLastestPostsMod = .Create("ADODB.Recordset")

strSQLMod = " Top 15 tblTopic.Topic_ID, tblTopic.Subject, tblForum.Forum_ID "
strSQLMod = strSQLMod & "FROM tblForum INNER JOIN tblTopic ON tblForum.Forum_ID = tblTopic.Forum_ID "
strSQLMod = strSQLMod & "WHERE ((tblForum.) Is Null) "
strSQLMod = strSQLMod & "ORDER BY tblTopic.Last_entry_date DESC;"

rsLastestPostsMod.Open strSQLMod, strModCon

If rsLastestPostsMod.EOF Then
     Response.Write "<span class=""smltext"">No Forum Posts Made</span>"
Else
Response.Write("< 'slide' width='99%' behavior='alternate' scrolldelay='0'>")
     Do while NOT rsLastestPostsMod.EOF

               Response.Write(" "forum_posts.asp?TID=" & rsLastestPostsMod"Topic_ID" & "&PN1=" - " & strTopicSubject & " ")

          If len(rsLastestPostsMod("Subject"))>30 then
               strTopicSubject = left(rsLastestPostsMod("Subject"),30) & "... "
          Else
               strTopicSubject = rsLastestPostsMod("Subject")
          End If
          

          
          
     rsLastestPostsMod.MoveNext
     If NOT rsLastestPostsMod.EOF Then Response.Write("  ")

     Loop
End If
Response.Write("<>")
rsLastestPostsMod.Close
Set rsLastestPostsMod = Nothing
%>



-------------
www.3al2ahwa.tk



Replies:
Posted By: somy
Date Posted: 30 April 2003 at 12:45pm

how can i upload my file



-------------
www.3al2ahwa.tk


Posted By: MadDog
Date Posted: 30 April 2003 at 12:55pm
You cant.

-------------
http://www.iportalx.net" rel="nofollow">


Posted By: somy
Date Posted: 30 April 2003 at 4:24pm

it is the same file of new posts, but with marquee,it open and go to the next topic

Any ideas plzzzzzzzzzzzzzzzzzzzz

 



-------------
www.3al2ahwa.tk



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net