Author Archives: eSearing

About eSearing

Webdeveloper, Photographer, political junkie.

snippet – cfquery.executionTime

Got long running queries? <cfquery name=”myquery” datasource=”ds”> select whatever </cfquery> <cfoutput>Exection time: #cfquery.executionTime# msecs</cfoutput> Note: the syntax is cfquery.executionTime not queryname.executionTime

Posted in Code, Coldfusion, Snippets | Comments Off on snippet – cfquery.executionTime

The joys of a new blog

So many articles to write, but even more spammers to fend off… hint to spammers, if your comment has a ton of links and your conversation doesn’t add any value, your comment will be deleted, never to be seen by … Continue reading

Posted in Randomness | Comments Off on The joys of a new blog

Coldfusion quick tips – #1 of many in the future.

Coldfusion Tips or “things I learned recently” will be in the code category and will be documented here as a reminder. preservedata = “yes/no” Useful attribute in CFFORM if you need reload your form on the same page once submitted. … Continue reading

Posted in Code, Coldfusion | Comments Off on Coldfusion quick tips – #1 of many in the future.

CF datefield calendar

CF8 came bundled with a neat feature to create a calendar form element. <cfif not isDefined(‘form.mydate’)> <cform action=”thispage.cfm” method=”post” preserveData=”yes”> <label for=”mydate”>The Date <cfinput type=”datefield” name=”mydate” readonly /> …//other html form elements here <cfinput type=”submit” value=”go”> </cform> <cfelse> <cfquery name=”get_date”> … Continue reading

Posted in Code, Coldfusion | Comments Off on CF datefield calendar

Verifying Coldfusion version

Need to know which version of CF you are running? Try this. <cfset strVersion = SERVER.ColdFusion.ProductVersion /> <cfset strLevel = SERVER.ColdFusion.ProductLevel /> <cfoutput>#strVersion# .. #strLevel#</cfoutput>

Posted in Code, Coldfusion | Comments Off on Verifying Coldfusion version