Monthly Archives: May 2017

Сalculation of the conformational potential energy surfaces of a molecular system using Hypercube Hyperchem and Microsoft Excel.

| May 17, 2017 | Updated: March 14, 2020

This is a post about my graduation thesis at the University. For now it seems simple and maybe not quite appropriate for such specialty as a physicist, but every measurement needs a scale. For an average student at those times and place it was a decent work and also these results were actually demanded by […]

Converting jqGrid filtering and sorting options to MySQL statements using Perl. And processing them.

| May 1, 2017 | Updated: March 14, 2020

Here I will describe a pattern that I used for a couple of years to pass filtering and sorting options from jqGrid to MySQL server.
JqGrig that is used here is simple. What I actually want to share is my two Perl subroutines – get_searchstring() and _get_filterops that allows to translate almost any filtering request from jqGrid to MySQL.
I can’t guarantee anything, you know, but these subroutines worked well for several years and didn’t manifest any glitches.