Call to a member function mark() on a non-object in Joomla CMShttps://www.joellipman.com/articles/cms/joomla/call-to-a-member-function-mark-on-a-non-object.html

17 November 2013 core framework. Comment it out and you get an error referring to the includes/framework.php file. Comment that out and you will get errors regarding other elements of the CMS. This error could have been caused by many things but in the case of one of my...

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

Joes Password Analyzer (JPA)https://www.joellipman.com/component/content/article/joes-password-analyzer-jpa.html?catid=40

03 January 2014 Obscurity "Security through Obscurity" is always ultimately fallible. This password checker can not guarantee the passwords will be easy to memorize or to type quickly. Companies using certain password systems can even send the login credentials to the...

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

SSRS Stop Scrolling Behindhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-stop-scrolling-behind.html

08 April 2014 the following image: Cycle through each static object and set FixedData to False (ensure all items are set to false or it will error): Save and test on the ReportServer. Background: If you need to visualize how I could have ended up in such a situation,...

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

Convert to Proper Case in T-SQLhttps://www.joellipman.com/articles/database/t-sql/convert-to-proper-case-in-t-sql.html

04 June 2014 case. The feed is originally for a personnel feed so it won't be converting long paragraphs of English text. Instead it will be applied to names and addresses as well as job titles and departments. Why? We wanted a T-SQL version despite having...

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

SSIS: How to loop through multiple flat files as data sourceshttps://www.joellipman.com/articles/microsoft/ssis/ssis-how-to-loop-through-multiple-flat-files-as-data-sources.html

13 June 2014 an example. As my work was for a Personnel/HR project, and data confidentiality is somewhat important, some of the images will be censored or data changed in the example below. Add a variable (preferably to the scope of the package) called...

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

mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connecthttps://www.joellipman.com/articles/database/mysql/mysqldump-got-error-2049-connection-using-old-pre-4-1-1-authentication-protocol-refused-client-option-secure-auth-enabled-when-trying-to-connect.html

28 July 2014 before 6.0.7 • For versions after 6.0.7 Method #3 (Recommended): Do not use MySQL WorkBench!!! Seriously, your pride will slow you down or get you sacked! Instructions: Go to Google Search Search for "Free MySQL database manager" (preferably add...

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

Add attribute xsl:nil=true on empty elements using XSLThttps://www.joellipman.com/articles/web-development/xml/xslt/add-attribute-xsl-nil-true-on-empty-elements-using-xslt.html

18 August 2014 than 0 (not blank) and change the attribute of the element so that it's tag displays "xsi:nil=true". If...then...else... will be emulated by the XSLT choose...when...test...otherwise: true true -- yields: assuming value of DATE_OF_BIRTH is blank or null...

• Type: Article
• Author: Joel Lipman
• Category: XML Stylesheet Language Transformations
• Language: *

Basic Android App using Google Maps and Current Locationhttps://www.joellipman.com/articles/google/androidos/basic-android-app-using-google-maps-and-current-location.html

10 October 2014 following screenshot: Focus the cursor on the word and hold down the key and press Enter, then import each class: Your code will now include the imported classes near the beginning, so TEST it! Addtional: Problems animating the camera to your current...

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

Android Java: Remove first two entries from Google News feed in SimpleRssReaderhttps://www.joellipman.com/articles/google/androidos/android-java-remove-first-two-entries-from-google-news-feed-in-simplerssreader.html

24 October 2014 (without it crashing the app). The gist is to check for a description (the first two items do not have one). The following will also return a publishing date: Find the List function in: PcWorldRssParser.java (readFeed) and replace with private List...

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

Android: Function to let user take photo or choose existinghttps://www.joellipman.com/articles/google/androidos/android-function-to-let-user-take-photo-or-choose-existing.html

04 November 2014 called @+id/hangar_aircraft_photo. The following is a full example of what can be added to a Main Activity Java file and will display an AlertDialog with the 3 options to "take a photo", "choose from existing", or "cancel": /* 201411040126 */ static...

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

Android OS: Add GoogleMap as fragmenthttps://www.joellipman.com/articles/google/androidos/android-os-add-googlemap-as-fragment.html

25 November 2014 need to launch a new intent... I wanted to change my previous example so that the homepage of the app (the starting page) will simply display a button to the map (in case of offline mode or incompatibility with the device). How? In this example, I'm...

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

Submit form as a server and not the client with cURLhttps://www.joellipman.com/articles/automation/api-misc/submit-form-as-a-server-and-not-the-client-with-curl.html

20 February 2015 How? It's likely that you already know how to submit a HTML form to a server via your Mobile application so the following will only document the process of sending data under the server IP address. We're going to use a PHP script with the cURL function...

• Type: Article
• Author: Joel Lipman
• Category: API Miscellaneous
• Language: *

Sort an associative array by values in Javascripthttps://www.joellipman.com/articles/web-development/js/sort-an-associative-array-by-values-in-javascript.html

29 September 2015 y ? 1 : 0; }); // use built-in JSON stringify function newSortedArrayObject = JSON.stringify(my_records_copy); // note: will convert single apostrophes to double-quotes // split by closing curly brace var myRecords = newSortedArrayObject.split('}'); //...

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

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

16 May 2016 } }(document,"script","twitter-wjs"); Instagram Not sure on this one as I could only embed a specific video manually. Will update this if ever a free method for embedding the page comes up. Go to Instagram and open the video/picture to embed Click the 3...

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

Convert foreign characters to English alphabethttps://www.joellipman.com/articles/database/mysql/convert-foreign-characters-to-english-alphabet.html

13 June 2016 properly as it thinks "riviere" is different to "rivière". We need to ensure that a search for any of these kind of words will return results of similarly typed/sounding words. How? Here's just a splurge of SQL but I use this often enough: UPDATE...

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

Pure JS - Display Time Elapsed & Remaininghttps://www.joellipman.com/articles/web-development/js/pure-js-display-time-elapsed-remaining.html

30 October 2018 is generated from an OAuth 2.0 process. I want to display to the user how much time is left before another access token will be generated and how long ago was the last token created. How? So almost pure JS. I'm working out the seconds remaining and...

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

Zoho Deluge: Loop through 30 Minute Slotshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-loop-through-list.html

30 November 2018 is returning an hour value (eg. "08:00") and thisServiceRecord.Closing_Time returns an hour value (eg. "20:00"). This will output a picklist which populates as: 08:00, 08:30, 09:00, 09:30... 19:30, 20:00. // get rid of all picklist options clear...

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

AutoHotkey: Check Windows Folder Sizeshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-check-windows-folder-sizes.html

28 January 2019 Title := "Joes Folder Sizes" Desc := "This program will display folders and their respective sizes." Width := 500 Height := 360 BgColor := "FFFFFF" MarginX := 2 MarginY := 2 Options := "+Caption +Border +ToolWindow -Resize -MaximizeBox -MinimizeBox...

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

Excel - Check a column for values found in another columnhttps://www.joellipman.com/articles/microsoft/excel/excel-check-a-column-for-values-found-in-another-column.html

14 February 2019 not relative). Sheet1!A1 is the cell to search for those words. Note how I don't add a dollar, this is so that the formula will apply to each row and increment based on how you copy the formula to other cells. You should end up with something like this...

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

Zoho Deluge - Update Creator from CRMhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-update-creator-from-crm.html

18 February 2019 » Zoho Ensure you enable/tick "ZohoCreator/creatorapi". Note the name that you call it (displayed in mixed case but will be used in its lowercase form) Method #1: Using UpdateRecords() function with Connection Link: The syntax for this is response =...

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