Author Archives: eSearing

About eSearing

Webdeveloper, Photographer, political junkie.

Coldfusion output value formats

Posted on 05/06/2010 by eSearing

a library of things I use regularly but can never find when I need them. I will add to it over time. #datetime(fieldname, “mm/dd/yyyy”)# #DOLLARFORMAT(fieldname)# Excel formatting: color alternating rows <tr bgcolor=”###iif(currentrow MOD 2,DE(‘ffffff’),DE(‘ffff99’))#”> number as text in excel <td … Continue reading →

Posted in Code, Coldfusion, Snippets | Comments Off on Coldfusion output value formats

Select TOP n vs Set Rowcount n

Posted on 05/05/2010 by eSearing

We had an issue this week while migrating our databases from Sybase to SQL SERVER. In sybase we would use SET ROWCOUNT 1 if we wanted to return only 1 record within a cfquery. Works just fine and it is … Continue reading →

Posted in Code, Problems & Fixes | Comments Off on Select TOP n vs Set Rowcount n

dumping form variables

Posted on 05/04/2010 by eSearing

Occasionally I need to see the form variables passed from the form to the next page. There are a couple of ways to do it depending on your needs. CFDump is probably the easiest and outputs the results to a … Continue reading →

Posted in Code, Coldfusion, Snippets | Comments Off on dumping form variables

CSS3 – The vanishing shadow

Posted on 05/01/2010 by eSearing

Do you usually resort to Photoshop to create an image of text or object with a drop shadow, save it as a gif or png (and hope no-one is using IE6)? Or do you layer boxes within background boxes to … Continue reading →

Posted in Code, CSS, Snippets | Comments Off on CSS3 – The vanishing shadow

Border CSS for Tables

Posted on 04/30/2010 by eSearing

I was reacquainted this week with a couple of CSS attributes for the HTML table. table{border-collapse: collapse; border-spacing: 0px 0px;} border-collapse has three attributes: collapse – Borders collapse into a single border. border-spacing and empty-cells properties will be ignored separate … Continue reading →

Posted in Code, CSS, Snippets | Comments Off on Border CSS for Tables