Category Archives: Code

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

Posted on 09/13/2010 by eSearing

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

Posted on 09/03/2010 by eSearing

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

Posted on 08/23/2010 by eSearing

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

Select option [0] value

Posted on 08/10/2010 by eSearing

I have an application that allows the user to look up order detail. When they click on that order number they can open a trouble ticket. I pass most of the order information to the trouble ticket which is built … Continue reading →

Posted in Code, Javascript, Snippets | Comments Off on Select option [0] value

cfselect and query values

Posted on 08/09/2010 by eSearing

Similar to binding to a cfc but binding with a query on the same page. Notice the query and value attributes and how they relate to the query. I added an ” All” as a default. <cfquery name=”get_last_names” datasource=”mydsn”> select … Continue reading →

Posted in Code, Coldfusion, Snippets | Comments Off on cfselect and query values