Windows Media Center Reports No Signal when Recording

I was having a problem with my local ABC station working when I viewed the channel to watch a show, but every recording was failing saying "There was no TV signal when the show was scheduled to record" even if I went to the channel immediately following that error it was working. If I tried to press record on the show as it was playing it would fail and say no signal again. It turns out the problem is the antenna somehow is picking up two sources. I'm not sure why it could play the show live and not record, but here's how I fixed it.

  1. Open the Program Guide
  2. Right click the problem channel
  3. Choose Edit Channel
  4. Choose Edit Sources - you should see two sources enabled
  5. Disable one of them and try the channel again. If that doesn't work disable the other source and try the channel again.

For reference I'm using Windows 7 with an AVerMedia M780 Tuner.

Adding a default commit message to TortoiseSVN

I always seem to struggle finding how to do this since I do it so infrequently, so I'm posting this here to save me a few minutes next time I need to do this. It's really a very simple process and provides a nice reminder of what should be included in the commit message (if you have any sort of guidelines around it).

Find the folder you want to add the default message to and right click it. Go to TortoiseSVN > Properties

From there select New > Other and then enter "tsvn:logtemplate" (without the quotes) as the Property Name and your default message as the Property value.

I tend not to apply the property recursively as 99.8% of my commits are based off of the main folder, but feel free to check that value if you want it to show up even if you commit a single file or from a single folder within your parent folder.

NCDevCon - Responsive Web Design slides and video

Big thanks to all the volunteers at NCDevCon especially, Jim Priest and Dan Wilson, the conference was really great.

Thanks to everyone who truned out for my Getting Started with Responsive Web Design presentation. My slides are now posted online and the video of my talk is live as well.

All the videos can be viewed here.

Batch inserting records to a database

