Month: September 2016

Nest Protect and Thermostat Integration Needed

Kevin HallGood Design

I’m at that ten year mark when I need to replace all the smoke detectors in my house. I’m looking at the items on the market and in reviewing the Nest Protect I noticed a huge missed opportunity. I have a Nest Thermostat and love it. However, one shortcoming it has it that the temperature can vary a lot between where it is placed and the other rooms in the house. I have to put a smoke detector in almost every room to be up to code. If those also had a temperature sensor and could communicate to the thermostat then I could easily adjust or set rules when the bedroom is too hot or cold compared to the kitchen […]

Read more

Tower, Git, Springloops, Xcode and Authentication Errors

Kevin HallSoftware

I installed an update to XCode and subsequently found I could not connect to git repositories on Springloops using Tower on macOS Sierra (that’s a nice pile of software). I was getting Authentication errors in Tower when trying to reach the repository. After trying a bunch of things to reconnect and getting rather frustrated by the whole thing I finally found that I need to agree to the XCode license again in order to use git. To do so open up Terminal and type: sudo xcodebuild -license Then hit space a bunch to get to the bottom of the license. Once you do you’ll be prompted to type the word agree. Once you do that quit Tower and start it […]

Read more

Docs Onsite Updates

Kevin HallGeneral, Project Management, Software

We’ve added a few new features to Docs Onsite. Docs Onsite is the document and project management system that we’ve developed. We’ve been really pleased to see how it has worked for other client based companies who need to manage large quantities of documents with clear, simple, auditable access controls and logging. It is also how we manage our internal tasks, calendars, files, time tracking (which exports to QuickBooks for billing), support tickets, and bug tracking. The latest features are small looking updates, but are both very useful. We’ve added tagging to the Tasks, with color coding. This has really helped make it easy to quickly filter the task list to a related group of tasks. We’ve also integrated a […]

Read more

ColdFusion SQL Security

Kevin HallColdFusion, Security

It’s common when working on a web application to interact with a database to read, insert, update, or delete data. In doing so you must take care when using variables in your SQL. The input may be coming from a search form or passed in the URL, but wherever it comes from there is a risk of SQL Injection, Cross Site Scripting or other attacks on your system. ColdFusion provides a few helpful tools for preventing people from executing malicious SQL queries or executing JavaScript injected into your database. One is the cfqueryparam tag. Assuming we set first_name = “Kevin” This would look something like this SELECT u.first_name, u.last_name FROM users u WHERE u.first_name = <cfqueryparam cfsqltype=”CF_SQL_VARCHAR” value=”#first_name#”> This will […]

Read more