hi
sorry for going jsp to datbase
i am using access at present
"SELECT * from publish where date() <= LdSubmit order by refno;"
this query work fine when i execute it into query mode but when i paste into
my jsp it give error saiyng
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]Invalid
character value for cast spe
cification on column number 1 (userid)
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Compiled Code)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:4246)
at sun.jdbc.odbc.JdbcOdbc.SQLGetDataInteger(Compiled Code)
at sun.jdbc.odbc.JdbcOdbcResultSet.getDataInteger(Compiled Code)
at sun.jdbc.odbc.JdbcOdbcResultSet.getInt(Compiled Code)
at
C_0003a.jswdk_0002d_00031_0005f_00030_0005f_00031.examples.jsp.tender.jsp_00
05ctender_000
5cLiveTenders_0002ejspLiveTenders_jsp_3._jspService(Compiled Code)
at com.sun.jsp.runtime.HttpJspBase.service(Compiled Code)
at javax.servlet.http.HttpServlet.service(Compiled Code)
at com.sun.jsp.runtime.JspServlet$JspServletWrapper.service(Compiled
Code)
at com.sun.jsp.runtime.JspServlet.serviceJspFile(Compiled Code)
at com.sun.jsp.runtime.JspServlet.service(Compiled Code)
at javax.servlet.http.HttpServlet.service(Compiled Code)
at com.sun.web.core.ServletWrapper.handleRequest(Compiled Code)
at com.sun.web.core.Context.handleRequest(Compiled Code)
at com.sun.web.server.ConnectionHandler.run(Compiled Code)
what can be the probem ?
how to get all record that are having LdSubmit value as biger date then
current date in a effisiant way.
(problem LdSubmit culom is as date in table
how to get current date that we can use to compare with LdSubmit column
)
looking for positive reponse
for them
thanks in advance
shailendra
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
