Author Archives: tgc

How to change your Amazon Associates ID in WordPress posts

You may find yourself, for one reason or another, needing to update your amazon affiliate links in your WordPress posts to reflect a new tracking id. Depending on the number of posts your are dealing with, doing this by hand … Continue reading

Posted in MySQL, Wordpress | Leave a comment

Adventures in Windows Batch Scripting

I recently completed a project that required me to write a handful of windows batch files. These files needed to be as universally compatible as possible. This unfortunately ruled out options such as cygwin, powershell, and vbscript, which would have … Continue reading

Posted in Windows | Leave a comment

Returning Composite Types in Postgres Stored Procedures

Expanding on the PostgreSQL examples in our previous post, here we will look at taking advantage of some of the features in PostgreSQL 8.3 and modifying our zip_proximity function to avoid using cursors and instead define and return a set … Continue reading

Posted in Postgres | 1 Comment