Access MySQL databases using Oracle SQL Developer
So this is a quick article on how to install the mySQL add-on for Oracle SQL Developer v3.0.04.
Knowledge base / Since 1999
Scripts, systems & field notes.
Practical solutions and technical notes from CRM platforms, workflow automation, APIs, databases and the systems around them.
Advanced search477 entries / matching AI
Clear filters
Cheat Sheet for mySQL vs t-SQL
Some memory aids for me so that I don't have to keep looking them up:
JDatabase: using the Joomla database with examples
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...
Proposed Budget i3 PC under £200
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...
Three boxes, two roll over, one falls out
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...
Delete related records from multiple tables
So this is a quick article on how to delete from multiple tables in a mySQL database where we use some JOIN statements.
Php convert filesizes to bytes kb mb gb
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"
Setup a copy of your Joomla website
More for others than for myself, but this article is for those who do not have development/test environments of their Joomla website. I have been doing this for years and still come across clients who have the one version of their website. They experiment on their customer-facing website and in most cases, they are pay...
Error 1065: Query was Empty
In view of the fact that this error pops up in so many systems I take over, I have often gone down the wrong path following the red herring as it were when in fact the answer to this is very common.
Loading more notes...
No more notes to load.