Posted Wednesday, December 31, 1969 @ 23:59:59  

I am trying to modify a date column in MYSQL which is completely fine
through
the applet, the value can be changed in the display windows only. The
only
problem is that when you check the database or hit the refresh button
on the
applet display, the original value is redisplayed.

I can easily change the value in PHP-MyAdmin for MYSQL, but not via the
applet. Everything else works fine.

I would appreciate any help you could give on this as it is a show
stopper at
present.

Thanks,

Posted Wednesday, December 31, 1969 @ 23:59:59  

I now have some debug feedback. It looks as if dbtable thinks the field is updated but it isn't when it looks at the field values afterwards:

Data updated: oldvalue: null new value: 05/01/2003
Executing sql update orders set orders_ref=?,orders_name=?,orders_date=?,orders_payment=?,orders_paid=?, orders_items=?, orders_total=? where orders_id=? with arguments:
Argument 1: Datatype in database:NUMERIC. Datatype of cell data: java.lang.Integer. Value:10000
Argument 2: Datatype in database:VARCHAR. Datatype of cell data: java.lang.String. Value:yo boiy
Argument 3: Datatype in database:DATE. Value:NULL
Argument 4: Datatype in database:VARCHAR. Datatype of cell data: java.lang.String. Value:V
Argument 5: Datatype in database:CHAR. Datatype of cell data: java.lang.String. Value:Y
Argument 6: Datatype in database:NUMERIC. Datatype of cell data: java.lang.Integer. Value:7
Argument 7: Datatype in database:NUMERIC. Datatype of cell data: java.math.BigDecimal. Value:115.00
Argument 8: Datatype in database:NUMERIC. Datatype of cell data: java.lang.Integer. Value:1

Thanks,

Posted Wednesday, December 31, 1969 @ 23:59:59  

c.setDataMap(new DateStringMap());

Can you try removing the above line and rerun the program.