Ordered List of over 1000 Items
So many people asking this when the solution is a bit of aesthetic styling. ol -- yields 995. 996. 997. 998. 999. 000.
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 search608 entries
Preg_Replace all strings between two tags
For those of you who use Preg_Replace. Preg_replace is a function that uses regular expressions to search and replace a string.
Export/Import Database using MySQL Workbench
This article isn't unique as there are other tutorials out there. This is meant to detail a process to export a database using MySQL Workbench and then to import it into another database.
Quickly update all content in mySQL database replacing a string
This is an article on how to replace a string with another in all your joomla articles without modifying other data such as modified date and author.
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.
Cheat Sheet for mySQL vs t-SQL
Some memory aids for me so that I don't have to keep looking them up:
Live WebCam feed of Bournemouth
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...
CharIndex Reverse - find occurrence starting from end of string in TSQL
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.
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...
Loading more notes...
No more notes to load.