Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <c:set var="time_req1" value="<=${time_req_date}>"/>
- <c:set var="time_req2" value="<=${time_req_date2}>"/>
- <sql:query var="sqlresult" sql="select * FROM FORM_REDUCVU WHERE
- to_date(TIME_REQ,'mm/dd/yyyy') >= ? AND to_date(TIME_REQ,'mm/dd/yyyy')
- <= ? ORDER BY ID DESC" maxRows="25" dataSource="jdbc/myoracledev">
- <sql:param value="1110484" ></sql:param>
- </sql:query>
- 18-Feb-2019 11:57:32.502 SEVERE [http-nio-20000-exec-6]
- org.apache.catalina.core.StandardWrapperValve.invoke Servlet.service()
- for servlet [jsp] in context with path [/useragent] threw exception
- [javax.servlet.ServletException: javax.servlet.jsp.JspException: select
- * FROM FORM_REDUCVU WHERE to_date(TIME_REQ,'mm/dd/yyyy') >= ? AND
- to_date(TIME_REQ,'mm/dd/yyyy') <= ? ORDER BY ID DESC: Missing IN or
- OUT parameter at index:: 2] with root cause
- java.sql.SQLException: Missing IN or OUT parameter at index:: 2
Add Comment
Please, Sign In to add comment