Avatar billede ..jan Nybegynder
28. juni 2001 - 13:58 Der er 5 kommentarer og
1 løsning

problem med forum

jeg har downloadet et lille simpelt forum, det virker fint pånær at når der står 5 meddelelser laver det så en ny side med de næste 5 osv. jeg vil gerne have omkring 25 meddelelser før den laver en ny side.
til forummet er der følgende filer:
forum.asp - forside af forummet
post.asp -  der hvor man skriver beskeden
message.asp - hvor man kan se et indlæg
done.asp - bekræftigelses side
forum.mdb - db
adovbs.inc - configuration ???
jeg går ud fra at det er i adovbs.inc der skal ændres noget, så her er hele adovbs.inc den er ganske vidst lidt lang i det, men jeg aner ikke hvor jeg skal ændre.
___________________________
\'---- CursorTypeEnum Values ----
Const adOpenForwardOnly = 0
Const adOpenKeyset = 1
Const adOpenDynamic = 2
Const adOpenStatic = 3

\'---- CursorOptionEnum Values ----
Const adHoldRecords = &H00000100
Const adMovePrevious = &H00000200
Const adAddNew = &H01000400
Const adDelete = &H01000800
Const adUpdate = &H01008000
Const adBookmark = &H00002000
Const adApproxPosition = &H00004000
Const adUpdateBatch = &H00010000
Const adResync = &H00020000
Const adNotify = &H00040000

\'---- LockTypeEnum Values ----
Const adLockReadOnly = 1
Const adLockPessimistic = 2
Const adLockOptimistic = 3
Const adLockBatchOptimistic = 4

\'---- ExecuteOptionEnum Values ----
Const adRunAsync = &H00000010

\'---- ObjectStateEnum Values ----
Const adStateClosed = &H00000000
Const adStateOpen = &H00000001
Const adStateConnecting = &H00000002
Const adStateExecuting = &H00000004

\'---- CursorLocationEnum Values ----
Const adUseServer = 2
Const adUseClient = 3

\'---- DataTypeEnum Values ----
Const adEmpty = 0
Const adTinyInt = 16
Const adSmallInt = 2
Const adInteger = 3
Const adBigInt = 20
Const adUnsignedTinyInt = 17
Const adUnsignedSmallInt = 18
Const adUnsignedInt = 19
Const adUnsignedBigInt = 21
Const adSingle = 4
Const adDouble = 5
Const adCurrency = 6
Const adDecimal = 14
Const adNumeric = 131
Const adBoolean = 11
Const adError = 10
Const adUserDefined = 132
Const adVariant = 12
Const adIDispatch = 9
Const adIUnknown = 13
Const adGUID = 72
Const adDate = 7
Const adDBDate = 133
Const adDBTime = 134
Const adDBTimeStamp = 135
Const adBSTR = 8
Const adChar = 129
Const adVarChar = 200
Const adLongVarChar = 201
Const adWChar = 130
Const adVarWChar = 202
Const adLongVarWChar = 203
Const adBinary = 128
Const adVarBinary = 204
Const adLongVarBinary = 205

\'---- FieldAttributeEnum Values ----
Const adFldMayDefer = &H00000002
Const adFldUpdatable = &H00000004
Const adFldUnknownUpdatable = &H00000008
Const adFldFixed = &H00000010
Const adFldIsNullable = &H00000020
Const adFldMayBeNull = &H00000040
Const adFldLong = &H00000080
Const adFldRowID = &H00000100
Const adFldRowVersion = &H00000200
Const adFldCacheDeferred = &H00001000

\'---- EditModeEnum Values ----
Const adEditNone = &H0000
Const adEditInProgress = &H0001
Const adEditAdd = &H0002
Const adEditDelete = &H0004

\'---- RecordStatusEnum Values ----
Const adRecOK = &H0000000
Const adRecNew = &H0000001
Const adRecModified = &H0000002
Const adRecDeleted = &H0000004
Const adRecUnmodified = &H0000008
Const adRecInvalid = &H0000010
Const adRecMultipleChanges = &H0000040
Const adRecPendingChanges = &H0000080
Const adRecCanceled = &H0000100
Const adRecCantRelease = &H0000400
Const adRecConcurrencyViolation = &H0000800
Const adRecIntegrityViolation = &H0001000
Const adRecMaxChangesExceeded = &H0002000
Const adRecObjectOpen = &H0004000
Const adRecOutOfMemory = &H0008000
Const adRecPermissionDenied = &H0010000
Const adRecSchemaViolation = &H0020000
Const adRecDBDeleted = &H0040000

\'---- GetRowsOptionEnum Values ----
Const adGetRowsRest = -1

\'---- PositionEnum Values ----
Const adPosUnknown = -1
Const adPosBOF = -2
Const adPosEOF = -3

