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…
Attack Low Hanging Fruit
Digital Marketing Tips & Tricks
Category: Programming
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…
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
