Author Archives: eSearing

About eSearing

Webdeveloper, Photographer, political junkie.

coldfusion result attributes

During my exploration of the previous article I needed to view the SQL statement that was being dynamically generated. Fortunately Coldfusion has add the “result” attribute to cfquery. This allows you to see things like execution time, sql, sql arguments, … Continue reading

Posted in Code, Coldfusion, Snippets | Comments Off on coldfusion result attributes

Coldfusion list to Modal Window Select to Javascript to Coldusion variable.

I think I have accomplished what was once thought impossible or at least improbable. I have passed variables to a Modal window, allowed the user to execute a form there, passed the variable back to the parent page using javascript, … Continue reading

Posted in Code, Coldfusion, Javascript, SQL | Comments Off on Coldfusion list to Modal Window Select to Javascript to Coldusion variable.

SQL adding new columns to query

Sometimes a table has all the fields you need and sometimes it doesn’t. I sometimes need to create flag fields or summary fields to hold additional information. So here are the methods I use. Add a 1 char flag field … Continue reading

Posted in Code, Snippets, SQL | Comments Off on SQL adding new columns to query

Reserved words and Coldfusion

I ran into an interesting issue today. I had form variables whose names ended in _date. When i was testing I output the form variables using CFDUMP and they appeared in the list of variables passed. However when trying to … Continue reading

Posted in Code, Coldfusion, Problems & Fixes | Comments Off on Reserved words and Coldfusion

Task lists and Documentation

I tried something new on a recent project. I used the MS Outlook tasklist to keep track of things to add, change, update, or fix in my project. Since I work in a rapid development group I do not have … Continue reading

Posted in Problems & Fixes, Randomness | Comments Off on Task lists and Documentation