The greatest invention in IThttps://www.joellipman.com/hardware/the-greatest-invention-in-it.html

13 September 2012 multi-lingual, future-proof and as everlasting as human error. More? "By [undoing] repeatedly, you can gradually work your way back to a point before your mistake. This is convenient if you've made a mistake four or five commands back. It is marginally...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

List last modified files using FTP Command-linehttps://www.joellipman.com/articles/web-development/ftp/list-last-modified-files-using-ftp-command-line.html

20 November 2012 hostname or IP of the server holding my site) Enter login credentials Type dir (lists files & folders in the current remote working directory) Type cd /path/to/my/website to change directory to the root folder containing your website. Type pwd to...

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

About 5 seconds worth of funhttps://www.joellipman.com/articles/microsoft/sharepoint/about-5-seconds-worth-of-fun.html

21 November 2012 Really not work related but if you know your sharepoint site: Custom Error http:///_layouts/MySite.aspx?Error=You%20are%20a%20jerk%20and%20SharePoint%20does%20not%20share%20with%20jerks. Installer? http:///userdisp.aspx=ID=1 Paying attention to the URL...

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

Joes WebGL Experimenthttps://www.joellipman.com/component/content/article/joes-webgl-experiment.html?catid=40

06 April 2013 beta version is demo'd at http://demo.joellipman.com/joomla16/index.php/joes-infographic-for-joomla Limitations Does not work in MS Internet Explorer Is not working on iOS and certain smartphones Advantages No copyright, watermarks and as configurable...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Leap Motion and AR Dronehttps://www.joellipman.com/articles/_other-misc/quadcopters/leap-motion-and-ar-drone.html

17 May 2013 to finger gestures and it's compatibility with major platforms. The following videos were shown to me by a colleague at work. I was so impressed I just had to post them. So here's a screenshot, read more if you want the videos: So Leap in Motion AR...

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

Disable User Registration in Joomla 1.5 - Configuration Filehttps://www.joellipman.com/articles/cms/joomla/disable-user-registration-in-joomla-1-5-configuration-file.html

08 October 2013 having some corruption issues and simply using the Joomla! administrator panel to navigate to global configuration, does not work! How? It isn't in the configuration.php file prior to Joomla! v1.6.x but in the database. Open the database to the Joomla...

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

SSRS Subscriptions cannot be createdhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-subscriptions-cannot-be-created.html

22 November 2013 (setup in the subscription section). The report being subscribed to is hidden in tile view. Cases where this would NOT work Reports where the connection string to the data source is held in the parameters (though, with more time, we could have tried...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

MySQL Updating a database table from another tablehttps://www.joellipman.com/articles/database/mysql/mysql-updating-a-database-table-from-another-table.html

22 October 2014 names and I would rather they all use the ccTLD two letter code. This article was written because it took me so long to work it out. How? UPDATE `table_to_update` a INNER JOIN `table_to_read` b ON a.`CountryName` COLLATE utf8_general_ci LIKE...

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

SELECT COUNT(DISTINCT name) FROM tablehttps://www.joellipman.com/articles/cms/joomla/select-count-distinct-name-from-table.html

24 September 2015 my_table) T1; -- Performance Improvement SELECT COUNT(1) FROM (SELECT DISTINCT my_field FROM my_table) T1; Ones that didn't work for me: Method #3: By grouping (NOT recommended for more complex queries): SELECT COUNT(my_field) FROM my_table GROUP BY...

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

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

06 October 2018 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 access the...

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

Zoho Deluge: Check Time Booking Slotshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-check-time-booking-slots.html

05 December 2018 a double-booking (as in, the time slot doesn't overlap a previous booking. How? Given a date/time and a duration, we will work out the requested start and end time: req_StartTime = input.Date_Field; req_Duration = 90; bool_doubleBooked=false; for each...

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

Calculate Aspect Ratiohttps://www.joellipman.com/graphic-design/calculate-aspect-ratio.html

17 January 2019 So this is a quick article on how to maintain an aspect ratio when resizing an image. How? These are the calculations to work out the new height given the width or the new width given the height: (original height / original width) x new width = new...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *