Need Help No Clue!!

**Calmaris** · 02-11-2003, 02:55 PM

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>

**Ribeyed** · 02-11-2003, 03:51 PM

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

While Not recordsetDB.EOF

strComments = recordsetDB("Comments").VALUE

recordsetDB.MoveNext
wend
%>

**Ribeyed** · 02-12-2003, 05:49 AM

hi,
here is a very good example of paging:

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

Thread: Need Help No Clue!!

Thread Tools

Display

Need Help No Clue!!

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions