Welcome to my website!https://www.joellipman.com/articles/web-development/welcome-to-my-website.html

19 March 2011 website then feel free to get in touch using my contact form. Thanks for visiting! I hope this website is, as always, of some use to you!

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

MySQL Oracle equivalentshttps://www.joellipman.com/articles/database/mysql-oracle-equivalents.html

27 September 2010 title of this article implies something rather odd and upcoming considering that Sun Microsystems bought MySQL and Oracle bought Sun. But in fact, this is just a quick list of some regular commands in MySQL that I need in Oracle: Objective MySQL Oracle...

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

SSRS Expand specific drilldown by defaulthttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-expand-specific-drilldown-by-default.html

23 February 2011 thought I'd put something here as there are lots of posts like this on forums (a lot of which seem to be copied & pasted from other sites) but they refer to SQL Server 2000 or SQL Server 2005. This is how to do it in SQL Server 2008 and creating a...

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

Border settings not saving in SSRShttps://www.joellipman.com/articles/microsoft/ssrs/border-settings-not-saving-in-ssrs.html

24 March 2011 may sound silly to some but I've written a note because I spent time googling and still didn't find an answer. My situation is that I wanted to put an expression to format the border (empty cells have a border and non-empty don't). This was so that a...

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

Set default parameter dates to start and end of monthhttps://www.joellipman.com/articles/microsoft/ssrs/set-default-parameter-dates-to-start-and-end-of-month.html

05 April 2011 second parameter (ToDate) is the same as the first (FromDate), then the range is for that particular date. Solution Easy for some but anything that I spend 30 minutes googling and reading up on is asking for an article on my own site. Besides this is...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

SSRS Repeat Headers in PDF Reporthttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-repeat-headers-in-pdf-report.html

26 October 2011 Problem I've set some tablix headers but when I request the same report in PDF format, the tablix headers only appear once on the first page. Every subsequent page simply displays the report header (which does not include the tablix header......

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

DBMS Random Referencehttps://www.joellipman.com/articles/database/pl-sql/dbms-random-reference.html

21 August 2012 of Oracle PL/SQL. Why? I've been tasked with writing a stored procedure that scrambles data for developers working with some of our databases containing sensitive data. How? SELECT DBMS_RANDOM.option1[(option2)] FROM DUAL; option1 can be: RANDOM VALUE...

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

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

13 September 2012 noted that "It would be quite useful to permit users to 'take back' at least the immediately preceding command (by issuing some special 'undo' command)." Source: Behavioral Issues in the Use of Interactive Systems. If you've guessed it, my vote goes for...

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

UNC Paths in Sharepoint 2007 linkshttps://www.joellipman.com/articles/microsoft/sharepoint/unc-paths-in-sharepoint-2007-links.html

08 November 2012 to Microsoft Office Sharepoint 2007 What? I've been tasked with adding links to files located on some network shares. I want to use UNC paths such as \\myServer\myShare\myFile.doc. I could map the UNC path to a drive letter and then link to it (eg....

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

Trim in T-SQL and SSIShttps://www.joellipman.com/articles/microsoft/ssis/trim-in-t-sql-and-ssis.html

14 May 2013 Some methods of removing trailing spaces, tabs, carriage returns and line feeds (new lines). How? First in Transact-SQL: SELECT RTRIM( REPLACE( REPLACE( REPLACE( @myString, CHAR(9), ''), CHAR(10), ''), CHAR(13), '') ) -- CHAR(9) = Tab -- CHAR(10) = Line...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• 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 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 configuration, does not work! How? It...

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

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 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 Excel...

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

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

20 January 2014 it without a border. You may find that BIDS or Report Builder (however you're building your report) will apply the border to some cells and sometimes a whole section of the report with just one border??? How? In Design view, click on the first cell...

• 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 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 first...

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

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

28 August 2014 And the DJI Phantom FC40 for $500 USD filming at 1280x720 30fps. The YouTube Capture app has blurred some moments and the quality is somewhat reduced. I had switched stabilization off so the video quality is better than what you see on YouTube:...

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

Excel: Extract hyperlink from linkhttps://www.joellipman.com/articles/microsoft/excel/excel-extract-hyperlink-from-link.html

06 November 2014 A quick article on if you want to extract the link from some text you have copied off the web and into an MS Excel document. How? Open up a new workbook. Get into VBA (Press Alt+F11) Insert a new module (Insert > Module) Copy and Paste the Excel user...

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

Error 404 Component Not Found when enabling SEF URLshttps://www.joellipman.com/articles/cms/joomla/404-component-not-found-sef.html

02 September 2015 contact the System Administrator of this site and report the error below. 404 Component not found. Just because I'm doing something like this: How? I found that this was only affecting my subdomains where this template was installed. I installed some...

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

Make bootstrap carousel responsive to swipehttps://www.joellipman.com/articles/web-development/bootstrap/make-bootstrap-carousel-responsive-to-swipe.html

14 December 2016 Feed back was that the user was unimpressed with the image slideshow. You have to tap on the left and right symbols... How? Some will suggest to load the jQueryMobile library but that started messing up the template layouts for me. I really like the...

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

Zoho Deluge - Store and repopulate a multi lookup list in Creatorhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-store-and-repopulate-a-multi-lookup-list-in-creator.html

28 June 2019 the list entries. The lookup needed to filter against various forms such as Staff Rotas, Leave Requests, Qualifications and some others. How? The aim/objective is the following: Store what was already selected in the lookups Clear the lookups list...

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

JComments errors in PHP 7: plgContentJComments and JCommentsACLhttps://www.joellipman.com/articles/cms/joomla/jcomments-errors-in-php-7.html

13 March 2020 return errors when using PHP version 7. This is a quick article to document what needed doing to fix the errors. How? First some errors: ERROR: plgContentJComments Deprecated: Methods with the same name as their class will not be constructors in a...

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