ColdFusion and cfquerynew and date times - timestamp

ColdFusion is typless this make's lots of things easy but when creating a new query we have to be careful as occasionally ColdFusion will do it's own thing and "type" a column as the wrong "type" ie treat a date/time as a string for example.

We had an instance of this recently which is not easily reproducible but was fixed by forcing column to "timeStamp".

While searching for the cause of this I used the ColdFusion docs to ensure I was using the right types and well according to the docs type "date" shoudl allow date and time information but it did not. I was a bit dissapointed to see this wasn't working as intended and i really wanted a type of "dateTime" which didn't exist according to Adobe. So I tried anyway and got this error message which put me on the right path.

Type "timeStamp" exists and worked perfectly but is not mentioned in the doc's.

Here is a demo:

URL: http://cf9.kukiel.net/demos/querynew




Here is the link to the ColdFusion docs:
http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7f94.html

ColdFusion Lists, SQL IN and cfqueryparam

We had a tiny issue where a SQL statement was trowing an error on one of our servers this was due to a '  in a value in a list in an IN statement.  It was an old block of code and was not using .  While using preserveSigleQuotes would suffice I prefer the list="true" attribute on cfqueryparam.

Here are 3 demos ( no cfqueryparam, cfqueryparam and full cfscript )

Here is the demo in action:  http://railo.kukiel.net/listin/

iPhone and Flash - Sucess

A while ago I jail broke my iPhone and attempted to get Flash running on my 3GS via Frash.  I was greeted with some issues and basically just gave up.  I tried again recently and successfully installed Frash.

Here is the proof:

Earlier Flash and iPhone post.

ColdFusion jrun and the JVM

I have been doing a little work on tuning our jvm on one of our CF8 Standard servers; I have made several changes with advice from others and have seen improvements one setting I see is this:

-Dsun.io.useCanonCaches=false

I'm not sure what this setting is or does if you know can you provide a detailed explanation. Thanks

ColdFusion and CFReport

We use report builder quite a bit and it's not a bad tool for producing reports and being able to absolutely position things is great.

Recently we converted a few reports that we were generating in html then using cfdocument to reports built with report builder.  The speed increase was dramatic from ~15-20 seconds to ~1 second

The server this is runnign on is running ColdFusion 8 standard edition.

In CFADMIN there is this setting:

 Maximum number of simultaneous Report threads 
The maximum number of ColdFusion reports that can be processed concurrently.


There is very little information on this but I presume that only 1 report can run at a time.  Am I understanding this correctly?  If 50 people hit it at the same time are they queued?  We haven't had any issues yet but I want to look at our options and find out why/if we need to upgrade this server to Enterprise.

jQuery or EXTjs

What would you prefer and why?

EXTjs is not free

jQuery is.

EXTjs is built into ColdFusion jQuery is not.

jQuery is Microsoft's defacto Ajax library so it has some big support behind it.

We use EXTjs at work but I use jQuery at home.

iPhone 3Gs and Flash player

UPDATE!!! I got this to work: Flash - Frash iPhone 3Gs It works!

Has anyone tried and successfully installed Frash on iPhone 3Gs running OS 4.01

I jailed broke my phone yesterday and installed Frash using this method:

http://gizmodo.com/5608095/the-easier-way-to-install-flash-on-iphone-4-and-ipad

and this is all I get:

Ideas?

Easy way to embed ColdFusion code into your blog

OK I don't use a ColdFusion blog engine for my blog.  I have reasons for this.  I run my own ColdFusion servers and move/mess with my personal server enough that I don't really want to chance messing up the blog.  I have a really stable Railo VPS aswell and I could use that but I'm happy with blogger and the layout so I'm going to stick with it. 

The one thing that's always difficult is is code highlighting.  I have tried many different syntax highlighters and usually have quite a bit of trouble making them work properly and embedding code just takes too long.  But we all want to see the actual code in the page so I generally make that effort.

I found that pastebin.com provide a really good service and I knew you could share code via a URL but I didn't know they had an embed option which works perfectly.

Here is a demo:



And here is what I need to paste into the wizywig editor in Blogger:



Just use the "Embed" link to get the code and scale the height to match the length of the code block.

There you go embedded code.  Now if you/I were running on a CFML engine I'd investigate a custom tag

Enjoy.

Flex and the MATE framework in Melbourne

Heard about MATE the flex framework?  Well if possible head to the Melbourne Flex Usergroup this Thursday.  Free dinner and drinks and a good crowd.

http://mfug.groups.adobe.com/index.cfm?event=post.display&postid=29035

Speakers

Brendan Owen
Brendan currently works for Jacaranda as a digital content developer. His work usually switches between two type of development, writing digital learning objects in flash for http://www.jacplus.com.au/ and building online systems using Flex, PHP and MySQL for internal company use.
 
Agenda

Introduction to the Mate Framework
Building large scale systems can become unmanageable without a framework. The Mate flex framework is designed to help with the development of larger flex applications. It is designed to easily link events generated by your application using an EventMap. This talk will run through the basics of using this framework to build a simple Flex application.
http://mate.asfusion.com/