Register / Login
JDBC and Relational Databases
Invalid Column Name
posted 2 years ago
Am new to
, but basically have copied an existing JSP and added by own SQL query and changed columns names etc to match.
However my query extracts the information contained within a few xml nodes and works fine in oracle, however when in the JSP I get an invalid column name.
The JSP is fine when I amend the query within it and remove the the XML parts of it.
Is it possible to have SQL selects such as the below
" substr(M.xml, instr(M.XML, '<Description enabled="1">') + 25, instr(M.xml, '</Description>') - (instr(M.XML, '<Description enabled="1">') + 25)) DEPTNAME, "
Is the below get
<TD align="right"> <%=rs.getString("DEPTNAME")%></TD>
Hope that makes sense, as I said am a rank amatuer when it comes to JSP.
Query calls terminating without error... just ending-
Pagination using display tag and JSTL.Display problem
Displaying the right details of a resource taken from a JSP results page
Hibernate native sql problem
Unable to insert foreign key values..