On Wed, 2011-07-06 at 14:57 +0100, Rouslan Placella wrote:
On Wed, 2011-07-06 at 09:48 -0400, Marc Delisle wrote:
Thilanka, There is a problem with this feature: when the table has a DATETIME column, the picker icon does not show up.
Have a look at [0] where Rouslan explains that he fixed a similar problem in his repository.
[0] https://sourceforge.net/tracker/index.php?func=detail&aid=3354360&gr...
The problem there is that the datepickers/timepickers are attached to all relevant fields on page-load by functions.js, however in AJAX mode the fields are created after page-load and the pickers are not attached, so it's necessary to bind them manually after showing the dialog to the user. My code for this looks like this (the snipped is simplified for clarity):
---SNIP--- /**
- Display the dialog to the user
*/ RTE.$ajaxDialog = $('<div>' + data.message + '</div>').dialog(options); RTE.$ajaxDialog.find('.datefield, .datetimefield').each(function () { PMA_addDatepicker($(this)); }); ---SNIP---
Rouslan
Just saw another relevant thing. The qTips have to also be bound manually in AJAX dialogs, right now in your "database structure->insert" dialog the footnotes are used (which are meant for when JS is disabled). Look for sample code in functions.js for how to bind the tooltips.
Another thing that you might want to keep in mind is that after using the "continue insertion with X rows", the pickers have to be properly rebound to date/time fields. Not sure how helpful it'll be, but you might want to look at this patch (and other nearby code in that source code file): https://sourceforge.net/tracker/?func=detail&aid=3261058&group_id=23...
Rouslan