Monthly Archives: October 2008
- October 27, 2008
- Fun with reserved words in MySQL 5
Most tools or languages you work with have words which are “reserved”, meaning you cannot use them in a variable declaration or schema definition etc as they have special treatment in the underlying system. If you try to do this you’ll usually get an immediate error.
Today I needed to change an existing SQL query from [...]
- October 22, 2008
- Aqua Data Studio 7 includes an ER modeler
Those of you who miss diagramming support when using MySQL tools will be pleased to know that the latest version of Aqua Data Studio has support for ER Modeling
The Entity-Relationship (ER) Modeler we’ve built into Aqua Data Studio 7 is as powerful as even the best standalone database diagramming tools. Use it to [...]
- October 22, 2008
- Problems submitting a form via ‘enter’ in IE
th, td{border:1px solid #ccc;padding:5px;vertical-align:top;}
th{font-weight:bold;}Like many things, handling form submissions with ColdFusion can be done many many ways. A preferred method which I’ve been using for years now is looking for a specific element in the form struct. Something like:
Most times I use a hidden field as the form element to look for (in my structKeyExists()), [...]
- October 13, 2008
- generateRandomKey() UDF with several handy options
Working on a ColdFusion project recently I had the need to generate a random key; the format of which was based on a specific set of business rules. I actually ended up writing a basic UDF to handle this but after the fact I went looking to see if I could find something which provided [...]