Category: Programming

Empty variable checker for Web Analytics Tools

As a web developer, I know how frustrating it is to get an undefined or NULL error in the browser’s javascript console when testing your web analytics variables. This blog posting will provide you with a javascript function that you

Posted in JavaScript, Programming, Web Analytics

Comparison Operators within SQL

Continuing with the helpful SQL postings, I will dive into comparison operators today.  Comparison operators compare values and return one (1) if the comparison returns a true or zero (0) if its false. 

Posted in Programming, SQL

Arithmetic Operators in SQL

Are you looking to perform basic arithmetic operators on two values within SQL but are unfamiliar with how to set this up or what to leverage? This blog posting will provide you the operators and what their specific function is.

Posted in Programming, SQL

Optimize Table via SQL

Sometimes, in the process of creating tables within SQL, you can have a lot of unused and wasted space that you wish you could remove so that the table can be more optimal. This blog posting will describe how you

Posted in Programming, SQL

Inserting Data into a Table Using SQL

Inserting data into a table via SQL can be done via the insert functionality within SQL. This blog will explain two different methods for leveraging this. 

Posted in Programming, SQL

Scraping Website Data via PHP

Have you ever been in a situation where you wanted to retrieve information from a website or webpage but it wasn’t readily accessible through either web service APIs or data feeds (as the data we are looking to pull in

Posted in PHP, Programming

Displaying Twitter Friend Statuses via PHP

Have you wanted to display the last status of our friends but don’t know how to go about doing that within PHP or leveraging Twitter’s API? This blog posting will provide the necessary logic to provide this visibility that you

Posted in PHP, Programming

Opening a Text File as a Workbook in Excel using VBA

Opening a text file within excel is a simple and straight forward operation that can be performed using the OpenText method of the Workbooks collection. By leveraging this method, Excel opens the text file as a single worksheet within a

Posted in Programming, VBA

Leveraging getQueryParam plugin within PHP with Adobe Analytics

Not every option that is available to you with the JS AppMeasurement library is available in the PHP library. This blog posting will describe how we can port that functionality over to PHP to take advantage of the plugin for

Posted in Adobe, Adobe Analytics, PHP, Programming

Creating and Launching VBA Subroutines within Microsoft Excel

You can easily create and launch subroutines within the VB editor. Each macro that runs within Microsoft Excel is really a subroutine that contains specific blocks of VBA code.

Posted in Programming, VBA