Drop If Object Existshttps://www.joellipman.com/articles/else/database/t-sql/drop-if-object-exists.html

03 August 2012 What? Some people have been suggesting you can use "CREATE OR REPLACE... VIEW... FUNCTION" but my SQL Server 2008 Management Studio doesn't like this and refuses to understand what I'm trying to do. Why? As this data seemed to be across various...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

Copy a table with structure and data into a temporary tablehttps://www.joellipman.com/articles/else/database/t-sql/copy-a-table-with-structure-and-data-into-a-temporary-table.html

03 August 2012 Why? Hmm... I was writing a stored procedure that will scramble data given a table as a parameter. Because I only want to update a temporary table and not the original (source) table, I needed the following stored procedure (or part of). What? This will...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

T-SQL Conversion failed when converting the varchar to data type inthttps://www.joellipman.com/articles/else/database/t-sql/t-sql-conversion-failed-when-converting-the-varchar-to-data-type-int.html

14 May 2013 What? A very quick note in case I forget this one. If you are trying to join two tables and receiving the error "Conversion failed when converting the varchar value 'B110' to data type int" then read on. How? So where does the 'B110' string come from,...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: en-GB

Data Randomization Function in Oracle PL/SQLhttps://www.joellipman.com/articles/else/database/oracle-pl-sql/data-randomization-function-in-oracle-plsql.html

22 August 2012 What? This article describes a function that will return random data based on a given value. The function intends to determine the data type and return data that is absolutely irrelevant to the original data but the same length and the same type of...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

SQL Queries for Statisticshttps://www.joellipman.com/articles/else/database/mysql/sql-queries-for-statistics.html

13 December 2010 Basically, I've started using so much more SQL in our new Business Intelligence projects that I've been revising all my scripts to see what SQL I can optimize. One of my systems is a MediaWiki CMS which is used for the official Bournemouth University...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: *

Inserting incremental weeks in MySQLhttps://www.joellipman.com/articles/else/database/mysql/inserting-incremental-weeks-in-mysql.html

15 April 2011 Situation: I have a silly database table (not mine) storing CMIS Facility week numbers and their starting dates. For those of you unfamiliar with this system, the reason week numbers are different to normal people's week numbers is because these are...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

MySQL: Display Users and Duration in Matrix Timesheethttps://www.joellipman.com/articles/else/database/mysql/mysql-display-users-and-duration-in-matrix-timesheet.html

27 April 2012 Given Data Activities by employees with start dates and end dates in a mySQL database. Objective User Mon Tue Wed Thu Fri Sat Sun Total --------------- ------- ------- ------- ------- ------- ------- ------- --------- Me 09:00 07:30 08:00 07:00 06:00...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

Generate Academic Calendar using MySQLhttps://www.joellipman.com/articles/else/database/mysql/generate-academic-calendar-using-mysql.html

27 November 2012 What? We have a specific timetabling system for academic institutions and all our staff/students follow academic week numbers as opposed to calendar week numbers. Why? The aim of this article is to quickly generate a calendar for a full academic year...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

What's the problem? Amusing computer issueshttps://www.joellipman.com/articles/cms/website-development/whats-the-problem-amusing-computer-reports.html

28 April 2011 What? Just an article noting some amusing errors encountered during 2nd line support. Why? Might help someone. Might just cheer you up... How? See below... If you're not an IT person, you may want to avoid reading the rest of this article in case you're...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

List of Font Awesomehttps://www.joellipman.com/articles/cms/website-development/list-of-font-awesome.html

04 September 2015 What? I needed to use these in a template I was working on. Font awesome is a brilliant tool for webdevelopers who want icons that can be any size of any color without compromising on image quality or overhead maintenance. It's basically a font set that...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Display Feeds to major Social Networkshttps://www.joellipman.com/articles/cms/website-development/display-feeds-to-major-social-networks.html

