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

23 October 2015 These are two methods I like and will work in tandem. They will not affect the standard visitors to your Joomla website (specifically those not interested in logging into the administrator section). Updated for Joomla 3.x but pretty much the same system...

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

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://joellipman.com/component/content/article/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html?catid=74&Itemid=165

04 October 2013 should remain lowercase. How? The SSIS Script component task has to be generic, it should only apply this to columns we specifically tick in a package and we should be able to use the same script in any package... eek! Either of the two following script...

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

$_SERVER['http_referer'] returns blank in Internet Explorerhttps://joellipman.com/component/content/article/serverhttpreferer-returns-blank-in-internet-explorer.html?catid=62&Itemid=165

19 October 2009 is to not use it for verification purposes as it will only work in every other browser except Internet Explorer (more specifically versions 6 and 7...???) For more details:...

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

SSRS Retrieving Oracle Stored Procedure Success or ErrorLevelhttps://joellipman.com/component/content/article/ssrs-retrieving-oracle-stored-procedure-success-or-errorlevel.html?catid=75&Itemid=165

04 November 2011 privileges to list all the details. On the last report, the one to execute the stored procedure, we use an account specifically created to run the stored procedure. This requires using 2 data sources in SSRS. A user will specify the student reference in...

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

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

04 June 2014 of usage: SELECT ufn_ProperCase([Surname]) FROM employees Additional: Note how the above doesn't convert postal codes, specifically British postcodes, which isn't included in the examples above because the function was only going to be applied to names...

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

Database Error: Unable to connect to the database: Could not connect to MySQLhttps://joellipman.com/articles/else/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

25 September 2009 Cleared the expired cache but still got the error. I then uninstalled half of these (including Kunena and Agora forums), specifically database intensive plugins and the error happened less... I then went through the menus and installation screen to get...

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

Developer's Checklist: Taking over a projecthttps://joellipman.com/articles/cms/website-development/developers-checklist-taking-over-a-project.html

01 March 2011 and vulnerability) Technical Review Examine all functions: what goes in, what comes out? (accepts/returns, data types specifically, test by running each function separately) Examine databases (data types, constraints, primary/foreign keys,...

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

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

30 October 2018 most reduced cut down formats I've made. I thought I'd make a note of it to not have to search elsewhere... This example specifically displays the time remaining on an access_token which is generated from an OAuth 2.0 process. I want to display to the...

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

MS Excel: Convert a text to a numberhttps://joellipman.com/component/content/article/ms-excel-convert-a-text-to-a-number.html?catid=110&Itemid=165

15 November 2013 when did MS Excel stop understanding what a NUMBER was? I have a column full of currency values which I want to convert, specifically Philippine pesos to British pounds (sterling). When I multiply the Philippine peso by the conversion rate, it returns...

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