Paul Kukiel -
and what i'm interested in.

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

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://cf9.kukiel.net/demos/listin

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.

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

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.