Could not instantiate mail functionhttps://www.joellipman.com/articles/cms/joomla/could-not-instantiate-mail-function.html

09 May 2011 Fix Check that this error isn't resolved by just changing the Mailer (Joomla > Global Configuration > Mailer settings). Alternate between PHPmail and sendmail just to check this isn't the problem. If the problem is still there then check the below:...

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

SSRS Querying on either of 2 Parametershttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-querying-on-either-of-2-parameters.html

19 July 2011 leaves both fields blank? This would return all users who don't have an AD account. Using the revisited solution below -> Just leave the "allow blank" option in the parameter properties unchecked SSRS Report Revisted: Had an issue where SSRS report...

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

Joes DNS Correction (JDC)https://www.joellipman.com/component/content/article/joes-dns-correction2.html?catid=40

25 November 2011 had this? Your colleagues are connecting fine and your IT service desk say everything is functioning normally and it's just YOU! Script Function If you are on a network that frequently loses connection or simply forgets what intranet site you were...

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

Performance Report - Background colors based on dataset valueshttps://www.joellipman.com/articles/microsoft/ssrs/green-red-background-colors-based-on-dataset-values.html

02 December 2011 totals of these. I haven't Googled this at the time of print so there may be a million better solutions out there, this is just how I did it. This may look like a horrible report which would fail an accessibility test but visually it says straight away...

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

Prefix Line Numbers in a Text Filehttps://www.joellipman.com/articles/automation/ms-dos/prefix-line-numbers-to-a-text-file.html

18 July 2012 Prefixing lines with their respective line number in a text file using a Microsoft Windows Operating System... I've just googled this as I couldn't remember how I did this last time and a number of people showing off their MS-DOS batch skills have...

• Type: Article
• Author: Joel Lipman
• Category: MS-DOS
• Language: *

Inline Labels in Form Fields using Javascripthttps://www.joellipman.com/articles/web-development/js/inline-labels-in-form-fields-using-javascript.html

21 August 2012 the color back to grey. If it isn't, then leave as is and ensure the color is still black. Additional Note that instead of just saying if this value equals "Name:" I've added some code to trim the values. If the user types two spaces, then we want the...

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

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

11 September 2012 the first slide again (restores the starting position of "next slide"). The Gist Strategy This may not be a great idea, I'm just trying something out. The brief was pretty much just "...fast and works with cms articles...". If we have 100 slides then...

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

Search a database with SOUNDEXhttps://www.joellipman.com/articles/database/search-a-database-with-soundex.html

11 October 2012 same way in the same case. Wouldn't it be nice to search through your entire database for similar sounding values (so not just case), and in this example, find typos as well, eg. "Daat ont Ety Aviable". How? Mine's a bit of a copout as it is a two-step...

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

JDatabase: using the Joomla database with exampleshttps://www.joellipman.com/articles/cms/joomla/jdatabase-using-the-joomla-database.html

27 January 2013 Apologies for posting yet another article on how to access the Joomla Database using the Joomla classes but this is just a quick note for myself as a reference sheet. Plus the official documentation don't have enough examples in my view. Source:...

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

CharIndex Reverse - find occurrence starting from end of string in TSQLhttps://www.joellipman.com/articles/database/t-sql/charindex-reverse-find-occurrence-starting-from-end-of-string-in-tsql.html

28 January 2013 added for demo purposes): String1.String2.String3.String4 1 5 10 15 20 25 30 -> length = 31 I'd like to end up with just the last part of this, ie "String4". So I need to delimit based on the dot/period (.) and use substring in a sort of reversed form....

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

Things to Check if Joomla Password Reminder email not being senthttps://www.joellipman.com/articles/cms/joomla/things-to-check-if-joomla-password-reminder-email-not-being-sent.html

09 May 2013 Navigate to Extensions > Language Manager Click on the “Overrides” label Click on “New” (but don’t create a new one – we’re just checking something) In the right pane, type “COM_USERS_EMAIL_PASSWORD_RESET_BODY” without the quotes and tick the “Constant”...

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

Autohotkey Count Number of Files/Folders in a Directoryhttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-count-number-of-files-folders-in-a-directory.html

04 June 2013 So this is an article to list methods of retrieving the number of files in a folder/directory. Why? Why can't we just use a loop and file pattern native to the Autohotkey programming language: UserFolder:="C:" -- UserFolder := RegExReplace(...

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

Reorder Columns in a Tablehttps://www.joellipman.com/articles/database/reorder-columns-in-a-table.html

22 July 2013 Just a quick note to myself on how to reorder columns as I was having difficulty using a phpMyAdmin interface to do this. How? Taken from the best forum for programming Qs&As: http://stackoverflow.com/questions/4095481/easy-way-to-re-order-columns...

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

Problem creating SSRS report subscriptionshttps://www.joellipman.com/articles/microsoft/ssrs/problem-creating-ssrs-report-subscriptions.html

11 November 2013 in the dropdown menu Select "Data Sources" in the left menu Specify a "shared data source" and browse to the one you just created and click on "OK". Click on "Apply" (just to be sure). Ensure unattended system account scheduled to run and email the...

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

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 one of my clients, the error was due to an update process gone wrong. Not really the fault of Akeeba, Joomla or anyone, it's just one of those things. Check the sizes of the PHP files on your site and hope that they're not at 0 bytes. Excluding the HOME...

• 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 Companies using certain password systems can even send the login credentials to the remote machine for you, but does this just open another can of worms? The trick in my opinion is a memory aid. How to use Type a word in the input field and check the...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• 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 // Creates a CameraPosition from the builder map.animateCamera(CameraUpdateFactory.newCameraPosition(cameraPosition)); Just in case: AndroidManifest.xml The example above should have populated this correctly but if you are still getting problems, I have...

• Type: Article
• Author: Joel Lipman
• Category: AndroidOS
• 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 What? An article on how to quickly adapt an array code and sort by its values. Surprising how many examples are on the web and everyone saying you're doing it wrong... Which is true but quite unhelpful. The original code is not my own either but that's...

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

Protecting your Joomla Administrator Sectionhttps://www.joellipman.com/articles/cms/joomla/protecting-your-joomla-administrator-section.html

23 October 2015 to ensure you have a static IP (most ISPs now assign static IPs to home broadband users as well as larger corporations). But just in case you don't have one, let me do this in two stages. Move the /administrator URL Create a folder in the root of your...

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

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

13 June 2016 from foreign characters and return the English equivalent. Why? A content management system (CMS) that I'm working on has just gone international and started including the names of places in other countries. This is nice but its search engine doesn't...

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