Category Archives: Code

CFFILE action failure – check the directory path

Posted on 03/28/2011 by eSearing

Encountered an interesting error today after move from CF8 to CF9 the following code produces a path for a directory in which you can use CFFILE actions <cfset thisPath=ExpandPath(“/”)> <cfset thisDirectory=GetDirectoryFromPath(thisPath)> <cfset RootPath=”#thisDirectory#”> However you need to output the rootPath … Continue reading →

Posted in Code | Comments Off on CFFILE action failure – check the directory path

my pond journal

Posted on 01/22/2011 by eSearing

This is my latest personal website. It is a journal about building my pond and what I hope to be a japanese style garden. Constructed entirely in WordPress twenty ten theme with minor modifications to CSS and images. Please visit … Continue reading →

Posted in Code | Comments Off on my pond journal

Coldfusion Output to .txt file

Posted on 01/19/2011 by eSearing

A couple of methods I use to output a file from the browser to .txt. Write your query as normal. Then use one of the two output methods below. CF8 – Output as comma delimited with quotes. Note, without quotes … Continue reading →

Posted in Code, Coldfusion, Snippets | Comments Off on Coldfusion Output to .txt file

Javascript, CSS2, and Display Table Row

Posted on 01/11/2011 by eSearing

I have a requirement to show/hide a new form variable based on year selected for the year 2011. I initially tried wrapping the table TR tags inside of a DIV in the form. <div id=”togglethis” style=”none”> <tr> <td><label>Mylabel</label></td> <td><input type=”text” … Continue reading →

Posted in Code, CSS, Javascript, Snippets | Comments Off on Javascript, CSS2, and Display Table Row

SQL – Synchronizing identity field between two tables

Posted on 11/05/2010 by eSearing

One thing that DBAs often have difficulty with is moving data from one database to another database. This may be to synchronize a development environment with databases or tables on other servers with the same data values. Fortunately MSSQL provides … Continue reading →

Posted in Code, Snippets, SQL | Comments Off on SQL – Synchronizing identity field between two tables