MySQL: Find all non-alphanumeric rowshttps://www.joellipman.com/articles/database/mysql/mysql-find-all-non-alphanumeric-rows.html

09 September 2013 What? Quick note on how to do this. I was tasked with cleaning up an english database by replacing all special alphabets (ë to e) and non-alphanumeric symbols with URL friendly characters. How? -- return all records that contain non-alphanumeric...

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

A for loop within a for loop in MS-DOShttps://www.joellipman.com/articles/automation/ms-dos/a-for-loop-within-a-for-loop-in-ms-dos.html

03 October 2013 What? A quick note for myself as I'd forgotten how to do this (we're talking technology belonging to the 90s - MS-DOS v6.22). The example wants to loop through a directory and then loop through the line it finds. Why? I use another technology for...

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

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 What? A quick reminder on how to disable user registration in Joomla! CMS version 1.5.x without using the Joomla! CMS back-end panel. Why? Because we're having some corruption issues and simply using the Joomla! administrator panel to navigate to global...

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

Joomla Development: Possible XML Filtershttps://www.joellipman.com/articles/cms/joomla/joomla-development-possible-xml-filters.html

17 October 2013 Applies to: Joomla! CMS 2.5.x Joomla Filter: Validation OnSave INT Forces the value to be an Integer UINT Forces the value to be an absolute number (-4.2 becomes 4.2) FLOAT Forces the value to be a floating point value BOOL Forces the value to be true...

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

SharePoint 2007: Change profile picture with minimal permissionshttps://www.joellipman.com/articles/microsoft/sharepoint/sharepoint-2007-change-profile-picture-with-minimal-permissions.html

07 November 2013 What? This is a quick article on how to change your profile picture in your company's sharepoint site. Sounds straightforward but without being allowed to upload images or edit other profiles, each user has to do this with the permissions they've been...

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

MS Excel: Convert a text to a numberhttps://www.joellipman.com/articles/microsoft/excel/ms-excel-convert-a-text-to-a-number.html

15 November 2013 What? This is a quick article on how to convert some cells in Microsoft Excel to number values... Why? OMG. Seriously Microsoft! I have spent an hour trying to convert a column of currency values to a number using Microsoft Excel 2010. Since when did MS...

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

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

22 November 2013 Applies to: Microsoft Business Intelligence Development Studio 2008 (BIDS) Microsoft SQL Server 2008 R2 What? This article describes solutions to the error: Subscriptions cannot be created because the credentials used to run the report are not stored,...

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

Oracle: order by subquery missing right parenthesishttps://www.joellipman.com/articles/database/pl-sql/oracle-order-by-subquery-missing-right-parenthesis.html

05 December 2013 What? A quick note on how I got round one this one. Why? Often enough, our requirement is that the latest record from another table is associated with the current row, and often enough we get the latest by ordering the dataset of the subquery. In T-SQL...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: *

Regular Expressions in SQLhttps://www.joellipman.com/articles/database/regular-expressions-in-sql.html

09 January 2014 What? Practice makes perfect. Or in my case, any practice is a start. This article serves as a quick note on how to use regular expressions within SQL statements: How? For the following examples, I am pretending to select rows from a table called...

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

SSRS Border Problemhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-border-problem.html

20 January 2014 What? A very quick note on why borders may be misbehaving in SSRS. This note corrects the situation at Design time. This is where you are trying to select a cell to have an outline border but then cells around it without a border. You may find that BIDS...

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

PHP: First name and Initial of Surnamehttps://www.joellipman.com/articles/web-development/php/php-first-name-and-initial-of-surname.html

27 March 2014 What? A note for myself on some code to convert a string of two names into a string made up of the first name and then using the initial of the second name. -- What I have John Smith Fred.Bloggs -- What I want John S. Fred B. How? So different ways, the...

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

SSRS Change Background Color of Imagehttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-change-background-color-of-image.html

08 April 2014 What? Sounds easy but actually if you use an image which has transparent areas, ie. has one color which will be transparent, the transparent pixels will be colored in with the page background color. Why? I want an image to display per row as a status...

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

SSRS No Delay for First Report of the Dayhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-no-delay-for-first-report-of-the-day.html

11 April 2014 What? This article describes a solution our reporting server administrators found to cut the loading time of the first report of the day. Why? Take any SSRS report, if one of us was the first to run it on that day, it would take an additional 60 seconds...

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

SSRS Display question mark when date is blankhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-display-question-mark-when-date-is-blank.html

15 April 2014 Applies to: Microsoft SQL Server Reporting Services 2012 Microsoft Visual Studio 2012 Premium Microsoft Windows 7 Enterprise What? So I have a column in an SSRS report which displays a date. Being rather pernickety, I would like a question mark to...

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

SSIS: Add Reference Microsoft.SqlServer.TxScripthttps://www.joellipman.com/articles/microsoft/ssis/ssis-add-reference-microsoft-sqlserver-txscript.html

03 June 2014 What? This article is so that I don't spend so long in googling what the TxScript referenced assembly is when creating an SSIS custom component. How? This is simply the "Script Component" under "Extensions". No MSDN website said this... obvious to...

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

SSIS: Cannot open Data Flow Task: DTS.Pipeline.2 issuehttps://www.joellipman.com/articles/microsoft/ssis/ssis-cannot-open-data-flow-task-dts-pipeline-2-issue.html

09 June 2014 What? I started getting this error: The task with the name "Data Flow Task" and the creation name "DTS.Pipeline.2" is not registered for use on this computer Why? We use a combination of MS Visual Studio 2008, 2010 and 2012. VS2008 for our old SSIS...

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

Joomla WHERE clause with ORhttps://www.joellipman.com/articles/cms/joomla/joomla-where-clause-with-or.html

16 July 2014 What? A quick article on how to use the where clause in a joomla database query. Why? In response to a member, I use the old form where I can include the whole SQL statement: $db->query('SELECT * FROM #__myTable WHERE condition1=true or...

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

SITS: XET format for Export not availablehttps://www.joellipman.com/articles/web-development/xml/sits-xet-format-for-export-not-available.html

08 August 2014 What? Trying to export a STU record but I want to use the XET template I created rather than the pre-installed XML export formats. When I try to export using data format XET, the system has never heard of it. Why? To test the XET I created, I want to...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

DJI Phantom FC40 - First Flighthttps://www.joellipman.com/articles/_other-misc/quadcopters/dji-phantom-fc40-first-flight.html

28 August 2014 The YouTube channel or user channel (once I get it figured out) can be found at https://www.youtube.com/user/joeylipman

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

Two icons created on Androidhttps://www.joellipman.com/articles/google/androidos/two-icons-created-on-android.html

20 October 2014 What? If you're installing an app and it creates two icons: Why? I don't think I'll forget this one but I was stumped for a bit until I found it on the a forum: Stack Overflow: Android App Development. How? Basically don't have the following declared...

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