I ran into a very odd issue this week with Coldfusion 7. I have an application that I have had up and running for a couple years and I made some database changes, CFquery (DAO) changes. Since I use Illudium-PU 37 Generator for most of my Bean, DAO, Gateway, & services I automatically get the benefit of being reminded about cfqueryparam (Thanks Brian). Unfortunately this time around I didnt regen the files, I simply went in and made a couple modifications since I only added like two columns to the table.
Well all went well for like a week, than all of a sudden I started getting this crazy error. I kept getting a message saying "Invalid Parameter Binding(s)" and it wasnt even the new columns I just added, it was something else entirely.
I did some digging in my cfdump of the cfcatch error message, I discovered that for some odd reason Coldfusion was converting a bit into a integer even though both my bean, ActionScript Value Object and the cfqueryparam were all set to a boolean value / cf_sql_bit. So when flex sent over the data to CF all was well, but when it sent the data to the DAO.cfc to do a save/update into the database the cfqueryparam was sometimes doing it right and sometimes doing it wrong, it was really -- really hard to duplicate the error message, but here is what it the message was returning in the cfcatch...
Read more...