Knowledge base / Since 1999
Practical solutions and technical notes from CRM platforms, workflow automation, APIs, databases and the systems around them.
Advanced search639 entries
So having moved desk from one side of the room to another, I have lost my view of the sea. Oh well, this is where technology has come to the rescue and returned my calming view... Note: I think this is running in British Summer Time (BST) rather than GMT or it's clock is seriously off. Otherwise it's a picture from the...
This is a quick note on finding the last occurrence of a string in a longer string. This has to be in Transact SQL for a SQL Server instance only and not filtered by other code.
Apologies for posting yet another article on how to access the Joomla Database using the Joomla classes but this is just a quick note for myself as a reference sheet. Plus the official documentation don't have enough examples in my view. Source: http://docs.joomla.org/ for v1.5.x and for v2.5.x This article applies to...
i3 workstation upgrade running Windows 7 So another year gone and our workstations running Windows 7 are somewhat lagging when opening too many apps. The recent release of Windows 8 has led to a review of our developer's equipment and the verdict is that our workstations need upgrading (it always is). So on a budget (i...
Applies to Windows 7. Requires a Vogonian environment of red tape and bureaucracy. This is an article to describe an alternative method then "right-clicking on the desktop", "selecting Personalize", "clicking on Desktop Background", "browsing to the Picture Location". The problem happens when browsing to the picture lo...
So this is an article to note an oddity when I was working with a Yootheme template called "yoo_sync". Some clever scripts (both mootools and jquery) using the equalize method to make div layers the same height, and in this case, the same width. It isn't so much a miscalculation of 100% divided by 3 that leaves 1 pixel...
So this is a quick article on how to delete from multiple tables in a mySQL database where we use some JOIN statements.
So this is a quick article to get your Google Translation services working with your website.
Just a quick note on how to format a given filesize and to reduce the display output to a small string, eg: 196 bytes : displays as => "196 bytes" 12945 bytes : displays as => "12 Kb" 1478515 bytes : displays as => "1 Mb" 8798745455 bytes : displays as => "8 Gb"
Working principle
This site exists as a practical knowledge base built from real-world experience across systems, platforms, and technologies since 1999. Much of the content documents solutions, edge cases, and working patterns that were learned through investigation where documentation was incomplete or absent, and is shared to reduce the same friction for others.
Recently Added
👍 Zoho CRM's Notes now gets Reactions and a new look Zoho CRM: Sync Deal and related record owners from Zoho Desk Zoho CRM: Link supplier emails to the Purchase Order Emails related list Zoho CRM's WhatsApp integration now supports multiple accounts, multiple numbers, and custom modules Zoho Books: Improper Statement Error might be due to missing ';'Protected notes
Log in for protected notes and any private client projects assigned to your account.