JSP error

[Rashmi Trivedi]

Hi all
When i try to load this page i am getting following error message.
-Generated servlet error:
-Syntax error on tokens, delete these tokens

I strated getting this error messaage as i added dCurrentDate variable in SQL statement.

dCurrentDate is java.sql.Date variable and access database is also set to date/time datatype.

can somebody help me please as to what am i doing wrong here..

thanks and regards..

Rashmi Trivedi

<%
 
      Vector theList = new Vector();
String sPrjId = null;
int sId = 0;
String sName = null;
//java.sql.Date sStartDate = null;
//java.sql.Date sEndDate = null;
String sStartDate = null;
String sEndDate = null;
String sDuration = null;
String sResource = null;
String sComplete = null;
String sPhase = null;
String sStatus = null;
java.sql.Date dCurrentSqlDate;
java.util.Date dCurrentUtilDate;
String sCurrentDate = null;
 
  ResultSet rs = null;
int iRetrieveRows = 0;
int irs =0;
ResultSet rsiCount = null;
 
%>
 
<%

        db.connect();
 
session = request.getSession(true);
String sUserID = (String)session.getAttribute("userid");
 

GregorianCalendar myDate = new GregorianCalendar();
int year=myDate.get(Calendar.YEAR);
int month=myDate.get(Calendar.MONTH);
     int MonthOut = month + 1;  
 
    int day=myDate.get(Calendar.DAY_OF_MONTH);
    
      sCurrentDate = year + "-" + MonthOut + "-" + day;
 
dCurrentDate = java.sql.Date.valueOf(sCurrentDate);

 try {
 rs=db.execSQL("SELECT * FROM TBL_TASK WHERE TSK_ENDDATE  <= '"+#dCurrentDate#+"' AND TSK_STATUS <> 'COMPLETED' AND TSK_RESOURCE ='"+sUserID+"'");
 
  boolean more = rs.next();
          if(more) {
     
%>
 

 

 

 

 

 

    

[Bear Bibeault]

Doing SQL in a JSP? Tsk tsk.

In any case, this is a JDBC issue, not a JSP issue. So this topic has been moved.

[Tim LeMaster]

I see a couple of problems

dCurrentDate doesn't seem to be defined anywhere.

WHERE TSK_ENDDATE  <= '"+#dCurrentDate#+"'

Whats with the # around dCurrentDate?

This is neither a JSP issue nor a JDBC issue.

Eventually you will want to start breaking down your code into reuseable pieces - keep learning!
[ December 07, 2006: Message edited by: Tim LeMaster ]