Monthly Archives: September 2011

CFINVOKE Passing parameters by using attribute format

Posted on 09/26/2011 by eSearing

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

Posted on 09/22/2011 by eSearing

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

Posted on 09/06/2011 by eSearing

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