Coldfusion Blog Entries

Porfolio

Posted Jul 29, 2015

Scoping Makes Me And You Think Less

Posted 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:

Posted 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 ** java.io.EOFException STACKTRACE: java.io.EOFException at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:19

MySQL and Colfusion - Cannot convert value '0000-00-00 00:00:00' from column 6 to TIMESTAMP

Posted 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 Databasehttp://bugs.mysql.com/bug.php?id=18308To 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

Posted 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

Posted 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

Posted 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

Posted 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,...

Latest Discussions

  • Carlos: Thank you!
    May 16, 2014 | Replies (0)
  • Jessica: Great info, thanks!
    May 15, 2014 | Replies (1)
  • Walter: Thanks, you totally saved me a bunch of searching around just now. I was setting up a percona xtradb...
    Feb 25, 2014 | Replies (0)
  • Avi: I've found the reason of the problem in my case. It's a bug as described here :http://bugs.mysql.com/bug.php?id=68892Shortly:...
    Dec 12, 2013 | Replies (0)
  • Avi: I've also met that behavior twice on 5.6.12 slaves. However, i didn't find the root cause of that....
    Dec 12, 2013 | Replies (0)