18. February 2010 13:26 by Markus Wollny

The real Y2K problem: LongInt Unix-Timestamps

18
Feb/10
0

On January 19th 2038 I’ll be 63 years, 9 months and 23 days old. So unfortunately there are still a couple of days until I can think about retirement. What’s wrong with this date?

The Unix timestamp of 2038-01-19 03:14:07 is 2147483647. This is the maximum number that fits into the int4 data type. One second later we’ll be getting integer overflow for any operations on Unix timestamps. Like getting the actual date from that Unix timestamp via dateAdd() in ColdFusion.

11. September 2009 17:13 by Markus Wollny

ColdFusion UDF to test if a Java Class implements a method

11
Sep/09
0

I recently started implementing a couple of our full text search requirements using Sphinx. I am extremely happy with this search engine, as it’s lightning fast and provides some quite easy integration with the data we store in our PostgreSQL databases, is highly scalable and fairly easy to implement in ColdFusion via the Sphinx Client API. 

17. June 2009 12:05 by Markus Wollny

What if HTMLEditFormat() don’t cut it?

17
Jun/09
0

You know of course that you need to HTMLEditFormat() any user input that you intend to display somewhere on your page to avoid racing down the road to XSS hell; to save on processing resources the best time to do this would obviously be before the data goes to your persistance layer (be it some physical file or most likely a database).

If all you want to do is allow your users to store some plain old text, maybe seasoned with some kind of BB-code markup to allow for some limited text formatting, this method is just fine. If that is not enough and you actually need to allow a limited amount of good old HTML, you’ll need some more sophisticated sanitizing mechanism to parse out any potentially harmful code elements like JavaScript actions and the like.