error 'ASP 0115' 
Author Message
 error 'ASP 0115'

error 'ASP 0115'
Unexpected error

/helplah/ViewQuestionByCatPage.asp

A trappable error occurred in an external object. The script cannot
continue running.

I am getting this error frequently... Anyone know the solution? I really
cannot solve it myself :(

Who encounter this before....?
I really need a hand here... any help is greatly appreciated...
Thanks in advance.

Regards
Kok ming



Wed, 14 Jan 2004 03:55:16 GMT  
 error 'ASP 0115'
http://www.aspfaq.com/faq/faqShow.asp?fid=8


Quote:
> error 'ASP 0115'
> Unexpected error

> /helplah/ViewQuestionByCatPage.asp

> A trappable error occurred in an external object. The script cannot
> continue running.

> I am getting this error frequently... Anyone know the solution? I really
> cannot solve it myself :(

> Who encounter this before....?
> I really need a hand here... any help is greatly appreciated...
> Thanks in advance.

> Regards
> Kok ming



Wed, 14 Jan 2004 05:21:15 GMT  
 error 'ASP 0115'
Thanks Aaron,
   But I have another problem. It is because I am not running IIS. I am only
using Micorsoft Personal Web Server and I have try to fix the problem by
replacing the latest version of ASP.DLL... it still cannot solve the problem.
So.. anyway else to solve this problem? Thanks.

Sincerely
Kok ming

Quote:

> http://www.aspfaq.com/faq/faqShow.asp?fid=8



> > error 'ASP 0115'
> > Unexpected error

> > /helplah/ViewQuestionByCatPage.asp

> > A trappable error occurred in an external object. The script cannot
> > continue running.

> > I am getting this error frequently... Anyone know the solution? I really
> > cannot solve it myself :(

> > Who encounter this before....?
> > I really need a hand here... any help is greatly appreciated...
> > Thanks in advance.

> > Regards
> > Kok ming



Wed, 14 Jan 2004 10:07:05 GMT  
 error 'ASP 0115'
here will my coding for the file which is making error.... please have a look


<% option explicit %>
<!-- #include file="UserDb.inc" -->

<%

  Dim rCd, perPage, calSQL, dS,er, rs, counter, totalrecords, pagecount,
currentpage
  Dim x, startrecord

  rCd = request.querystring("CatId")
  If rCd = "" Then
    rCd = 0
    End If
          ' tell me how many records you want per page
           perPage = 15

           ' set up a query to get the count, and another to get the data
           calSQL = "SELECT count(QId) FROM Question Where CategoryId = "& rCd
&";"
           dS= "SELECT QId, Qtitle, DatePost, ClosingDate, CategoryId FROM
Question Where Question.CategoryId = "& rCd &" Order By DatePost desc, QId desc;"

           ' start getting the data, first we need to know the count
           ' this will tell us how many pages there will be
           set er = HelplahDB.execute(calSQL)
           counter = clng(er(0))
           er.close: set er = nothing

           ' determine if anything is returned. If there are records,
           ' figure out the pagecount and the total number of records.
           if counter < 1 then
               Response.Write "No records found."
               Response.End
           else
               if counter = 1 then perpage = 1
               totalRecords = counter
               pageCount = clng(counter/perpage)
               if counter/perPage > pageCount then
                   pageCount = pageCount + 1
               end if
           end if

           ' get the page requested from the querystring, if there is none,
           ' move to the first page
           currentpage = clng(request.querystring("page"))
           if currentpage <= 1 then
               currentpage = 1
           elseif currentpage > pageCount then
               currentpage = pagecount
           end if

           ' set up the first record to move to, if applicable
           if pageCount > 1 then
           startrecord = (clng(currentpage-1) * perPage) + 1
           end if

            ' let's get the data, move to the first record if necessary
            ' loop through, returning records until we meet perpage or EOF
         %>
      <table border="1" cellpadding="0" cellspacing="0" style="border-collapse:
collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
 <tr>
  <td width="11%">Question ID</td>
  <td width="62%">Question Title</td>
   <td width="13%">Date of posting</td>
     <td width="14%">Closing date</td>
  </tr>
  <%
           set rs = HelplahDB.execute(dS)
           if counter > perpage then rs.move(startrecord)
           for x = 1 to perpage
             if (rs.eof)then exit for
        %>
     <tr>
    <td width="11%"><%= rs("QId") %> &nbsp;</td>
  <td width="62%"><a href='ViewFullQuestion.asp?QId=<%= rs("QId") %>'><%=
rs("QTitle") %>&nbsp; </a></td>
        <td width="13%"><%= rs("DatePost") %>&nbsp;</td>
        <td width="14%"><% If rs("ClosingDate") <> "" Then %> <%=
rs("ClosingDate") %>&nbsp;<% Else %> - <% End If %></td>
   </tr>
   <%
               ' response.write rs(0) & " - " & rs(1) & "<p>"
                  rs.movenext
           next

     response.write "</table>"

           ' let's be nice and show a list of pages the user can jump to
           if counter > 1 and pageCount > 1 then
               Response.Write "Page: "
               for x = 1 to pagecount
                   if x = currentpage then
                       Response.Write "<b>" & x & "</b> "
                   else
                       Response.Write "<a href='ViewQuestionByCatPage.asp?CatId="

                        Response.Write rCd
                       response.write "&amp;page="
                       Response.Write x & "'>" & x & "</a> "
                   end if
               next
           end if

           ' okay, time to clean up after the party
           rs.close: set rs = nothing
           HelplahDB.close: set HelplahDB = nothing
       %>

Quote:

> Thanks Aaron,
>    But I have another problem. It is because I am not running IIS. I am only
> using Micorsoft Personal Web Server and I have try to fix the problem by
> replacing the latest version of ASP.DLL... it still cannot solve the problem.
> So.. anyway else to solve this problem? Thanks.

> Sincerely
> Kok ming


> > http://www.aspfaq.com/faq/faqShow.asp?fid=8



> > > error 'ASP 0115'
> > > Unexpected error

> > > /helplah/ViewQuestionByCatPage.asp

> > > A trappable error occurred in an external object. The script cannot
> > > continue running.

> > > I am getting this error frequently... Anyone know the solution? I really
> > > cannot solve it myself :(

> > > Who encounter this before....?
> > > I really need a hand here... any help is greatly appreciated...
> > > Thanks in advance.

> > > Regards
> > > Kok ming



Thu, 15 Jan 2004 02:14:02 GMT  
 
 [ 4 post ] 

 Relevant Pages 

1. Anyone know how to use mapi32.dll?

2. error 'ASP 0115' Unexpected error

3. dbiDoRestructure

4. ReportSmith printed output 'black'

5. ***US-NC-Raleigh/RTP-Delphi Developers, v.1.0, 2.0***

6. 'ASP 0115 : 8000ffff'

7. 'ASP 0115 : 8000ffff'

8. asp 0115 error

9. ActiveX DLL & ASP 0115 error

10. ASP 0115 Error

11. ASP 0115 Trappable Error

12. ASP 0115 error?

 

 
Powered by phpBB® Forum Software