DaniWeb Forum Index > Web Development > JSP

checking to see if a coupon has expired

Please support our JSP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Mar 2004

Posts: 7

Reputation: Dave G. is an unknown quantity at this point

Solved Threads: 0

Dave G.

Offline

Newbie Poster

checking to see if a coupon has expired

Oct 15th, 2004

Hello,

I am trying to set up my website to be able to accept coupons. I am working in JSP and want to be able to get the current date and compare it to the date stored in the database. I have a field in the coupon table named 'Expiry' which is of type 'date'.

So far I have been able to retrieve the date from the database

 Help with Code Tags 
 JSP Syntax (Toggle Plain Text) 
...
out.print(rs.getDate("Expiry"));
}
...
out.print(rs.getDate("Expiry"));
}

and have printed it successfully

I am trying to do the following:

 Help with Code Tags 
 JSP Syntax (Toggle Plain Text) 
if(rs.getDate("Expiry") != null && rs.getDate("Expiry") < today){<blockquote>set coupon to invalid</blockquote>}
if(rs.getDate("Expiry") != null && rs.getDate("Expiry") < today){<blockquote>set coupon to invalid</blockquote>}

I have tried setting 'today' up as a Date object:

 Help with Code Tags 
 JSP Syntax (Toggle Plain Text) 
<%@page language="java" import="java.sql.Date"%>
...
Date today = new Date();
<%@page language="java" import="java.sql.Date"%>
...
Date today = new Date();

but it says that it cannot resolve symbol and points at 'new'

I have also tried setting 'today' up as a Calendar object, but can not figure out how to make that work either.

Any help would be most appreciated as the company is planning on handing out coupons in just over a week!

Thanks in advance,
Dave.

•