Author Archives: eSearing

About eSearing

Webdeveloper, Photographer, political junkie.

CFOUTPUT and Array result sets

Posted on 05/25/2010 by eSearing

Imagine you have a query that returns a few results like Product Categories sold for a given period. You might have a query like: <cfquery name=”myQ” datasource=”myDSN”> select distinct category from sales order by category. </cfquery> Your results might look … Continue reading →

Posted in Code, Coldfusion | Comments Off on CFOUTPUT and Array result sets

JQuery Confirm

Posted on 05/25/2010 by eSearing

The standard JavaScript confirm prompt allows you to ask a question and the user can respond with ok or cancel. But suppose you want them to have the choice of sign-up and non-now? This allows you to guide the user … Continue reading →

Posted in Code, JQuery | Comments Off on JQuery Confirm

Create dropdown selection for last 12 months.

Posted on 05/21/2010 by eSearing

Simple Coldfusion method for creating a select dropdown form element of the last 12 months sorted descending. The report-date is formatted for oracle queries. Change the dateFormat mask to fit your needs. <cfselect name=”report_date”> <cfloop from=”1″ to=”12″ index=”x” step=”1″> <cfset … Continue reading →

Posted in Code | Comments Off on Create dropdown selection for last 12 months.

Temp tables and bad habits

Posted on 05/20/2010 by eSearing

We often have need to hold the results of a query in a temporary table so we can join or perform other tasks in later queries. <cfquery name=”Q1″ datasource=”myDsn”> select * into ##temp1 from mytable </cfquery> It is nice that … Continue reading →

Posted in Code, Coldfusion, SQL | Comments Off on Temp tables and bad habits

Coldfusion Wheels Framework

Posted on 05/17/2010 by eSearing

Every developer eventually begins to see the pitfalls of large applications and trying to manage all the files and processes that make up that application. At work, I am dealing with a large existing CFML application with hundreds of cfm … Continue reading →

Posted in Applications, Coldfusion, Products | 2 Comments