Microsoft SQL Script to update BlogCFC 5.92

I just upgraded tonight to the latest release of BlogCFC, (what runs this blog) and realized that there is not an upgrade script for mssql. I edited the one provided for mysql and here it is:

ALTER TABLE tblblogcomments ADD killcomment varchar(35) NULL ALTER TABLE tblblogcomments ADD subscribeonly int NULL

ALTER TABLE tblblogentries ADD summary varchar(255) NULL

ALTER TABLE tblblogentries ADD subtitle varchar(100) NULL

ALTER TABLE tblblogentries ADD keywords varchar(100) NULL

ALTER TABLE tblblogentries ADD duration varchar(10) NULL

Simple SES

As I was deploying the latest version of the Resonant Media site (www.resonantmedia.com). It was important to do as much as possible to make it search engine friendly. I opted to use a custom 404 page that processes the the URL via simple CFC that I built.

I will be posting more about the way it works in a future post.

BlogCFC was created by Raymond Camden. This blog is running version 5.9.2.002.