Hi!
I am using DBForms 2.6 and Tomcat 5.0, and I have a problem when update a form with datefield.
It is a nested form and there is a datetime field in the parent form. Functions of update, insert and delete are available in both forms. Parent form shows one record while the subform shows many records.
When I display the datetime field using dateLabel, all functions perform correctly on both subform and parent form.
But if I replace the dateLabel field by dateField or textField, neither update nor insert works on the parent form. (The subform still works)
textField setting:
<db:textField fieldName="REC_UPD_DT" size="28" defaultValue="<%=formattedDate%>" pattern="yyyy-MM-dd (E) HH:mm:ss.SSS" styleClass="clsInputStyle" />
dateField setting:
<db:dateField fieldName="REC_UPD_DT" pattern="yyyy-MM-dd (E) HH:mm:ss.SSS" styleClass="clsInputStyle" size="28" overrideValue="<%=formattedDate%>" useJsCalendar="true"/>
What I want to do is to display the current datetime to the user, and whenever the user update /insert the form, the current datetime is updated to the database.
formattedDate is set as follows:
<%
DateFormat sdf = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss.SSS");
Date currentDate = new Date();
String formattedDate = sdf.format(currentDate);
%>
DateFormat sdf = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss.SSS");
Date currentDate = new Date();
String formattedDate = sdf.format(currentDate);
%>
The current time is displayed correctly on the jsp, but when i clicked update / insert, it is directed to another record, and no update / insert is done.
Did I set something wrong? Or is there something missing?
THANKS A LOT :)
Karen
------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________ DbForms Mailing List
http://www.wap-force.net/dbforms
