Creative Notice

So I wanted a better DirectoryList method for Coldfusion. Better meaning faster with more details. I found this post by Anuj Gakhar which was pretty good. I’ve added some more flexibility. It’s you’re to use; if you make improvements, please post those on the Gist so everyone can benefit.

It’s so simple it would be to easy to forget. Select @@version

There have been a few times where I’ve needed to return the values of multiple columns as one column containing a CSV list of those values. This is accomplished using a sub-query like so… USE AdventureWorks GO — Check Table Column SELECT Name FROM HumanResources.Shift GO — Get CSV values SELECT STUFF( (SELECT ‘,’ + [...]

Here you go. I found this handy. RewriteCond %{HTTP_HOST} !^www\.(.*)$ [NC] RewriteRule ^(.*)$ http://www.%{HTTP_HOST}/$1 [R=301,L]

Ran across this little gem when needing to change the schema of all tables in a given database. Obviously you’ll exchange “new_schema” with the schema of your choosing. From Ruslan Trifonov’s blog. exec sp_MSforeachtable “ALTER SCHEMA new_schema TRANSFER ? PRINT ‘? modified’ “