I have written something on age calculation in MS SQL server before, but this information seemed to be incorrect. E.g. the query

select datediff(year, '2005-10-10', '2006-4-8');

returns 1, which is not what you want when you want to calculate someones age.

A clumsy workaround is given on Windows IT pro.

http://www.shelldorado.com/articles/mailattachments.html

In one of my programming projects, I need a decent XHTML viewer with CSS support. The project is to be used in a Windows environment, so the standard web browser was not a good choice. A lot of users will have Internet Explorer as default browser, which has a lot of problems rendering CSS.

My first thought was using k-meleon, which is very fast. But the xhtml viewer should be run by different users from a windows shared directory, and k-meleon does not seem to handle this well.

So I will use Mozilla Firefox after all, because it copies the default profile to the user profile of each user starting it.

I experimented with the menu editor extension to customize the menus, but I did not manage to use the extension in the default profile. So I will try to tweak the menus manually.

how can I run an external program from within a Delphi program?

I was messing with own Delphi components, and I had some troubles with published stringlists. This page helped me out.

To retrieve the last generated id by a database insert, you can use mysql_insert_id for MySql and @@identity for MS SQL server.

I'm using a `normal' network card, and a wireless one. I was wondering if I could persuade Windows to use the wireless card for one range of ip-adresses, and the normal card for all the rest.

This seems to be possible using the route utility. Just route the ip-range to the corresponding gateway.

To limit the number of rows a MS SQL query returns, the TOP Clause can be used.

I used to add database users with phpMyAdmin, but the syntax of grant is not that difficult after all.

Slackware guide for AMP Apache MySQL and PHP. Because mysql would not start after a standard installation.

String functions in Delphi, C++, Java, Basic.

Previously I figured out how to boot Linux using grub commands. However, after e.g. a failed Linux installation, booting Windows can be useful as well.

`DATEDIFF' returns the number of date and time boundaries crossed between two specified dates.

`How to read a binary file into a string' and How to recurse subdirectories'.

Never thought I would be needing this again: Multiple configuration config.sys and autoexec.bat.