Hi Michael,
Your description is not very helpful, could you provide the full error
message? The HTTP 500 error code is used for any error on the server-side.
A problem you likely have is with your database connection. Since you
are using a relative locatation (and a static include) who knows what is
going on with your DB initialization code. Additionally it looks like
you are making no effort to manage the connection. It could simply time
out and you might be getting some cached values for the things that work
and errors when you request what is not in the cache.
I seriously doubt this is an error caused by your JSP container. Try
putting all the code in one JSP, i.e. both opening and closing the
connection (and statement if needed). That should work fine. Then work
backwards until it breaks and see what you changed.
Cheers,
Jayson Falkner
[EMAIL PROTECTED]
Michael Greenberg wrote:
> Hi folks,
> Im having a very strange issue. I am running Jrun 4 (Win 2K) hitting a
> MS-SQL Server database and I am making the following query in my jsp...
>
> <%@ include file="../../dbconnection.jsp" %>
>
> <% content=request.getParameter("content");
> if(request.getParameter("id")!=null)
> id=request.getParameter("id");
> if(request.getParameter("content")==null){
> String query="SELECT pageText FROM tblPageContent WHERE
> pageKey=304";
> ResultSet rs=statement.executeQuery(query);
> rs.next();
> content=rs.getString(1);
> }
> //update the table
> String query="UPDATE tblPageContent SET pageText=\'"+content+"\' WHERE
> pageKey=304";
> statement.executeUpdate(query);
>
> %>
>
> <%=content%>
>
> This particular page isnt working, but if I use this same code to query
> another field in the database it's ok. When I go into the SQL Enterprise
> Manager and query the field in question everything is ok. It's just very
> sporadic where when I query some fields through my jsps it works on certain
> ones only...Im very confused here.
>
> I get the following error when I am querying the field in question:
>
> 500 Unhandled exception thrown from
> /products/investments/investments_overview_updatedatabase.jsp:20
>
> If anyone has any clues please let me know...Im under a deadline as usual.
>
> Thanks,
> Michael
>
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
