Arbitrary SQL order by

Posted on October 4th, 2008. Filed under: SQL Tags: ,

Consider the following scenario: the business analyst of your company sends you a business requirement in which the text results of a given query must be ordered arbitrarily according to the specifics of that business requirement. For example: Us should precede Cs, which should precede Uns, which should precede Bs, which should precede everything else. It can be very costly to resort to manipulations of the result set after the query has been executed, while a stored procedure is not very portable. You can make the query itself return the results in the arbitrary order you wish by modifying the select statement in such a way that your arbitrary order will output a number (or any other orderable output) that can be used as an order by condition.

Introducing wxMatisse

Posted on May 25th, 2008. Filed under: C++,Java Tags: , ,

Towards the end of a previous post I’ve exposed my thought of a wxWidgets plugin for NetBeans, more specifically, a plugin for C++ wxWidgets. If you have followed the tutorial through, you’ve probably realized how difficult it is to set up wxWidgets to be used on Windows using NetBeans. Even after the environment is completely configured, you still lack the power of tools like Matisse to prototype your frames. For now, a simple tool will address this problem: it’s called wxMatisse. wxMatisse is a tool that uses windows created by Matisse to create equivalent windows in C++ wxWidgets.