Contact Me
Resources
-
Category Archives: Snippets
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
Coldfusion Output to .txt file
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
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
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
CFTextarea maxlength validation onblur
Here is a nifty little trick. If you have a cftextarea and you want to let users know when they have exceeded the length allowed in the database you can use the maxlength plus validation attributes. You can use validateat … Continue reading
Posted in Code, Coldfusion, Snippets
Comments Off on CFTextarea maxlength validation onblur
