Update and create timestamps with MySQL

A lot of relational tables need created and update timestamps columns. I prefer having them for all tables with no exception. However, most of applications I am working on are running MySQL. MySQL has minor limitation on timestamps. Unfortunately you can create only one time stamp column that has DEFAULT NOW() value. Read more to see how to avoid this limitation.

13 comments: Read more »

Ant task to install tomcat service

If you are familiar to run Apache Tomcat as Windows service, you can install it with the ant task. build.xml file sample under the cut line.

2 comments: Read more »

Clear upload file input field

Many web developers came to the problem that they are not able to change value of file input field from Java Script in the web application. There is no access to value field of file input tag because of security restriction. However there is a trick how to erase this field if you need it in your application.

65 comments: Read more »