You can’t specify target table ‘xxx’ for update in FROM clause
I recently needed to update a whole bunch of records using an IN() on the target table: UPDATE table1 SET…
OpenVPN on Linux – save password
My Linux box is secure, so why do I need to remember the extremely difficult to remember password for one…
Toggle radio buttons by clicking the label
I’ve seen a few methods of this using over-elaborate JavaScript, when its really not necessary. All you need to do…
eXfat drive not working in Windows XP?
So you got a nice 64GB USB stick, and can’t format it NTFS but want to transfer huge files on…
Finding files in Linux/Mac Terminal
Finding files is a little different to MS DOS! find <startlocation> <type> <filename> <exec> The exec is a simple way…
Case Insensitive JQuery contains selector
If you need to use :contains() as a selector but need a case insensitive one, you need to extend jQuery…
Apache PHP mkdir not writable?
If you ever find that you are creating a folder with PHP, and its immediately not writeable by Apache, then…
Get MAC address from IP address
Had a routing issue the other day, and I was remotely trying to forward a port to a device. I…
Getting wkhtmltopdf working on Linux
I’ve had a few troubles getting this running, and thought I would document it here. First of all get the…
preventDefault not firing on onkeyup event
Simple one. $(document).on('#element', 'keyup', function(event) { if (event.keyCode == 13) { event.preventDefault(); //do some other stuff } }); This doesn’t…