Category Archives: Code

CF linebreaks in excel same cell

Posted on 01/04/2013 by eSearing

By default when you add the BR tag inline Excel will interpret that as you want a new cell. We sometimes merely want a line break. When outputing to excel use this syntax in your code to keep linebreaks in … Continue reading →

Posted in Coldfusion, Snippets | Tagged | Comments Off on CF linebreaks in excel same cell

MSIE 9 bug – enctype multipart/form-data

Posted on 12/13/2012 by eSearing

Fixing Coldfusion error message Invalid content type: application/x-www-form-urlencoded.The files upload action requires forms to use enctype=””multipart/form-data””. It is a bit misleading since we usually list the enctype. However for MSIE 9 Encoding must be there too. <CFForm action=”somepage.cfm” method=”put”, enctype=”multipart/form-data”, … Continue reading →

Posted in Code, Coldfusion, Javascript, Problems & Fixes | Comments Off on MSIE 9 bug – enctype multipart/form-data

SQL Server – Reset Identity Column

Posted on 12/07/2012 by eSearing

How to reset the identity counter in SQL SERVER DBCC CHECKIDENT(‘tablename’, RESEED, 0) The zero can be any positive value. I often use the year as numbering system like 2012000001

Posted in Snippets, SQL | Comments Off on SQL Server – Reset Identity Column

Coldfusion AJAX updating a database from any page link

Posted on 11/28/2012 by eSearing

I had an interesting situation where I needed to Tag orders as “Reviewed” in a database so they could be filtered out in future queries. I wrote my standard query form form to limit results as usual, added filter (reviewed, … Continue reading →

Posted in Code, Coldfusion | Tagged | Comments Off on Coldfusion AJAX updating a database from any page link

Javascript – checkboxes are checked?

Posted on 11/08/2012 by eSearing

How to Evaluate if Check Boxes are checked when submitting a form. Throws an error if none are checked. Continue reading →

Posted in Javascript, Problems & Fixes, Snippets | Comments Off on Javascript – checkboxes are checked?