\'---- enum Values ----
Const adBookmarkCurrent = 0
Const adBookmarkFirst = 1
Const adBookmarkLast = 2

\'---- MarshalOptionsEnum Values ----
Const adMarshalAll = 0
Const adMarshalModifiedOnly = 1

\'---- AffectEnum Values ----
Const adAffectCurrent = 1
Const adAffectGroup = 2
Const adAffectAll = 3

\'---- FilterGroupEnum Values ----
Const adFilterNone = 0
Const adFilterPendingRecords = 1
Const adFilterAffectedRecords = 2
Const adFilterFetchedRecords = 3
Const adFilterPredicate = 4

\'---- SearchDirection Values ----
Const adSearchForward = 1
Const adSearchBackward = -1

\'---- ConnectPromptEnum Values ----
Const adPromptAlways = 1
Const adPromptComplete = 2
Const adPromptCompleteRequired = 3
Const adPromptNever = 4

\'---- ConnectModeEnum Values ----
Const adModeUnknown = 0
Const adModeRead = 1
Const adModeWrite = 2
Const adModeReadWrite = 3
Const adModeShareDenyRead = 4
Const adModeShareDenyWrite = 8
Const adModeShareExclusive = &Hc
Const adModeShareDenyNone = &H10

\'---- IsolationLevelEnum Values ----
Const adXactUnspecified = &Hffffffff
Const adXactChaos = &H00000010
Const adXactReadUncommitted = &H00000100
Const adXactBrowse = &H00000100
Const adXactCursorStability = &H00001000
Const adXactReadCommitted = &H00001000
Const adXactRepeatableRead = &H00010000
Const adXactSerializable = &H00100000
Const adXactIsolated = &H00100000

\'---- XactAttributeEnum Values ----
Const adXactCommitRetaining = &H00020000
Const adXactAbortRetaining = &H00040000

\'---- PropertyAttributesEnum Values ----
Const adPropNotSupported = &H0000
Const adPropRequired = &H0001
Const adPropOptional = &H0002
Const adPropRead = &H0200
Const adPropWrite = &H0400

\'---- ErrorValueEnum Values ----
Const adErrInvalidArgument = &Hbb9
Const adErrNoCurrentRecord = &Hbcd
Const adErrIllegalOperation = &Hc93
Const adErrInTransaction = &Hcae
Const adErrFeatureNotAvailable = &Hcb3
Const adErrItemNotFound = &Hcc1
Const adErrObjectInCollection = &Hd27
Const adErrObjectNotSet = &Hd5c
Const adErrDataConversion = &Hd5d
Const adErrObjectClosed = &He78
Const adErrObjectOpen = &He79
Const adErrProviderNotFound = &He7a
Const adErrBoundToCommand = &He7b
Const adErrInvalidParamInfo = &He7c
Const adErrInvalidConnection = &He7d
Const adErrStillExecuting = &He7f
Const adErrStillConnecting = &He81

\'---- ParameterAttributesEnum Values ----
Const adParamSigned = &H0010
Const adParamNullable = &H0040
Const adParamLong = &H0080

\'---- ParameterDirectionEnum Values ----
Const adParamUnknown = &H0000
Const adParamInput = &H0001
Const adParamOutput = &H0002
Const adParamInputOutput = &H0003
Const adParamReturnValue = &H0004

\'---- CommandTypeEnum Values ----
Const adCmdUnknown = &H0008
Const adCmdText = &H0001
Const adCmdTable = &H0002
Const adCmdStoredProc = &H0004

\'---- SchemaEnum Values ----
Const adSchemaProviderSpecific = -1
Const adSchemaAsserts = 0
Const adSchemaCatalogs = 1
Const adSchemaCharacterSets = 2
Const adSchemaCollations = 3
Const adSchemaColumns = 4
Const adSchemaCheckConstraints = 5
Const adSchemaConstraintColumnUsage = 6
Const adSchemaConstraintTableUsage = 7
Const adSchemaKeyColumnUsage = 8
Const adSchemaReferentialContraints = 9
Const adSchemaTableConstraints = 10
Const adSchemaColumnsDomainUsage = 11
Const adSchemaIndexes = 12
Const adSchemaColumnPrivileges = 13
Const adSchemaTablePrivileges = 14
Const adSchemaUsagePrivileges = 15
Const adSchemaProcedures = 16
Const adSchemaSchemata = 17
Const adSchemaSQLLanguages = 18
Const adSchemaStatistics = 19
Const adSchemaTables = 20
Const adSchemaTranslations = 21
Const adSchemaProviderTypes = 22
Const adSchemaViews = 23
Const adSchemaViewColumnUsage = 24
Const adSchemaViewTableUsage = 25
Const adSchemaProcedureParameters = 26
Const adSchemaForeignKeys = 27
Const adSchemaPrimaryKeys = 28
Const adSchemaProcedureColumns = 29
%>


