If you're using IE5 - it brings up 'friendly HTTP error messages' which
aren't really friendly at all - just annoying.
You can turn them off in the advanced internet options - giving you the
proper error message that Orion generates.
Might help.
Mike
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of RafaelDe Los
> Rios
> Sent: Tuesday, March 28, 2000 7:29 AM
> To: Orion-Interest
> Subject: HTTP 500 error
>
>
> I have created a JSP which queries an access database.
> Unfortunately, an
> error comes up when the JSP is running. This error comes up
> in the browser
> and says something like this: HTTP 500 Intenale Service Error.
> I don't really know what's the problem. I hope somebody can help me.
> Because of that, I'm right now stuck.
>
> Please don't hesitate to contact me.
> Thank you
> Rafael
>
> Here is the JSP:
>
> <html>
> <head>
> <title>Searching.....</title>
> </head>
> <body bgcolor="white">
> <%@ page language="java" import="java.sql.*", import="java.util.*",
> import="java.io.*" %>
> <jsp:useBean id="DbBean" scope="session" class="sessions.DBinquire" />
> <%! String search; %>
> <%! String search_1; %>
> <%! String[] data; %>
> <%! String result_data; %>
> <%! int column_count; %>
> <center>
> <h2> Searching Result </h2>
> <table width=80% bgcolor=lightblue border=1>
> <%
> String input = null;
> String search_content = " from JVSApp";
> search = "SELECT * ";
> search_1 = "SELECT ";
> search = search + search_content;
> DbBean.query(search);
> column_count = DbBean.colCount();
> data = DbBean.retrieveColumn();
> if (column_count > 0)
>
> %>
> <tr>
> <%
> for(int i=0; i<column_count; i++)
> {
> if (i < column_count - 1)
>
> search_1 = search_1 + data[i] + ",";
> }
> else
> search_1 = search_1 + data[i] +
> search_content;
> System.out.println(search_1);
> %>
> <th>
> <%=data[i] %>
> </th>
> <%
> }
> %>
> </tr>
> <%
> while(DbBean.nextdata())
> {
> %>
> <tr>
> <%
> for(int i=0; i<column_count; i++)
> {
> result_data=DbBean.getdata(data[i]);
> %>
> <td>
> <%=result_data %>
> </td>
> <%
> }
> %>
> </tr>
> <%
> }
> }
> %>
> <font color=blue>
> <h5>SQL STATEMENT: <%=search_1 %><h5>
> </font>
> </table>
> </center>
> </body>
> </html>
>
>
>
>
>
