Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Newest topics--Marquee
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Newest topics--Marquee

 Post Reply Post Reply
Author
somy View Drop Down
Newbie
Newbie
Avatar

Joined: 05 April 2003
Location: Egypt
Status: Offline
Points: 22
Post Options Post Options   Thanks (0) Thanks(0)   Quote somy Quote  Post ReplyReply Direct Link To This Post Topic: Newest topics--Marquee
    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("" & 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
%>



Edited by -boRg-
Back to Top
somy View Drop Down
Newbie
Newbie
Avatar

Joined: 05 April 2003
Location: Egypt
Status: Offline
Points: 22
Post Options Post Options   Thanks (0) Thanks(0)   Quote somy Quote  Post ReplyReply Direct Link To This Post Posted: 30 April 2003 at 12:45pm

how can i upload my file

Back to Top
MadDog View Drop Down
Mod Builder Group
Mod Builder Group
Avatar

Joined: 01 January 2002
Status: Offline
Points: 3008
Post Options Post Options   Thanks (0) Thanks(0)   Quote MadDog Quote  Post ReplyReply Direct Link To This Post Posted: 30 April 2003 at 12:55pm
You cant.
Back to Top
somy View Drop Down
Newbie
Newbie
Avatar

Joined: 05 April 2003
Location: Egypt
Status: Offline
Points: 22
Post Options Post Options   Thanks (0) Thanks(0)   Quote somy Quote  Post ReplyReply Direct Link To This Post 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

 

Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.