How to use criteria.addLessOrEqualThan(colname,date)

[Mike Young]

Hi,
I am trying to write a query to find all records from a table that have an
expiry date of less than or equal to todays date.

e.g. select col1,col2 from orders where expires <= "2003-06-23"

if I use ....

----- snip -----
  long currentTime = System.currentTimeMillis(); java.sql.Date
  sysdate = new java.sql.Date(currentTime-(currentTime % 86400000));

  try{
     // Build up criteria to query orders
     criteria.addLessOrEqualThan("expires",sysdate);

----- snip -----

then as soon as the criteria.addLessOrEqualThan line is run I get

        Unhandled Exception thrown: class java.lang.NullPointerException

anybody got any suggestions please?


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]