Avatar billede ..jan Nybegynder
28. juni 2001 - 13:59 #1
adressen til forummet er forøvrigt www.paragliding.dk
Avatar billede keysersoze Guru
28. juni 2001 - 14:05 #2
det skal ikke ændres i ovenstående...

em find en linie hvor der står:

PageSize = 5

det skal så ændres til

PageSize = 25
Avatar billede keysersoze Guru
28. juni 2001 - 14:06 #3
prøv evt at poste koden fra:

forum.asp
Avatar billede ..jan Nybegynder
28. juni 2001 - 14:08 #4
forum.asp:


<% @ LANGUAGE = \"VBSCRIPT\" %>
<% response.buffer=True
  response.expires = 0 %>
<!--#include File=\"adovbs.inc\"-->
<%
\'*********************************************************************************************
\'January/2000
\'********************************************************************************************** 
if request.servervariables(\"CONTENT_LENGTH\") <> 0 and Request(\"Mv\") = \"\" then

name = server.HtmlEncode(request.form(\"txtName\"))
email = server.HtmlEncode(request.form(\"txtEmail\"))
topic = server.HtmlEncode(request.form(\"txtTopic\"))
message = request.form(\"txtMessage\")
ref = CInt(request.form(\"reference\"))

if name = \"\" or email = \"\" or topic = \"\" or message = \"\" then
    response.redirect (\"post.asp?err=true&ref=\" & ref)
end if

message = replace(server.HTMLEncode(message),VBCrlf, \"<BR>\")

curDir = Server.MapPath(\"db/ForumDb.mdb\")
Set oConn = Server.CreateObject(\"ADODB.Connection\")

oConn.Provider = \"Microsoft.Jet.OLEDB.4.0\"
oConn.ConnectionString = \"Data Source=\" & Server.MapPath (\"db/ForumDb.mdb\")
oConn.Open

Set oRs = Server.CreateObject(\"ADODB.Recordset\")
oRs.Open \"SELECT * from forum\", oConn, 1,3

if oRs.recordcount <> 0 then
    oRs.movelast
        ult = oRs(\"code\") + 1
else
        ult = 1   
end if
    oRs.addnew
        oRs(\"Code\") = ult
        oRs(\"reference\") = ref
        oRs(\"name\") = name
        oRs(\"email\") = email
        oRs(\"topic\") = topic
        oRs(\"message\") = message
        oRs(\"PostDate\") = date
    oRs.update

set oRs = nothing
set oConn = nothing
response.redirect (\"done.asp\")
end if

\'**********************************************************************************************

curDir = Server.MapPath(\"db/ForumDb.mdb\")
Set oConn = Server.CreateObject(\"ADODB.Connection\")

oConn.Provider = \"Microsoft.Jet.OLEDB.4.0\"
oConn.ConnectionString = \"Data Source=\" & Server.MapPath (\"db/ForumDb.mdb\")
oConn.Open

Mv = request.querystring(\"direction\")

If request.querystring(\"page\") = \"\" Then
    PageNo = 1
Else
        PageNo = request.querystring(\"page\")
End If

Set oRs = Server.CreateObject(\"ADODB.Recordset\")
oRs.Open \"SELECT * from forum where reference = -1\", oConn, adOpenStatic

oRs.PageSize = 5

If Mv = \"previous\" or Mv = \"next\" Then
Select Case Mv
    Case \"previous\"
            If PageNo > 1 Then
                  PageNo = PageNo - 1
            Else
                  PageNo = 1
            End If
    Case \"next\"
            If oRs.AbsolutePage <  oRs.PageCount Then
              PageNo = PageNo + 1
            Else
              PageNo = oRs.PageCount
            End If
    Case Else
            PageNo = 1
End Select
End If
%>
<html>
<head>
<title>Forum</title>
<meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-1\">
<style TYPE=\"text/css\">
    <!--
    A:link {color:yellow;}
    A:visited {color:yellow;}
    A:hover {color:red;}
    A:active {color:red;}
    A {text-decoration:none}
    -->
</style>
<base target=\"_self\">
</head>

<body bgcolor=\"#200C60\" text=\"#FFFFFF\" link=\"#FFFF00\" vlink=\"#FFFF00\">
<Form Action=\"\" Method=\"POST\" name=\"\">
<div align=\"center\">
  <b><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"2\" color=\"#99FFFF\"><a href=\"../post.asp?type=new\"><br>
  </a></font></b>
  <table width=\"43%\" border=\"0\">
    <tr bgcolor=\"#333333\" bordercolor=\"#FFFF00\">
      <td>
          <div align=\"center\"><b><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"2\" color=\"#99FFFF\"><a href=\"../post.asp?type=new\">*
            Skriv en ny meddelelse *</a></font></b></div>
      </td>
    </tr>
  </table>
    <% If oRs.recordcount <> 0 then %> <font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"2\" color=\"#00FFFF\"><b>Side
    <%=PageNo%>  af <%=oRs.PageCount%></b></font><br>
    <%  If PageNo > 1 Then %>| <a href =\"<%= request.servervariables(\"script_name\") %>?page=<%=PageNo%>&direction=previous\"><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"2\"><b>forrige
  side </b></font></a> |<%  End If %> <%If PageNo <  oRs.PageCount Then %>| <a href =\"<%= request.servervariables(\"script_name\") %>?page=<%=PageNo%>&direction=next\"><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"2\"><b>Næste
  side</b></font></a> |<%  End If%> <br>
    <b><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"2\" color=\"#99FFFF\"><a href=\"../post.asp?type=new\">
  </a></font></b>
<%end if%>
  <hr>
    <br>
  <table width=\"80%\" border=\"0\">
    <tr>
      <td><%
if oRs.recordcount <> 0 then
oRs.AbsolutePage = PageNo
    For j = 1 to oRs.PageSize%>
        <div align=\"center\"><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\"><a href = \"<%response.write \"message.asp?entry=\" & oRs(\"code\")%>\"><%=oRs(\"topic\")%></a>
          ( <a href = \"<%response.write \"mailto:\" & oRs(\"email\")%>\"><%=oRs(\"name\")%></a>
          ) - <%=oRs(\"PostDate\")%> </font> <%
Set oRs2 = Server.CreateObject(\"ADODB.Recordset\")
oRs2.Open \"SELECT * from forum where reference = \" & oRs(\"code\"), oConn, 1,3
if oRs2.recordcount <> 0 then %>
          <table width=\"91%\" border=\"0\">
            <tr bgcolor=\"#666666\">
              <td> <% oRs2.movefirst
    while not oRs2.EOF
%>
                <div align=\"center\"><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\" color=\"#99FFFF\">
                  * * <a href = \"<%response.write \"message.asp?entry=\" & oRs2(\"code\")%>\"><%=oRs2(\"topic\")%></a>
                  ( <a href = \"<%response.write \"mailto:\" & oRs2(\"email\")%>\"><%=oRs2(\"name\")%></a>
                  ) - <%=oRs2(\"PostDate\")%> * *</font></div>
                <%
oRs2.movenext
    wend%> </td>
            </tr>
          </table>
          <%
set oRs2 = nothing
end if%> <%
response.write \"<hr>\"
    oRs.movenext
If oRs.EOF Then
Exit For
    end if
Next
set oRs = nothing
set oConn = nothing
%> </div>
      </td>
    </tr>
  </table>
    <%else%> <b><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"2\" color=\"#66FFFF\">It
    seems like there are no messages yet...would you like to be the first? <a href=\"../post.asp?type=new\">click
    here </a></font></b><% end If %>
    <hr>
    <center>
    </center>
  </div>
<div align=\"center\">
</div>
  <div align=\"center\"><br>
    <table width=\"63%\" border=\"1\" bgcolor=\"#000000\" bordercolor=\"#FFFF00\">
      <tr>
        <td width=\"50%\">
          <div align=\"center\"><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\"><a href=\"../forum.asp\">top
            af siden</a></font></div>
        </td>
        <td width=\"50%\">
          <div align=\"center\"><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\"><a href=\"../post.asp?type=new\">skriv
            ny meddelelse</a></font></div>
        </td>
      </tr>
      <tr>
        <td colspan=\"2\">
          <div align=\"center\"><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\">Dette
            forum er skrevet af&nbsp; <a href=\"mailto:admin@paragliding\">Jan
            Iversen</a>®</font></div>
        </td>
      </tr>
    </table>
    <% if InStr(1,request.servervariables(\"HTTP_USER_AGENT\"),\"MSIE\") > 7 then %><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\">du
    bruger Internet Explorer</font> <%else%>  <font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\">du
    bruger&nbsp; Netscape Navigator</font> <%end if%> </div>
</form>
<p>*</p>
<p>*</p>
<p>*</p>
<p>*</p>
<p>*</p>
<p>*</p>
</body>
</html>

Avatar billede keysersoze Guru
28. juni 2001 - 14:09 #5
oRs.PageSize = 5

skal ændres til

oRs.PageSize = 25
Avatar billede ..jan Nybegynder
28. juni 2001 - 14:13 #6
jep, det var lige hvad den skulle
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Kurser inden for grundlæggende programmering

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester