A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
Badass: Making Users Awesome
this week in the
JDBC and Relational Databases
Invalid Column Name
Joined: Jun 20, 2013
Jun 20, 2013 03:59:01
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.
It is sorta covered in the
JavaRanch Style Guide
subject: Invalid Column Name
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..
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015