SQL

What makes a competent programmer?

Ever wondered how to tell if you are hiring a competent programmer?  In the following video Ron Burk discusses the Psychology of Incompetence in which he leaves you with no illusions.

If builders built buildings the way programmers wrote programs, then the first woodpecker that came along would destroy civilization

Cool SQL to update traffic exchange icons

Digital Dave came up with an issue that I had never given much thought to, he wanted to update the icons used by www.police-traffic.com in the tools page.  He had uploaded the icons and then began changing the paths manually in the manager.  Anyone who has done this before will probably know what a pain it can be.  So Dave asked if there’s an easier way, and there is, and here it is;  run the following SQL in your SQL Viewer changing the path to your new templates and voila, job done!

UPDATE vtp_menus 
SET menu_icon = 
REPLACE(
  menu_icon,
  '/templates/standard/images/',
  '/templates/your-template-folder/images/'
)