CSV / XLS Exporting in Adobe Coldfusion 9

Let’s talk about XLS Exporting in Adobe Coldfusion 9 (Excel Spreadsheets). ColdFusion has this neat little tag called cfspreadsheet. It allows the writing of, updating of, and reading of CSV/XLS files in ColdFusion. This is a handy tool for exporting dynamically generated queries. It can make XLS Exporting in Adobe Coldfusion 9 very simple and…

ColdFusion Query Timeout: To Bigint, or Not to BigInt?

Writing queries can be simple, easy and an effective way to get the job done. Whether it is MS SQL, MySQL, T-SQL, SQLite, PostgreSQL or SQL in general, ColdFusion provides many built-in functions to allow you access to your databases with ease. It even gives you the opportunity to create dynamically-generated queries with use of…

Cflogin on a cluster.

I spent this week configuring ColdFusion 8’s security framework to operate on a clustered server environment. One of our client is using two windows servers with CF8 enterprise edition running on them. They are in a clustered configuration, and using J2EE session variables. One item that we found important to note is that develops need…

Relational Deletes in MySql and Foreign Keys

Managing relational tables in a database is a topic that all developer will eventually bump into. There are quite a few ways of managing relational data, and the best solution sometimes can be hard to find. As a developer you have to look at the scope of the application, the types of tools you have…

Removing Default Apollo Chrome

Just change this: <mx:ApolloApplication> To this: <mx:Application> Thats pretty much it. I don’t think that this is in the Apollo documentation that came with the alpha. Had to carefully examine the WeatherStation sample app.