Thoughts n Musings

Utlizing the JSON APi
By Brian Fescoe
June 22, 2016

Here are two different example of how to use the JSON api in MURA. One pulls back a page based off of a content ID Number the other will display multiple results via a content collection.

Read More
Comments (0)
Importance of declaring local vars in CFC's
By Brian Fescoe
November 11, 2015
This isn't really a new topic and has been discussed many time's before. However I can't not stress the importance or declaring local vars in CFC's, even query's
 
So what can happen, why all the fuss? Truthfully I never really bothered declare them. I mean isn't ColdFusion supposed to do that automatically?
Read More
Comments (0)
Aggregate functions in SQL
By Brian Fescoe
September 30, 2015

When using aggregate functions is SQL it is important to only SELECT the columns you absolutely need.  In my last post I was trying to achieve basically the same thing as in this one, however even though it achieved the same results I was unable to use it to display the results I want without my function getting really complicated. 

Read More
Comments (0)
SQL is powerful! Use it!
By Brian Fescoe
September 24, 2015

I'll admit I tend to use CF for all my coding but sometimes using SQL is by far and away easier to accomplish your goal as well as just a hell of a lot more quicker. I was struggling with retuning a total number of exercise minutes for a project that I'm working on. I tried double looping, adding variables together all kinds of stuff. Sometimes if you just keep it simple its so much better.  
 

Read More
Comments (0)
Call List
By Brian Fescoe
September 5, 2015

Sometimes I wonder the hell people are thinking, or not in this case. I work in the IT department @ a major city hospital. We have some high speed stuff but we do some really stupid s%*t. For instance, there is a call list that's in excel that has all of IS's (that's what we call IT here) phone numbers and contact information. In case there is an emergency or an application is down the managers or Directors can look u up and contact you. And it's sent out  in an department wide email to check the call list and update it. 

Read More
Comments (0)