|
Azzur
Starting Member
13 Posts |
 Posted - 23 October 2003 : 10:51:41
|
Hi, I am trying to systematize the mod LINK to make to work him/it with the database sql.
I/you/they have succeeded in making to work different parts of the mod but I find some problem with the page of the search, in fact when insrerisco a term the page underlines me this error:
Type of error:
ADODB.Recordset (0x800A0CB3)
Il set di record corrente non supporta i segnalibri. Potrebbe trattarsi di una limitazione del provider o del tipo di cursore selezionato.
/forum/links_search.asp,
this is the piece of code where the error is signalled me:
<%
if show = "10" then
strSQL = "select * from links where Keyword like'%" & search & "%' or Description like '%" & search & "%' order by link_ID"
'build string for connection my database file is link.mdb in store in the same folder of this file.
Dim iPageSize
Dim iPageCount
Dim iPageCurrent
Dim strOrderBy
Dim strSQL
Dim objPagingConn
Dim objPagingRS
Dim iRecordsShown
Dim I
iPageSize = 10
'set page size
If Request.QueryString("page") = "" Then
iPageCurrent = 1
Else
iPageCurrent = CInt(Request.QueryString("page"))
End If
If Request.QueryString("order") = "" Then
strOrderBy = "link_id"
Else
strOrderBy = Request.QueryString("order")
End If
Set objPagingRS = Server.CreateObject("ADODB.Recordset")
objPagingRS.PageSize = iPageSize
objPagingRS.CacheSize = iPageSize
objPagingRS.Open strSQL, my_Conn, adOpenStatic, adLockReadOnly, adCmdText
reccount = objPagingRS.recordcount
iPageCount = objPagingRS.PageCount
If iPageCurrent > iPageCount Then iPageCurrent = iPageCount
If iPageCurrent < 1 Then iPageCurrent = 1
If iPageCount = 0 Then
Response.Write "<tr><center><td width=100% colspan=2 align=center><font face=Verdana color=red size=2><b><br><br>nulla č stato trovato</b></font><br><br><font face=Verdana size=1><a href=media.asp>Effettua nuova ricerca</a></center></font></td></tr></table><br>"
Else
##########This is The Incriminated Line ######objPagingRS.AbsolutePage = iPageCurrent
%>
The error that is pointed out me by Ie is to the line that I have pointed out Here you Above With The ######
From thing can depend the error?? I don't succeed in understanding!! |
|
Topic Locked