16 May 2016 What? A quick article on how I displayed feeds from the company's social network pages in one page. Why? There are 3rd-party apps that let you do this, some paid, some not. This was for a staff portal so I wanted this at no extra cost. This is read-only...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

CSS Background Without Causing Scrollbarshttps://www.joellipman.com/articles/cms/website-development/css/css-background-without-causing-scrollbars.html

23 April 2011 Quick note in case I spend as long as I did again. A Client had some clouds on the background of his photoshop file for his website. They were to be positioned in the top right corner with the leftmost tip aligned to the right of a central content...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: en-GB

FTP on Mac: Failed to retrieve directory listinghttps://www.joellipman.com/articles/cms/website-development/ftp/ftp-on-mac-failed-to-retrieve-directory-listing.html

06 October 2018 Applies to: FileZilla for Mac macOS High Sierra A quick note to remind me how to enable FTP directory listing as it was working on my Windows PC but not on my Mac. The error I was getting was Error: Failed to retrieve directory listing though I could...

• Type: Article
• Author: Joel Lipman
• Category: File Transfer Protocol
• Language: *

Parse a HTML Table into a ListViewhttps://www.joellipman.com/articles/cms/website-development/html/parse-a-html-table-into-a-listview.html

30 March 2013 What? A quick article on if you were given a webpage coded in HTML, what methods in AutoHotkey could you use to separate out the HTML Tables into a ListView. Why? I want a snippet of code that replicates any HTML table. How? I've been trying various...

• Type: Article
• Author: Joel Lipman
• Category: Hypertext Markup Language
• Language: en-GB

Slideshow div layer through a windowhttps://www.joellipman.com/articles/cms/website-development/mootools/slideshow-div-layer-through-a-window.html

11 September 2012 Somewhat incomplete! Will post a final solution but here are the basics What? This article is a quick note to myself on the idea of a slideshow with the MooTools javascript framework. Basically, I want to create a div layer that I can see through (like...

• Type: Article
• Author: Joel Lipman
• Category: MooTools Framework
• Language: *

Creating a Top 10 chart with less codehttps://www.joellipman.com/articles/cms/website-development/php/creating-a-top-10-chart-with-less-code.html

18 February 2010 I've decided to put something in here as it took me an age to find out how I could do it. This is when using a MySQL query within a PHP script. The process is used often to do a statistics table or top ten chart of your data (eg. movies, music, etc)....

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

UTF8 Unicode PHP MySQL for International Charactershttps://www.joellipman.com/articles/cms/website-development/php/utf8-unicode-php-mysql-for-international-characters.html

22 October 2010 This is a note to myself but also to anyone out there who's spent as long as I did looking for a solution to this. Maybe it's just me but this is the scenario: Joomla works fine with international characters A Module Extension I wrote for Joomla!...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Convert XML UTF-16 to JSON UTF-8 with PHP cURLhttps://www.joellipman.com/articles/cms/website-development/php/convert-xml-utf-16-to-json-utf-8-with-php-curl.html

28 March 2015 Previously titled Fix PHP cURL: parser error: Document labelled UTF-16 but has UTF-8 content What? This is an article with notes for me on how to convert some received XML encoded in UTF-16 to some JSON in UTF-8. If it were entirely in UTF-8, I would...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

URL Alias uniqueness with PHP & MySQLhttps://www.joellipman.com/articles/cms/website-development/php/url-alias-uniqueness-with-php-mysql.html

06 May 2019 What? So this is an article for me on how to copy Joomla's and Wordpress' feature where a Title/Name value is converted to a search-engine friendly URL alias and is unique in the database. Ok that's a long sentence; let me try this: When I save a record...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

XML Schema Referencehttps://www.joellipman.com/articles/cms/website-development/xml/xml-schema-reference.html

13 August 2014 XSD Elements Element Explanation all Specifies that the child elements can appear in any order. Each child element can occur 0 or 1 time annotation Specifies the top-level element for schema comments any Enables the author to extend the XML document...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: en-GB