coldFusion
Update ColdFusion Query Columns With JavaCast
I recently found myself in need of a way to convert a Binary data column into Base64 encoded data when returning a query. After a quick Google, I was directed to Ben Nadel’s post “Updating Columns In An Existing ColdFusion Query Object” which details how to use javaCast to update a ColdFusion query.
From there, I [...]
10 Easy Steps to set up Model-Glue 2: Unity on a Shared Host
Once I had it working, I was astounded by the simplicity. The only pre-requisite is that your server is running ColdFusion 8 or above. Here are the steps:
Note that the following steps assume your site is already created
Download ColdSpring.
Unzip ColdSpring, rename the unzipped folder to “coldspring” and copy it into your site root.
Download Model-Glue.
Unzip the [...]
Use cf_sql_timestamp for MS SQL and MySQL date types
Hopefully, if you’re using ColdFusion, you’re already using cfqueryparam in your queries for better performance and security against SQL Injection attacks. If you’re not, you should read this.
When using cfqueryparam you specify a value and an SQL type. Dates can be assigned two different types, cf_sql_date and cf_sql_timestamp. cf_sql_date is intended to be used [...]
