Code Scraps: Finding duplicate records in MySQL
This is a quick code scrap to illustrate how to identify duplicate field values in record sets in MySQL. The code may also work for other SQL languages, but do […]
Data
Code Scraps; Validating undefined and null in Javascript
I’m always forgetting how to to this in Javascript – here’s a couple of ways of validating if an object is undefined or null, and the good points about using […]
Code Scraps: Get a list of all content in a directory on Windows
I recently posted a code scrap for getting all content of a directory in Linux. Here is the same code scrap but for Windows. C:\TestDir\> dir /b /s > C:\temp\files.txt […]
Code Scraps: Random unique colour generation
I have worked on a number of social projects over the years which have involved message boards or social posting features by users. On some websites like Microsoft’s message boards or StackOverflow […]
Code Scraps: Word list tidying
I have recently been messing around with dictionary lists for a little personal project. My goal has to been to make an anagram/word finder, where you provide up to 9 letters […]
Bulk generate SQL, JSON objects or code markup using Excel / Spreadsheet
Sometimes I have had a need to turn an un-formatted or unstructured data set into a database table or more recently into a set of JSON objects. The source data […]