I was writing some code for a client that processed a csv file and inserted each row into a database, when there were a couple hundred rows the processing time was very quick, but when there are 8000 rows this can take quite a while even on a very fast database, so I wrote up some code to batch insert the records (which I've done too many times).

I was using MSSQL, so the max parameters I could send at one time was 2100 (210 rows x 10 columns), but your mileage may vary. I'd set rowsPerInsert as high as possible and decrease as necessary. You should be able to easily modify the pseudo code below.

view plain print about
2 totalrows = 5000; // this would come from a structCount or something similar
rowsPerInsert = 210;
4 //this creates a struct with alternating values of true/false for test purposes
stRows = {};
6 for (i=1; i
<=totalRows; i++) {
7 stRows[i] = i MOD 2 ? true : false;
8 }
11<cfloop from="0" to="#totalRows - 1#" step="#rowsPerInsert#" index="totalRow">
12    <br><br>INSERT #totalRow#<br>
13    <cfloop from="1" to="#rowsPerInsert#" index="indRow">
14        <cfset rowNumber = totalRow + indRow>
15        <cfif rowNumber LTE totalRows>
16            #rowNumber# #stRows[rowNumber]# <!--- SELECT goes here --->
17            <cfif indRow NEQ rowsPerInsert AND rowNumber NEQ totalRows> UNION ALL</cfif>
18            <br>
19        </cfif>
20    </cfloop>

This is mostly for me to steal from myself once I need this again, but hopefully you find it useful as well.

NCDevCon - Getting Started with Responsive Web Desgin

I announced this a while back on twitter, but I'm formally writing something up here. I've been chosen to speak at NCDevCon on Responsive Web Design. I spoke on this topic at cf.Objective(), but will be modifying my talk to include more information on em's and rem's and other available framework options.

I'll be talking about what exactly responsive design is and if you should use it'for your website. I'll also cover the most common misconceptions and explain exactly how it works.

I'll be covering many of the available frameworks and discuss the pros and cons of each one. I will also talk about emerging best practices and who the industry leaders are when it comes to designing a great responsive website.

My original talk is located here. If you attended my presentation and there was anything you particularly liked or disliked please let me know. Any and all feedback is welcome.

ColdFusion Query of Queries strips whitespace

I was tasked with tracking down a defect at work this week. We are creating a URL based on the results of a query and somehow a string of " ABC DEF 12345" was being turned into "ABC DEF 12345" (DB2 FTW!) The webservice we were using was unchanged and was still returning the whitespace, so I knew the issue was something on my end. We have a few pieces of code that strip out duplicate spaces and extra line breaks, so I removed those, but the issue still persisted. After working through about a dozen solutions I called over Scott Busche and we repeated everything I already gone through, but when we stumbled upon a Query of Queries, Scott suggested that could be the culprit.

The query of queries was used to filter a result set down to the past two years only (the webservice we're using just ignores end date, which is awesome in itself), so we googled and quickly found that QoQ trims leading and trailing whitespace from columns and has been doing this since ColdFusion 6, so I don't think this is considered a bug, just something to be aware of.

How to solve the issue? We googled and found this stack overflow question, but that solution only worked for Railo and then we found a post on Ben Nadel's blog (obviously) that pointed out a Java function that would do what we needed, but when removing more than one row in the query you would eventually run into an index out of bounds error the way he had it structured, but that's easy enough to fix.

view plain print about
1<cfloop from="#myQuery.recordCount#" to="1" step="-1" index="currentRow">
2 <cfif myQuery.runDate[currentRow] LT left(getStartDateTime(),8)>
3 <cfset myQuery.removeRows(currentRow - 1, 1)>
4 </cfif>

After implementing this fix our query was working correctly, but we still needed to add URLEncodedFormat to our URL parameters, so the whitespace wouldn't be stripped (and because it should have been done in the first place).

FWIW Railo 4.2 does NOT strip out whitespace. Test case below

view plain print about
1<cfset q = queryNew("columnA", "varchar", [[" AAA"]])>
2<cfquery name="test" dbtype="query">
3SELECT columnA
7<cfdump eval=test>
8<cfdump eval=len(test.columnA)>
9<cfdump var="#replace(test.columnA,' ','a space','all')#">

number 6
string a spacea spacea spaceAAA

You can also run this code on

UPDATE: Adam Cameron pinged me on twitter (and Ray added in the comments) that this is fixed in ColdFusion 11.

cf.Objective 2014 - Getting Started with Responsive Web Design

I tweeted this out a while back, but I have been selected to speak at cfObjective() 2014! I blogged in early November about my proposal and the people have spoken! I hope to see all of you at the conference!

Responsive Web Design has been a buzzword since the term was first coined in May 2010. Come find out what this emerging technology is all about as you are introduced to the basics of Responsive Web Design. We'll cover your current options when it comes to designing your own website and we'll also discuss emerging best practices and a few examples from industry leaders. We will also take a look at how you can test your responsive design without owning one of each device out there.

Target audience

Anyone interested in creating one website for every device

Assumed Knowledge

Basic CSS and HTML experience

What the audience will learn

  • What is responsive Web Design and how does it work
  • When is responsive Web Design appropriate?
  • Pro/Cons of using a framework
  • Fixed vs Fluid layout
  • Best Practices for developing a site
  • Common Misconceptions
  • Who is using responsive web design?

If you're interested in attending head on over to and register before March 1st to get an early bird discount.

Connecting MS SQL database to Railo datasource

Tonight was the 2nd time I've struggled getting Microsoft SQL Server set up to communicate with Railo (and really anything at all), so I thought I'd write up some quick tips on what I had to do. Once you think you have everything set up there are 2 steps that are left.

Go to Microsoft SQL Server 20XX > Configuration Tools > SQL Server Configuration Manager

From there open up TCP/IP and make sure Listen All is set to No

After that go to the IP Addresses tab and make sure Active and Enabled are yes (enabled defaults to no) and make sure you're using the IP and correct TCP Port when configuring your datasource.

Thanks to this MSDN post for getting me on the right track.

What tab is playing that sound?

One of internet users biggest annoyances has been resolved in Chrome 33. When a tab starts playing audio Google Chrome version 33 adds a speaker icon to the tab.

From all the testing I did, the speaker icon is the last thing to disappear when you have a bunch of tabs and it works whether you have multiple tabs with audio, if the audio is paused and isn't dependent on your system sound being turned on.

cf.Objective() Proposal - Getting started with Responsive Web Design

Interested in learning about responsive web design? Head on over to the cf.Objective() Trello board and vote for my talk on Responsive Web Design and any others that you would like to attend.

Here's a brief description of what my talk will be about

Target Audience: Anyone interested in creating one website for all devices

Assumed Knowledge: Basic CSS and HTML experience

Objective: Introduce responsive web design and why it's important

Why I'm Qualified: Part of a team that created a mobile website for a large insurance company.

What the audience will learn: What is responsive Web Design When is responsive Web Design appropriate Pro/Cons of using a framework Fixed vs Fluid layout Concept of columns and grids

Anything else you'd like to learn? Feel free to comment here and/or on the Trello board and if my talk is selected I'll try to work a few suggestions in as well.

More Entries