try it:
from -->FROM where-->WHERE
----- Original Message -----
From: "Shailendra" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 21, 2001 6:26 AM
Subject: query problem
> 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
>
===========================================================================
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
