Shaun Mccran

My digital playground

24
J
U
L
2008

SQL Formatting a numeric field to 2 decimal places

Need to format a field to a certain number of decimal places?

Just do this:

[ More ]

04
J
U
L
2008

Converting and formatting DateTimes in SQL queries

I've come across the need to format a dateTime as a string in SQL, so after a little research I found that its pretty straightforward.

[ More ]

03
J
U
L
2008

Matching date ranges to flex arrays in SQL queries

Whilst writing a search function for a flex applicaiton I needed to be able to filter results back to flex from a remote cfc by a variety of criteria. Two of these were the month, and the year. So here's a handy way of doing it.

[ More ]

22
M
A
Y
2008

Weather Web service (cfc) - Part 1

Recently I've been experimenting with consuming public Web Services and interpreting them through a Flex front end.

So I thought a handy remoting service would be a weather forecast feed consumer.

[ More ]

_UNKNOWNTRANSLATION_