Error after Update into database from Calendar input

Suite and Optimus Suite 5
#1

Hello,

I am using Calendar for updating information from database, when I try to update it goes like this:update ticket set DATAT=‘Tue Jan 20 2015 00:00:00 GMT+0200 (EET)’ WHERE ID = ‘1092’ how I can control the data which send for update, to have the possibility to change the format or how I should config to can to the update for date type of data in MySQL.

thanks.

#2

Hello
How do you retrieve date from calendar?

#3

I use :

var dpg = new dataProcessor("${pageContext.request.contextPath}/grid/01a_sql_basic_connector.do"); //inits dataProcessor
dpg.init(contactsGrid); //associates the dataProcessor instance with the grid
dpg.attachEvent(“onAfterUpdate”, function (sid, action, tid, tag) {
if (action == “inserted”) {
contactsGrid.selectRowById(tid); //selects a row
contactForm.setFocusOnFirstActive(); //sets focus to the 1st form’s input
}
})

            contactForm.attachEvent("onButtonClick", function (id) {                     //attaches a handler function to the "onButtonClick" event
                
                contactForm.save();                                                    //sends the values of the updated row to the server
            });
#4

for input code is used:

#5

I tried this contactForm.setCalendarDateFormat(“DATAT”, “%d/%m/%y”, “%Y-%m-%d”);
but it is not working.

#6

Please, provide us completed demo on support@dhtmlx.com with a link to this topic
docs.dhtmlx.com/auxiliary_docs__ … pport.html