www.webdeveloper.com
Results 1 to 3 of 3

Thread: Need Help No Clue!!

  1. #1
    Join Date
    Feb 2003
    Location
    Sault Ste Marie, On, Canada
    Posts
    168

    Unhappy Need Help No Clue!!

    HOW DO YOU TAKE ALL OF THE COMMENTS OUT OF THE DATABASE AND PUT THEM ON THE WEB PAGE THE WAY THE THREAD SYSTEM WORKS IN THIS FORUM. I ONLY KNOW HOW TO PUT THE FIRST COMMENT IN THE DATABASE ONTO THE WEB PAGE. DO YOU USE A COUNT UNTIL EOF? AND HOW DO YOU SAY ONLY PUT LIKE 10 COMMENTS ON A PAGE THEN THE USER CLICKS NEXT AND THE WEB PAGE DISPLAYS THE NEXT 10 COMMENTS? SOME EXAMPLE CODE WOULD BE MUCH APPRECIATED!!

    <% @Language = VBScript %>
    <% Option Explicit %>
    <%

    Dim dbConn, dbQuery, recordsetDB, strComments, strQueryString1


    If IsObject(Session("users_dbConn") ) Then
    Set dbConn= Session("users_dbConn")
    Else
    Set dbConn = Server.CreateObject("ADODB.Connection")

    Call dbConn.Open ("Appdb1","Anyone","Anyone")

    Set Session("users_dbConn")= dbConn
    End If
    %>

    <%
    strquerystring1 = "SELECT Comments.Comments FROM Comments "
    recordsetDB = dbconn.execute(strquerystring1)

    strComments = recordsetDB("Comments").VALUE

    Set recordsetDB = dbConn.Execute(strquerystring1)
    %>
    <html>

    <head>
    <title>View Comments</title>
    </head>

    <body background="grback.jpg">
    COMMENTS ABOUT THE SITE AND THE HUNTING TRIPS <BR>
    <%=strComments%>

    </body>

    </html>

  2. #2
    Join Date
    Jan 2003
    Location
    Dundee, Scotland
    Posts
    1,367
    hi,
    <%
    strquerystring1 = "SELECT Comments.Comments FROM Comments "
    recordsetDB = dbconn.execute(strquerystring1)


    While Not recordsetDB.EOF

    strComments = recordsetDB("Comments").VALUE

    recordsetDB.MoveNext
    wend
    %>
    ----------------------------------

  3. #3
    Join Date
    Jan 2003
    Location
    Dundee, Scotland
    Posts
    1,367
    hi,
    here is a very good example of paging:

    http://www.aspfaq.com/show.asp?id=2120
    ----------------------------------

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles