Author Archives: eSearing

About eSearing

Webdeveloper, Photographer, political junkie.

CFEmail – Fix

If your link to the SMTP server is occasionally interrupted you will notice that CFEmail will no longer function until CF services are restarted. While reviewing an article by Ben Nadel he mentioned using an alternate SMTP Server such as … Continue reading

Posted in Coldfusion, Problems & Fixes | Comments Off on CFEmail – Fix

CFINVOKE Passing parameters by using attribute format

Found this useful today: You can pass parameters in the cfinvoke tag as tag attribute name-value pairs, as the following example shows. You can also use a relative path to the CFC. <cfinvoke component=”/path/to/authQuery” method=”getAuthSecure” lastName=”#session.username#” pwd=”#url.password#” /> can also … Continue reading

Posted in Code, Coldfusion, Snippets | Comments Off on CFINVOKE Passing parameters by using attribute format

CFLocation – URL redirection

There are times when it is handy to redirect to another CFM or page based upon search results. The issue I had this week was due to uninformed users not knowing which option to choose. So at the beginning of … Continue reading

Posted in Code, Coldfusion, Snippets | Comments Off on CFLocation – URL redirection

SQL Numbering a table in sequence without IDENTITY

This is for renumbering of the rows in a table with out IDENTITY. — add a rowid to the table ALTER TABLE #table_name ADD rowid int null — set the rowid vales to zero UPDATE #table_name SET rowid = 0 … Continue reading

Posted in Code, Snippets, SQL | Comments Off on SQL Numbering a table in sequence without IDENTITY

Files disapearing from directory when sending email attachments

This is related to a bug within the cfmailparam behaviour in CF9. It is removing the files even if you specify remove=”no”. This has now been patched in Cumulative Hotfix 1 (CHF1) for ColdFusion 9.0.1: kb2.adobe.com/cps/862/cpsid_86263.html Bug ID: 83725 + … Continue reading

Posted in Code | Comments Off on Files disapearing from directory when sending email attachments