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
