Coldfusion Posts

Jul 29, 2015
Before and After Gallery Uploader
Mar 6, 2013
Scoping Makes Me And You Think Less
Jun 14, 2009
When I'm programming in Coldfusion I don't want to have to think. To help me not to think much, I make an effort to scope out every variable.When I go into a piece of code, I want to know whether the variable I'm looking at came from a query, form, argument or the various other sources a variable could come from. Otherwise I look at an unscoped variable and the first thought I have is where the !@#$%^ did this piece of code come from? Did it come from a query I see in a cfloop. Or is it an attribute...
MySQL and Coldfusion - No operations allowed after connection closed.Connection was implicitly closed due to underlying exception/error:
Nov 3, 2006
I received the following after connecting to MySQL 5.0.24a through Coldfusion MX 6.1 using the MySQL JDBC 5.0.4 J/Connector.No operations allowed after connection closed.Connection was implicitly closed due to underlying exception/error: ** BEGIN NESTED EXCEPTION ** com.mysql.jdbc.CommunicationsException MESSAGE: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** STACKTRACE: at com.mysql.jdbc.MysqlIO.readFully(
MySQL and Colfusion - Cannot convert value '0000-00-00 00:00:00' from column 6 to TIMESTAMP
Nov 3, 2006
I was upgrading the MySQL java connector from 3.0.17 to mysql-connector-java-5.0.4-bin.jar on my Coldfusion server. When I tried running a script I received this error:Cannot convert value '0000-00-00 00:00:00' from column 6 to TIMESTAMPI had this problem connecting to both MySQL 4.1.15 and MySQL 5.0.24a.After a quick search, I found this in the MySQL Bugs Database fix it, I added the 2 connection strings they mentioned, to the JDBC URL in the MySQL Administrator...
ImageMagick not working with Coldfusion and cfexecute
Oct 16, 2006
I updated our Redhat server with the latest version of ImageMagick 6.2.9-8 a few days ago. We have 2 servers and the install from source seemed to work on both of them. I was able to run the test command the source install says to run. /usr/local/bin/convert logo: logo.gifBut when I tried running the convert command through the cfexecute tag to resize an image, it wasn't doing anything on one of the servers, but working find on the other one. The cfexecute command was doing this: <CFEXECUTE NAME="/u
Using JDBC connector to connect to MySQL 5.0.24 for high encryption
Oct 8, 2006
Since Coldfusion MX 6.1 and 7 don't include the drivers to connect to MySQL version 5, I had to install the latest JDBC drivers from the MySQL site. This also alleviates the problem of being able to use the higher level of encryption MySQL uses for its passwords, that Coldfusions bundled drivers can't handle.To get the driver, visit the MySQL developer zone and try the latest JDBC driver. In the past, I sometimes have to try different versions, as the latest one doesn't alway work. For my system...
ByteArray objects cannot be converted to strings error
Oct 4, 2006
I ran into this error yesterday from a query that's been running fine for months now. I don't know why it all of a sudden happened, but I thought I would share it with you in case you run across it.I was retrieving some records and outputting the fields to the screen. As I outputted certain fields, they were returning this message:  ByteArray objects cannot be converted to strings error  It wasn't just one field type, and included text and numeric fields. When...
Coldfusion Introduction
Sep 23, 2006
I have been working with the Coldfusion Application Server since 1998. Back then version 3.1 was out. I started out using dbase IV as the database server and to learn on, until my boss introduced me to MySQL in 1999, which is what I still use. I later moved on to working with versions 4, 4.5 and now work with Coldfusion MX 6.1. I currently have an Advanced Coldfusion Certification in Coldfusion MX that I received in December 2004. I work on all types of projects, which include writing whole applications,...