[Phpmyadmin-devel] Zoom-search and dates
Ammar, Zoom-search of date values needs improvement. Here is an example table: CREATE TABLE IF NOT EXISTS `birthday` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `birthday` date NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; INSERT INTO `birthday` (`id`, `name`, `birthday`) VALUES (1, 'A', '1950-01-01'), (2, 'B', '1950-02-02'), (3, 'C', '1960-03-03'), (4, 'D', '2000-04-04'); Generating a plot via zoom-search show that the same time elapsed between two days (in 1950) than in ten or forty years. If you could convert these dates to a number of days (probably at the Javascript layer), the same way than in MySQL [0], you would get meaningful results. Of course you still need to display the unconverted date value. [0] http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function... -- Marc Delisle http://infomarc.info
On Tue, Aug 2, 2011 at 10:24 PM, Marc Delisle <marc@infomarc.info> wrote:
Ammar,
Zoom-search of date values needs improvement. Here is an example table:
CREATE TABLE IF NOT EXISTS `birthday` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `birthday` date NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
INSERT INTO `birthday` (`id`, `name`, `birthday`) VALUES (1, 'A', '1950-01-01'), (2, 'B', '1950-02-02'), (3, 'C', '1960-03-03'), (4, 'D', '2000-04-04');
Generating a plot via zoom-search show that the same time elapsed between two days (in 1950) than in ten or forty years.
If you could convert these dates to a number of days (probably at the Javascript layer), the same way than in MySQL [0], you would get meaningful results. Of course you still need to display the unconverted date value.
[0]
http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function...
I looked up in the reference manual and I think Highcharts will do that automatically ( calculate distance between dates) if we can convert the date into specific format, like the *dateFormat* function specified [0] will probably work. I'll need to have cases for each of the date and time types in MySQL [1] ( format to be chosen accordingly, like for datetime: '%e. %b %Y, %H:%M:%S' and for year: ' %Y ' only)
[0] http://www.highcharts.com/ref/#highcharts-object [1] http://dev.mysql.com/doc/refman/5.0/en/date-and-time-types.html --
Marc Delisle http://infomarc.info
------------------------------------------------------------------------------ BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA The must-attend event for mobile developers. Connect with experts. Get tools for creating Super Apps. See the latest technologies. Sessions, hands-on labs, demos & much more. Register early & save! http://p.sf.net/sfu/rim-blackberry-1 _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Hi, I pushed my work. What I tried was to convert each of the date into UNIX timestamp, which generated milliseconds passed since 1970-01-01 00:00:00. I used the inbuit php function to str2time() for that and while testing I found out that it does not supports dates before 1970 ( ideally it should have given negative value). I then worked around to convert date into timestamp in my javascript code. The date object in js does not support the timestamp data type from MySQL, so conversion to and from had to be done manually. I had to use the library at [0] for parsing a string to timestamp. It now provides a meaningful distance measure between dates. I lost a bit of time working around this, will work on panning feature now. [0] http://www.mattkruse.com/javascript/date/source.html On Tue, Aug 2, 2011 at 10:55 PM, Ammar Yasir <ayax88@gmail.com> wrote:
On Tue, Aug 2, 2011 at 10:24 PM, Marc Delisle <marc@infomarc.info> wrote:
Ammar,
Zoom-search of date values needs improvement. Here is an example table:
CREATE TABLE IF NOT EXISTS `birthday` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `birthday` date NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
INSERT INTO `birthday` (`id`, `name`, `birthday`) VALUES (1, 'A', '1950-01-01'), (2, 'B', '1950-02-02'), (3, 'C', '1960-03-03'), (4, 'D', '2000-04-04');
Generating a plot via zoom-search show that the same time elapsed between two days (in 1950) than in ten or forty years.
If you could convert these dates to a number of days (probably at the Javascript layer), the same way than in MySQL [0], you would get meaningful results. Of course you still need to display the unconverted date value.
[0]
http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function...
I looked up in the reference manual and I think Highcharts will do that automatically ( calculate distance between dates) if we can convert the date into specific format, like the *dateFormat* function specified [0] will probably work. I'll need to have cases for each of the date and time types in MySQL [1] ( format to be chosen accordingly, like for datetime: '%e. %b %Y, %H:%M:%S' and for year: ' %Y ' only)
[0] http://www.highcharts.com/ref/#highcharts-object [1] http://dev.mysql.com/doc/refman/5.0/en/date-and-time-types.html
--
Marc Delisle http://infomarc.info
------------------------------------------------------------------------------ BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA The must-attend event for mobile developers. Connect with experts. Get tools for creating Super Apps. See the latest technologies. Sessions, hands-on labs, demos & much more. Register early & save! http://p.sf.net/sfu/rim-blackberry-1 _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
------------------------------------------------------------------------------ BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA The must-attend event for mobile developers. Connect with experts. Get tools for creating Super Apps. See the latest technologies. Sessions, hands-on labs, demos & much more. Register early & save! http://p.sf.net/sfu/rim-blackberry-1 _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Le 2011-08-11 16:17, Ammar Yasir a écrit :
Hi,
I pushed my work. What I tried was to convert each of the date into UNIX timestamp, which generated milliseconds passed since 1970-01-01 00:00:00. I used the inbuit php function to str2time() for that and while testing I found out that it does not supports dates before 1970 ( ideally it should have given negative value). I then worked around to convert date into timestamp in my javascript code. The date object in js does not support the timestamp data type from MySQL, so conversion to and from had to be done manually. I had to use the library at [0] for parsing a string to timestamp. It now provides a meaningful distance measure between dates. I lost a bit of time working around this, will work on panning feature now.
Ammar, testing with commit 201331275bff7e3e67e3d5f3fb2bc706e302ad27, I have two problems: 1. with my test table birthday, I see no dates at all in the plot 2. Warning in ./libraries/core.lib.php#704 filemtime() [function.filemtime]: stat failed for ./js/canvg/rgbcolor.js
[0] http://www.mattkruse.com/javascript/date/source.html
On Tue, Aug 2, 2011 at 10:55 PM, Ammar Yasir <ayax88@gmail.com> wrote:
On Tue, Aug 2, 2011 at 10:24 PM, Marc Delisle <marc@infomarc.info> wrote:
Ammar,
Zoom-search of date values needs improvement. Here is an example table:
CREATE TABLE IF NOT EXISTS `birthday` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `birthday` date NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
INSERT INTO `birthday` (`id`, `name`, `birthday`) VALUES (1, 'A', '1950-01-01'), (2, 'B', '1950-02-02'), (3, 'C', '1960-03-03'), (4, 'D', '2000-04-04');
Generating a plot via zoom-search show that the same time elapsed between two days (in 1950) than in ten or forty years.
If you could convert these dates to a number of days (probably at the Javascript layer), the same way than in MySQL [0], you would get meaningful results. Of course you still need to display the unconverted date value.
[0]
http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function...
I looked up in the reference manual and I think Highcharts will do that automatically ( calculate distance between dates) if we can convert the date into specific format, like the *dateFormat* function specified [0] will probably work. I'll need to have cases for each of the date and time types in MySQL [1] ( format to be chosen accordingly, like for datetime: '%e. %b %Y, %H:%M:%S' and for year: ' %Y ' only)
[0] http://www.highcharts.com/ref/#highcharts-object [1] http://dev.mysql.com/doc/refman/5.0/en/date-and-time-types.html
--
Marc Delisle http://infomarc.info
-- Marc Delisle http://infomarc.info
On Fri, Aug 12, 2011 at 7:38 PM, Marc Delisle <marc@infomarc.info> wrote:
Le 2011-08-11 16:17, Ammar Yasir a écrit :
Hi,
I pushed my work. What I tried was to convert each of the date into UNIX timestamp, which generated milliseconds passed since 1970-01-01 00:00:00. I used the inbuit php function to str2time() for that and while testing I found out that it does not supports dates before 1970 ( ideally it should have given negative value). I then worked around to convert date into timestamp in my javascript code. The date object in js does not support the timestamp data type from MySQL, so conversion to and from had to be done manually. I had to use the library at [0] for parsing a string to timestamp. It now provides a meaningful distance measure between dates. I lost a bit of time working around this, will work on panning feature now.
Ammar, testing with commit 201331275bff7e3e67e3d5f3fb2bc706e302ad27, I have two problems:
1. with my test table birthday, I see no dates at all in the plot
I fixed it. The string format to match with date was wrong for time and date type
2. Warning in ./libraries/core.lib.php#704 filemtime() [function.filemtime]: stat failed for ./js/canvg/rgbcolor.js
I'm looking into it.
[0] http://www.mattkruse.com/javascript/date/source.html
On Tue, Aug 2, 2011 at 10:55 PM, Ammar Yasir <ayax88@gmail.com> wrote:
On Tue, Aug 2, 2011 at 10:24 PM, Marc Delisle <marc@infomarc.info>
wrote:
Ammar,
Zoom-search of date values needs improvement. Here is an example table:
CREATE TABLE IF NOT EXISTS `birthday` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `birthday` date NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
INSERT INTO `birthday` (`id`, `name`, `birthday`) VALUES (1, 'A', '1950-01-01'), (2, 'B', '1950-02-02'), (3, 'C', '1960-03-03'), (4, 'D', '2000-04-04');
Generating a plot via zoom-search show that the same time elapsed between two days (in 1950) than in ten or forty years.
If you could convert these dates to a number of days (probably at the Javascript layer), the same way than in MySQL [0], you would get meaningful results. Of course you still need to display the unconverted date value.
[0]
http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function...
I looked up in the reference manual and I think Highcharts will do that
automatically ( calculate distance between dates) if we can convert the date into specific format, like the *dateFormat* function specified [0] will probably work. I'll need to have cases for each of the date and time types in MySQL [1] ( format to be chosen accordingly, like for datetime: '%e. %b %Y, %H:%M:%S' and for year: ' %Y ' only)
[0] http://www.highcharts.com/ref/#highcharts-object [1] http://dev.mysql.com/doc/refman/5.0/en/date-and-time-types.html
--
Marc Delisle http://infomarc.info
-- Marc Delisle http://infomarc.info
------------------------------------------------------------------------------ Get a FREE DOWNLOAD! and learn more about uberSVN rich system, user administration capabilities and model configuration. Take the hassle out of deploying and managing Subversion and the tools developers use with it. http://p.sf.net/sfu/wandisco-dev2dev _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
On Fri, Aug 12, 2011 at 8:05 PM, Ammar Yasir <ammaryasir.88@gmail.com>wrote:
On Fri, Aug 12, 2011 at 7:38 PM, Marc Delisle <marc@infomarc.info> wrote:
Le 2011-08-11 16:17, Ammar Yasir a écrit :
Hi,
I pushed my work. What I tried was to convert each of the date into UNIX timestamp, which generated milliseconds passed since 1970-01-01 00:00:00. I used the inbuit php function to str2time() for that and while testing I found out that it does not supports dates before 1970 ( ideally it should have given negative value). I then worked around to convert date into timestamp in my javascript code. The date object in js does not support the timestamp data type from MySQL, so conversion to and from had to be done manually. I had to use the library at [0] for parsing a string to timestamp. It now provides a meaningful distance measure between dates. I lost a bit of time working around this, will work on panning feature now.
Ammar, testing with commit 201331275bff7e3e67e3d5f3fb2bc706e302ad27, I have two problems:
1. with my test table birthday, I see no dates at all in the plot
I fixed it. The string format to match with date was wrong for time and date type
2. Warning in ./libraries/core.lib.php#704 filemtime() [function.filemtime]: stat failed for ./js/canvg/rgbcolor.js
I'm looking into it.
The rgbcolor.js file was missing. Added now.
[0] http://www.mattkruse.com/javascript/date/source.html
On Tue, Aug 2, 2011 at 10:55 PM, Ammar Yasir <ayax88@gmail.com> wrote:
On Tue, Aug 2, 2011 at 10:24 PM, Marc Delisle <marc@infomarc.info>
wrote:
Ammar,
Zoom-search of date values needs improvement. Here is an example
table:
CREATE TABLE IF NOT EXISTS `birthday` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `birthday` date NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
INSERT INTO `birthday` (`id`, `name`, `birthday`) VALUES (1, 'A', '1950-01-01'), (2, 'B', '1950-02-02'), (3, 'C', '1960-03-03'), (4, 'D', '2000-04-04');
Generating a plot via zoom-search show that the same time elapsed between two days (in 1950) than in ten or forty years.
If you could convert these dates to a number of days (probably at the Javascript layer), the same way than in MySQL [0], you would get meaningful results. Of course you still need to display the
unconverted
date value.
[0]
http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function...
I looked up in the reference manual and I think Highcharts will do
that automatically ( calculate distance between dates) if we can convert the date into specific format, like the *dateFormat* function specified [0] will probably work. I'll need to have cases for each of the date and time types in MySQL [1] ( format to be chosen accordingly, like for datetime: '%e. %b %Y, %H:%M:%S' and for year: ' %Y ' only)
[0] http://www.highcharts.com/ref/#highcharts-object [1] http://dev.mysql.com/doc/refman/5.0/en/date-and-time-types.html
--
Marc Delisle http://infomarc.info
-- Marc Delisle http://infomarc.info
------------------------------------------------------------------------------ Get a FREE DOWNLOAD! and learn more about uberSVN rich system, user administration capabilities and model configuration. Take the hassle out of deploying and managing Subversion and the tools developers use with it. http://p.sf.net/sfu/wandisco-dev2dev _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Le 2011-08-12 13:58, Ammar Yasir a écrit :
Ammar, testing with commit 201331275bff7e3e67e3d5f3fb2bc706e302ad27, I have two problems:
1. with my test table birthday, I see no dates at all in the plot
I fixed it. The string format to match with date was wrong for time and date type
2. Warning in ./libraries/core.lib.php#704 filemtime() [function.filemtime]: stat failed for ./js/canvg/rgbcolor.js
I'm looking into it.
The rgbcolor.js file was missing. Added now.
Thanks. This feature is now merged to origin/master. -- Marc Delisle http://infomarc.info
On Sat, Aug 13, 2011 at 12:17 AM, Marc Delisle <marc@infomarc.info> wrote:
Le 2011-08-12 13:58, Ammar Yasir a écrit :
Ammar, testing with commit 201331275bff7e3e67e3d5f3fb2bc706e302ad27, I have two problems:
1. with my test table birthday, I see no dates at all in the plot
I fixed it. The string format to match with date was wrong for time and date type
2. Warning in ./libraries/core.lib.php#704 filemtime() [function.filemtime]: stat failed for ./js/canvg/rgbcolor.js
I'm looking into it.
The rgbcolor.js file was missing. Added now.
Thanks. This feature is now merged to origin/master.
Hi, How to go about the documentation for my work. I've maintained documentation for my codes, what sort of documentation should I do for the wiki page or others? Also, what more improvements or changes should I work on?
-- Marc Delisle http://infomarc.info
------------------------------------------------------------------------------ FREE DOWNLOAD - uberSVN with Social Coding for Subversion. Subversion made easy with a complete admin console. Easy to use, easy to manage, easy to install, easy to extend. Get a Free download of the new open ALM Subversion platform now. http://p.sf.net/sfu/wandisco-dev2dev _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Ammar Yasir a écrit :
On Sat, Aug 13, 2011 at 12:17 AM, Marc Delisle <marc@infomarc.info <mailto:marc@infomarc.info>> wrote:
Le 2011-08-12 13:58, Ammar Yasir a écrit :
>>> Ammar, >>> testing with commit 201331275bff7e3e67e3d5f3fb2bc706e302ad27, I have two >>> problems: >>> >>> 1. with my test table birthday, I see no dates at all in the plot >>> >>> I fixed it. The string format to match with date was wrong for time and >> date type >> >> >>> 2. Warning in ./libraries/core.lib.php#704 >>> filemtime() [function.filemtime]: stat failed for ./js/canvg/rgbcolor.js >>> >>> I'm looking into it. >> > > The rgbcolor.js file was missing. Added now.
Thanks. This feature is now merged to origin/master.
Hi, How to go about the documentation for my work. I've maintained documentation for my codes, what sort of documentation should I do for the wiki page or others?
You could add a FAQ entry in Documentation.html: section 6 is "Using phpMyAdmin". You can also have a look at section 9 but maybe 9.1 should have been place in section 6.
Also, what more improvements or changes should I work on?
Please continue to work on panning.
-- Marc Delisle http://infomarc.info
------------------------------------------------------------------------------ FREE DOWNLOAD - uberSVN with Social Coding for Subversion. Subversion made easy with a complete admin console. Easy to use, easy to manage, easy to install, easy to extend. Get a Free download of the new open ALM Subversion platform now. http://p.sf.net/sfu/wandisco-dev2dev _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net <mailto:Phpmyadmin-devel@lists.sourceforge.net> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
------------------------------------------------------------------------
------------------------------------------------------------------------------ uberSVN's rich system and user administration capabilities and model configuration take the hassle out of deploying and managing Subversion and the tools developers use with it. Learn more about uberSVN and get a free download at: http://p.sf.net/sfu/wandisco-dev2dev
------------------------------------------------------------------------
_______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
-- Marc Delisle http://infomarc.info
On Mon, Aug 15, 2011 at 10:30 PM, Marc Delisle <marc@infomarc.info> wrote:
Ammar Yasir a écrit :
On Sat, Aug 13, 2011 at 12:17 AM, Marc Delisle <marc@infomarc.info <mailto:marc@infomarc.info>> wrote:
Le 2011-08-12 13:58, Ammar Yasir a écrit :
>>> Ammar, >>> testing with commit 201331275bff7e3e67e3d5f3fb2bc706e302ad27, I have two >>> problems: >>> >>> 1. with my test table birthday, I see no dates at all in the
plot
>>> >>> I fixed it. The string format to match with date was wrong for time and >> date type >> >> >>> 2. Warning in ./libraries/core.lib.php#704 >>> filemtime() [function.filemtime]: stat failed for ./js/canvg/rgbcolor.js >>> >>> I'm looking into it. >> > > The rgbcolor.js file was missing. Added now.
Thanks. This feature is now merged to origin/master.
Hi, How to go about the documentation for my work. I've maintained documentation for my codes, what sort of documentation should I do for the wiki page or others?
You could add a FAQ entry in Documentation.html: section 6 is "Using phpMyAdmin". You can also have a look at section 9 but maybe 9.1 should have been place in section 6.
Added a FAQ in documentation (FAQ 6.32) about how to use Zoom search. Changed the display message for 'How to use?' link to include info about mousewheel zooming and panning feature. Also fixed a small typo in FAQ 6.31.
Also, what more improvements or changes should I work on?
Please continue to work on panning.
-- Marc Delisle http://infomarc.info
------------------------------------------------------------------------------
FREE DOWNLOAD - uberSVN with Social Coding for Subversion. Subversion made easy with a complete admin console. Easy to use, easy to manage, easy to install, easy to extend. Get a Free download of the new open ALM Subversion platform now. http://p.sf.net/sfu/wandisco-dev2dev _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net <mailto:Phpmyadmin-devel@lists.sourceforge.net> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
------------------------------------------------------------------------
------------------------------------------------------------------------------
uberSVN's rich system and user administration capabilities and model configuration take the hassle out of deploying and managing Subversion and the tools developers use with it. Learn more about uberSVN and get a free download at: http://p.sf.net/sfu/wandisco-dev2dev
------------------------------------------------------------------------
_______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
-- Marc Delisle http://infomarc.info
------------------------------------------------------------------------------ uberSVN's rich system and user administration capabilities and model configuration take the hassle out of deploying and managing Subversion and the tools developers use with it. Learn more about uberSVN and get a free download at: http://p.sf.net/sfu/wandisco-dev2dev _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Le 2011-08-19 20:09, Ammar Yasir a écrit :
Added a FAQ in documentation (FAQ 6.32) about how to use Zoom search. Changed the display message for 'How to use?' link to include info about mousewheel zooming and panning feature. Also fixed a small typo in FAQ 6.31.
Merged, thanks. -- Marc Delisle http://infomarc.info
On Sat, Aug 20, 2011 at 5:07 PM, Marc Delisle <marc@infomarc.info> wrote:
Le 2011-08-19 20:09, Ammar Yasir a écrit :
Added a FAQ in documentation (FAQ 6.32) about how to use Zoom search. Changed the display message for 'How to use?' link to include info about mousewheel zooming and panning feature. Also fixed a small typo in FAQ 6.31.
Merged, thanks.
Okay :) Any other work? I'll also look into the code for any further modifications/documentation.
-- Marc Delisle http://infomarc.info
------------------------------------------------------------------------------ Get a FREE DOWNLOAD! and learn more about uberSVN rich system, user administration capabilities and model configuration. Take the hassle out of deploying and managing Subversion and the tools developers use with it. http://p.sf.net/sfu/wandisco-d2d-2 _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Le 2011-08-20 07:43, Ammar Yasir a écrit :
On Sat, Aug 20, 2011 at 5:07 PM, Marc Delisle <marc@infomarc.info> wrote:
Le 2011-08-19 20:09, Ammar Yasir a écrit :
Added a FAQ in documentation (FAQ 6.32) about how to use Zoom search. Changed the display message for 'How to use?' link to include info about mousewheel zooming and panning feature. Also fixed a small typo in FAQ 6.31.
Merged, thanks.
Okay :) Any other work? I'll also look into the code for any further modifications/documentation.
You got a message from Madhura on this list: -------- Hi Ammar, 'Browse foreign values' in table search does not seem to work correctly. Although you can browser foreign values in the newly opened window, it does not enter the value being selected. Id of the field seems to cause this and I'm not sure why there are two id s (line 182/183 and 187/188 of table_select.lib.php). Could you please have a look at it. ---------- -- Marc Delisle http://infomarc.info
On Sat, Aug 20, 2011 at 5:38 PM, Marc Delisle <marc@infomarc.info> wrote:
Le 2011-08-20 07:43, Ammar Yasir a écrit :
On Sat, Aug 20, 2011 at 5:07 PM, Marc Delisle <marc@infomarc.info> wrote:
Le 2011-08-19 20:09, Ammar Yasir a écrit :
Added a FAQ in documentation (FAQ 6.32) about how to use Zoom search. Changed the display message for 'How to use?' link to include info about mousewheel zooming and panning feature. Also fixed a small typo in FAQ 6.31.
Merged, thanks.
Okay :) Any other work? I'll also look into the code for any further modifications/documentation.
You got a message from Madhura on this list: -------- Hi Ammar,
'Browse foreign values' in table search does not seem to work correctly.
Although you can browser foreign values in the newly opened window, it does not enter the value being selected. Id of the field seems to cause this and I'm not sure why there are two id s (line 182/183 and 187/188 of table_select.lib.php).
Could you please have a look at it. ----------
Fixed. A whitespace in name attribute caused it.
-- Marc Delisle http://infomarc.info
------------------------------------------------------------------------------ Get a FREE DOWNLOAD! and learn more about uberSVN rich system, user administration capabilities and model configuration. Take the hassle out of deploying and managing Subversion and the tools developers use with it. http://p.sf.net/sfu/wandisco-d2d-2 _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Le 2011-08-20 19:54, Ammar Yasir a écrit :
On Sat, Aug 20, 2011 at 5:38 PM, Marc Delisle <marc@infomarc.info> wrote:
Le 2011-08-20 07:43, Ammar Yasir a écrit :
On Sat, Aug 20, 2011 at 5:07 PM, Marc Delisle <marc@infomarc.info> wrote:
Le 2011-08-19 20:09, Ammar Yasir a écrit :
Added a FAQ in documentation (FAQ 6.32) about how to use Zoom search. Changed the display message for 'How to use?' link to include info about mousewheel zooming and panning feature. Also fixed a small typo in FAQ 6.31.
Merged, thanks.
Okay :) Any other work? I'll also look into the code for any further modifications/documentation.
You got a message from Madhura on this list: -------- Hi Ammar,
'Browse foreign values' in table search does not seem to work correctly.
Although you can browser foreign values in the newly opened window, it does not enter the value being selected. Id of the field seems to cause this and I'm not sure why there are two id s (line 182/183 and 187/188 of table_select.lib.php).
Could you please have a look at it. ----------
Fixed. A whitespace in name attribute caused it.
Ammar, you have fixed the case in the search criteria, but the bug is still present when editing a data point. -- Marc Delisle http://infomarc.info
Le 2011-08-21 07:35, Marc Delisle a écrit :
Le 2011-08-20 19:54, Ammar Yasir a écrit :
On Sat, Aug 20, 2011 at 5:38 PM, Marc Delisle <marc@infomarc.info> wrote:
Le 2011-08-20 07:43, Ammar Yasir a écrit :
On Sat, Aug 20, 2011 at 5:07 PM, Marc Delisle <marc@infomarc.info> wrote:
Le 2011-08-19 20:09, Ammar Yasir a écrit :
> Added a FAQ in documentation (FAQ 6.32) about how to use Zoom search. Changed the display message for 'How to use?' link to include info about mousewheel zooming and panning feature. Also fixed a small typo in FAQ 6.31.
Merged, thanks.
Okay :) Any other work? I'll also look into the code for any further modifications/documentation.
You got a message from Madhura on this list: -------- Hi Ammar,
'Browse foreign values' in table search does not seem to work correctly.
Although you can browser foreign values in the newly opened window, it does not enter the value being selected. Id of the field seems to cause this and I'm not sure why there are two id s (line 182/183 and 187/188 of table_select.lib.php).
Could you please have a look at it. ----------
Fixed. A whitespace in name attribute caused it.
Ammar, you have fixed the case in the search criteria, but the bug is still present when editing a data point.
Also, what I think Madhura meant is that the "browse foreign values" feature is also broken in the "Table search" panel. -- Marc Delisle http://infomarc.info
On Sun, Aug 21, 2011 at 5:09 PM, Marc Delisle <marc@infomarc.info> wrote:
Le 2011-08-21 07:35, Marc Delisle a écrit :
Le 2011-08-20 19:54, Ammar Yasir a écrit :
On Sat, Aug 20, 2011 at 5:38 PM, Marc Delisle <marc@infomarc.info> wrote:
Le 2011-08-20 07:43, Ammar Yasir a écrit :
On Sat, Aug 20, 2011 at 5:07 PM, Marc Delisle <marc@infomarc.info> wrote:
Le 2011-08-19 20:09, Ammar Yasir a écrit :
>> Added a FAQ in documentation (FAQ 6.32) about how to use Zoom search. > Changed the display message for 'How to use?' link to include info about > mousewheel zooming and panning feature. > Also fixed a small typo in FAQ 6.31.
Merged, thanks.
Okay :) Any other work? I'll also look into the code for any further modifications/documentation.
You got a message from Madhura on this list: -------- Hi Ammar,
'Browse foreign values' in table search does not seem to work correctly.
Although you can browser foreign values in the newly opened window, it does not enter the value being selected. Id of the field seems to cause this and I'm not sure why there are two id s (line 182/183 and 187/188 of table_select.lib.php).
Could you please have a look at it. ----------
Fixed. A whitespace in name attribute caused it.
Ammar, you have fixed the case in the search criteria, but the bug is still present when editing a data point.
Also, what I think Madhura meant is that the "browse foreign values" feature is also broken in the "Table search" panel.
Yes the table search and zoom search (criteria form) are fixed as they use the same form name. Now working on the edit form.
-- Marc Delisle http://infomarc.info
------------------------------------------------------------------------------ Get a FREE DOWNLOAD! and learn more about uberSVN rich system, user administration capabilities and model configuration. Take the hassle out of deploying and managing Subversion and the tools developers use with it. http://p.sf.net/sfu/wandisco-d2d-2 _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
On Sun, Aug 21, 2011 at 5:12 PM, Ammar Yasir <ammaryasir.88@gmail.com>wrote:
On Sun, Aug 21, 2011 at 5:09 PM, Marc Delisle <marc@infomarc.info> wrote:
Le 2011-08-21 07:35, Marc Delisle a écrit :
Le 2011-08-20 19:54, Ammar Yasir a écrit :
On Sat, Aug 20, 2011 at 5:38 PM, Marc Delisle <marc@infomarc.info> wrote:
Le 2011-08-20 07:43, Ammar Yasir a écrit :
On Sat, Aug 20, 2011 at 5:07 PM, Marc Delisle <marc@infomarc.info> wrote:
> Le 2011-08-19 20:09, Ammar Yasir a écrit : > >>> Added a FAQ in documentation (FAQ 6.32) about how to use Zoom search. >> Changed the display message for 'How to use?' link to include info about >> mousewheel zooming and panning feature. >> Also fixed a small typo in FAQ 6.31. > > Merged, thanks. > > Okay :) Any other work? I'll also look into the code for any further modifications/documentation.
You got a message from Madhura on this list: -------- Hi Ammar,
'Browse foreign values' in table search does not seem to work correctly.
Although you can browser foreign values in the newly opened window, it does not enter the value being selected. Id of the field seems to cause this and I'm not sure why there are two id s (line 182/183 and 187/188 of table_select.lib.php).
Could you please have a look at it. ----------
Fixed. A whitespace in name attribute caused it.
Ammar, you have fixed the case in the search criteria, but the bug is still present when editing a data point.
Hi,
For editing a data point the form that we see is actually a dialog and I can't seem to access its elements from the browse_foreigners.php script. The opener.document.displayResultForm.elements array does not contain the form elements(as it is a dialog) like in line 122/127 in browse_foreigners.php How to go about this? I'm a little stuck here.
Also, what I think Madhura meant is that the "browse foreign values" feature is also broken in the "Table search" panel.
Yes the table search and zoom search (criteria form) are fixed as they use the same form name. Now working on the edit form.
--
Marc Delisle http://infomarc.info
------------------------------------------------------------------------------ Get a FREE DOWNLOAD! and learn more about uberSVN rich system, user administration capabilities and model configuration. Take the hassle out of deploying and managing Subversion and the tools developers use with it. http://p.sf.net/sfu/wandisco-d2d-2 _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Le 2011-08-21 18:05, Ammar Yasir a écrit :
On Sun, Aug 21, 2011 at 5:12 PM, Ammar Yasir <ammaryasir.88@gmail.com>wrote:
On Sun, Aug 21, 2011 at 5:09 PM, Marc Delisle <marc@infomarc.info> wrote:
Le 2011-08-21 07:35, Marc Delisle a écrit :
Le 2011-08-20 19:54, Ammar Yasir a écrit :
On Sat, Aug 20, 2011 at 5:38 PM, Marc Delisle <marc@infomarc.info> wrote:
Le 2011-08-20 07:43, Ammar Yasir a écrit : > On Sat, Aug 20, 2011 at 5:07 PM, Marc Delisle <marc@infomarc.info> wrote: > >> Le 2011-08-19 20:09, Ammar Yasir a écrit : >> >>>> Added a FAQ in documentation (FAQ 6.32) about how to use Zoom search. >>> Changed the display message for 'How to use?' link to include info about >>> mousewheel zooming and panning feature. >>> Also fixed a small typo in FAQ 6.31. >> >> Merged, thanks. >> >> Okay :) Any other work? > I'll also look into the code for any further modifications/documentation.
You got a message from Madhura on this list: -------- Hi Ammar,
'Browse foreign values' in table search does not seem to work correctly.
Although you can browser foreign values in the newly opened window, it does not enter the value being selected. Id of the field seems to cause this and I'm not sure why there are two id s (line 182/183 and 187/188 of table_select.lib.php).
Could you please have a look at it. ----------
Fixed. A whitespace in name attribute caused it.
Ammar, you have fixed the case in the search criteria, but the bug is still present when editing a data point.
Hi,
For editing a data point the form that we see is actually a dialog and I can't seem to access its elements from the browse_foreigners.php script. The opener.document.displayResultForm.elements array does not contain the form elements(as it is a dialog) like in line 122/127 in browse_foreigners.php How to go about this? I'm a little stuck here.
Have a look at how the enum editor works; it seems to transfer values between dialogs. -- Marc Delisle http://infomarc.info
Hi Dne Fri, 12 Aug 2011 23:28:10 +0530 Ammar Yasir <ammaryasir.88@gmail.com> napsal(a):
On Fri, Aug 12, 2011 at 8:05 PM, Ammar Yasir <ammaryasir.88@gmail.com>wrote:
On Fri, Aug 12, 2011 at 7:38 PM, Marc Delisle <marc@infomarc.info> wrote:
Le 2011-08-11 16:17, Ammar Yasir a écrit : 2. Warning in ./libraries/core.lib.php#704 filemtime() [function.filemtime]: stat failed for ./js/canvg/rgbcolor.js
I'm looking into it.
The rgbcolor.js file was missing. Added now.
Not missing, but merged into canvg.js in 666732b -- Michal Čihař | http://cihar.com | http://phpmyadmin.cz
On Sat, Aug 13, 2011 at 7:53 AM, Michal Čihař <michal@cihar.com> wrote:
Hi
Dne Fri, 12 Aug 2011 23:28:10 +0530 Ammar Yasir <ammaryasir.88@gmail.com> napsal(a):
On Fri, Aug 12, 2011 at 8:05 PM, Ammar Yasir <ammaryasir.88@gmail.com>wrote:
On Fri, Aug 12, 2011 at 7:38 PM, Marc Delisle <marc@infomarc.info> wrote:
Le 2011-08-11 16:17, Ammar Yasir a écrit : 2. Warning in ./libraries/core.lib.php#704 filemtime() [function.filemtime]: stat failed for ./js/canvg/rgbcolor.js
I'm looking into it.
The rgbcolor.js file was missing. Added now.
Not missing, but merged into canvg.js in 666732b
Sorry, must have missed to remove that one.
-- Michal Čihař | http://cihar.com | http://phpmyadmin.cz
------------------------------------------------------------------------------ FREE DOWNLOAD - uberSVN with Social Coding for Subversion. Subversion made easy with a complete admin console. Easy to use, easy to manage, easy to install, easy to extend. Get a Free download of the new open ALM Subversion platform now. http://p.sf.net/sfu/wandisco-dev2dev _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
participants (5)
-
Ammar Yasir -
Ammar Yasir -
Marc Delisle -
Michal Čihař -
Tyron Madlener