A very neat method hidden in the depths of ColdFusion that will delete a row from a ColdFusion query queryNew() in one, very simple line of code.

This neat little mySQL function will tell mySQL to return your recordset in a list order specified by you. So, for example, you can order by in (2,1,4,3,5).

A very simple way to return your Oracle results randomly.

Those familiar with MySQL and PostgreSQL will know about the LIMIT clause these database's have. For those not in the know, the LIMIT clause will limit your resultset to a specific number. Here is the way to perform a similar action in Oracle.

Sometimes an Oracle action cannot be performed due to a user session still being active. To perform the action you will need to kill this session, here is how it is done.

Not only is memcached readily available for Linux/UNIX, but you can also get a pre-compiled version for Microsoft Windows Server.