January 2007

A better debugging template for ColdFusion 6+

Way back when ColdFusion MX 6 came out, I quickly switched to the "dockable.cfm" debug template. Then, almost as quickly, I was driven close to madness by its incessant popping up every time a page was loaded. I made a simple change to prevent...

Read more

No more data available to read / 4096

Yes, ColdFusion MX 6.1 is old, but some of our customers are still running it, and we're here to support them. A particular large select query against a SQL Server 2000 database was erroring out with either "No more data available to read" or...

Read more

Identity Insert in Access

Keywords

Equivalent of Identity Insert in Access
AutoNumber Insert
Access 2007

Problem

You are copying rows from one table in Access to another. The destination table has an AutoNumber column which ignores the ids from your source table. You need...

Read more

Changing system-only attributes in Active Directory

WARNING: Following this path can lead to irreversible Active Directory damage. Singlebrook Technology is not responsible for any damage caused by following this procedure. Proceed at your own risk!

A long time ago someone made some schema...

Read more

CFChart on IIS

Symptoms:

You have a page with a cfchart tag, and the page either hangs on the chart or ask for authentication.

Problem:

Some ColdFusion Administrator functions, as well as RDS andcfchart functionality, rely on two ColdFusion templates. However,...

Read more

How do I determine database server version?

Try:

select version()


This should work for MySQL and Postgres


determine database server version
determine MySQL version
determine Postgres version
find database server version
find MySQL version
find Postgres version

Read more

Code of a method longer than 65535 bytes

Encountered the above while parsing an XML file in ColdFusion.

Root of the problem:

This is a limitation of Java. A classfile may not exceed 65535 bytes. ColdFusion compiles CFML into Java bytecode, and each method gets its own .class file. (Look in...

Read more