Sometimes I’ve had the need to use SQL to go and get table information i.e is a field varchar or int etc.

For MS SQL server you can use the following to get info on a table

SELECT RIGHT(syscolumns.name, LEN(syscolumns.name)) AS dbFieldName, systypes.name AS typename, syscolumns.length AS maxlength, syscolumns.xprec AS [precision], syscolumns.xscale AS scale, syscolumns.isnullable AS isnullable
FROM [...]

Instead of using a graphic image (jpg or gif) it is possible to display a nice tick.

Use the following CSS and special character code:

The Css

.tick {font-family: Code2000, TITUS Cyberbit Basic, Doulos SIL, Chrysanthi Unicode, Bitstream Cyberbit, Bitstream CyberBase, Thryomanes, Gentium, GentiumAlt, Visual Geez Unicode, Lucida Grande, Arial Unicode MS, Microsoft Sans Serif, Lucida Sans Unicode;}

The [...]

When using the timeformat function, there is a bug in the milliseconds mask.

The mask for milliseconds is defined as follows:
l or L: milliseconds. l gives 3 digits. L gives 2 digits.

Infact they both give the same result – 3:digits, unless there is a trailing ‘0′ in which case the result is a 2:digit number.

Share and [...]

Just a quick note to myself and anyone trying to install Coldfusion for Apache 2.2
The wsconfig.jar file that is used to connect to apache needs updating (download available at bottom or on right hand side).
Adobe have a technote on this issue.
download wsconfig

Share and Enjoy:

Just a reminder to peeps out there.

We all know the benefits of using application.cfc, right?

Well remember this – If you’re writing a distributable application, one that may sit on BlueDragon or CFMX 6, don’t use application.cfc….. it won’t work.

So endith the sermon.

Share and Enjoy: