Strange mysql sorting behaviour with enums
Posted by Erik Bauffman in default on September 23, 2010
If you have an ENUM(‘Y’,'N’) field and you want to sort ASC on this field, mysql will show the Y values before the N values. It seems this is based on the order you defined them when creating your table… See the screenshot.
I’d like to add the explanation from mysql.com which can be found here.
ENUM values are sorted according to the order in which the enumeration members were listed in the column specification. (In other words, ENUM values are sorted according to their index numbers.) For example, ‘a’ sorts before ‘b’ for ENUM(‘a’, ‘b’), but ‘b’ sorts before ‘a’ for ENUM(‘b’, ‘a’). The empty string sorts before nonempty strings, and NULL values sort before all other enumeration values. To prevent unexpected results, specify the ENUM list in alphabetic order.
Midas, hoofdpijn zonder zorgen
Posted by Erik Bauffman in default on July 27, 2010
Aan die klootzakken die een camion uitlaten moesten lossen om 03u45 vannacht bij Midas (aan de achterkant van mijn appartement):
Vraag de code van het alarm zodat je de hele buurt niet moet wakkermaken. Dank bij voorbaat!
Jquery focus on first visual input element
Posted by Erik Bauffman in default on July 23, 2010
I wanted the first visual form element, not having the noFocus class, get the focus when the page loads
$(‘form input:visible:not(.noFocus):first’).focus();
I love jquery!
Sennheiser in-ears
Posted by Erik Bauffman in default on July 22, 2010
Sinds ik de Sennheiser cx400-II oordopjes heb, ben ik een gelukkige mens. Zelfs op standje 2 van mijn volume hoor ik niets meer van achtergrond geluid. De prijs van om en bij de 70 euro is natuurlijk wel andere koek.
Spoon Library – Form example
Posted by Erik Bauffman in default on May 24, 2010
Check out the form example.
Spoon Library v1.2 released
Posted by Erik Bauffman in default on May 20, 2010
A few days ago I released v1.2 for Spoon Library. Quite a few changes for this release.
Setting your timezone in mysql
Posted by Erik Bauffman in default on February 8, 2010
If you want to set your timezone in mysql for your database connection, do this.
SET time_zone = ‘+2:00′;
Keep in mind that the number should be correct and can also have a minus sign, based on the timezone you want to set ofcourse. Do watch out for the UTC timezone, because mysql requires the +.
SET time_zone = ‘+0:00′;
Only 1 person writing PHP shizzle.
Posted by Erik Bauffman in default on January 24, 2010
If I may believe my Google Reader, there’s only a handful of people that’s actually writing something decent about PHP. And as you might expect a shitload of websites tends to refer to that one persons’ posts, clouding my RSS feed with a bunch of nonsense. I love sundays.
Type hinting for objects
Posted by Erik Bauffman in default on January 20, 2010
In Spoon I fetch my form elements in this way that it’s impossible for the library to provide the correct type hinting. You can fix this yourself by doing:
/* @var $txtEmail SpoonTextField */
$txtEmail = $this->frm->getField(‘email’);
PHP Programming with E_STRICT beware!
Posted by Erik Bauffman in default on October 16, 2009
I recently switched to programming PHP with error_reporting set to E_STRICT, since I want to know what’s going on. You have to watch out when extending classes and trying to overrule the parameters of the child method. An example:
When executing you will get the following error “Strict Standards: Declaration of B::test() should be compatible with that of A::test() in /path/to/file/test.php on line 18”
When I remove the parameter ‘value’ from the method ‘test’ in the class ‘B’, everything’s fine. Write that down.