sql date

[Aneresia White]

I want to get the day, month and year from combo boxes and making an update in my database after this date. I tried something like this:

   
stmt1.executeUpdate("update carti set nr_car_stoc=nr_car_stoc-(select  nr_exemplare_v from vanzare where"+
 "datav='"+((String)can.getSelectedItem())+"-"+((String)cluna.getSelectedItem())+"-"+((String)czi.getSelectedItem())+"') where cod_carte="+tfcodcarter.getText());
 

can is the combo box for year, czi for day and cluna for month.
It doesn't work like this, I receive an error. I think it should be something else instead of (String).

[Jeanne Boyarsky]

Originally posted by Aneresia White:
I receive an error.

What was the error? Sharing this information will make you more likely to get a useful reply.

[Jaya Latha]

Hi,Iam Jaya.The problem you mentioned is not the reason why the code is failing.Type casting is possible.They are convertible types.There may be some other reason for the failure.Please give more details.

[Aneresia White]

So this is the error:

    
java.sql.SQLSyntaxErrorException: Syntax error: Encountered "=" at line 1, column 89.
        at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source)
        at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
        at org.apache.derby.client.am.Statement.executeUpdate(Unknown Source)

but the syntax is ok I already verify it in sql. if I put (Date) instead of (String) I don't get any errors but the update is not working when I look in the database.

[Rene Larsen]

You need a space between 'where' and 'datav' - and replace the last 'where' with an 'and'.

Normally you will have saved the date as a DATE or TIMESTAMP field in the database, and in Java you will pass the argument to the Statement as a java.sql.Date
[ December 31, 2008: Message edited by: Rene Larsen ]

[Aneresia White]

You were right about the space between those 2 ) How could I missed that. That's funny. But the last where it's ok, it's what I need it. Thank you.