Invalid arguments passed in router.php on line 325https://www.joellipman.com/articles/cms/joomla/invalid-arguments-passed-in-routerphp-on-line-325.html

03 August 2010 firstly I don't want to have to create an account on someone else's forum just to post my answer and secondly because my solution is a "cowboy fix" rather than the other intelligent solutions on the web. The issue was that I was building my first Joomla...

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

SSRS - Lost window with datasetshttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-lost-window-with-datasets.html

25 March 2011 parameters and datasets isn't there. I spent a bit of time enabling/disabling toolbars before I found this. Open a Report solution (or have one open already?) The menu link is "report data" and it's right at the bottom of the "View" menu.

• 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 one day. If the 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....

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

Mouseover Links in AutoHotkeyhttps://www.joellipman.com/articles/automation/autohotkey/mouseover-links-in-autohotkey.html

08 July 2011 the link as blue despite the mouse cursor not being anywhere near it. Proper HTML mouseovers: When I have a more stable solution. I would however recommend cwebpage.dll at as a minimum for internal HTML pages for use in an AutoHotkey GUI.

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

First and Last Entry on a Page using Modulus Remainderhttps://www.joellipman.com/articles/web-development/php/first-and-last-entry-on-a-page-using-modulus-remainder.html

26 September 2011 out of frustration and the inability to know exactly what I'm looking for... always difficult. After a cup of tea the solution was glaringly obvious, just do a primary school mathematics table and it all makes sense (see my 10 mod table below). This...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

Reminder on SSRS row separatorhttps://www.joellipman.com/articles/microsoft/ssrs/reminder-on-ssrs-row-seperator.html

26 October 2011 are using SQL Server Reporting Services (in my case version 2008 R2), then yes, you won't need to use the database level solution and can follow these quick steps: Right-click the grey header of the tablix row (left-most grey part) Select "Add Group"...

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

Strip HTML in MySQLhttps://www.joellipman.com/articles/database/mysql/strip-html-in-mysql.html

06 December 2011 putting a note as I have spent ages looking for a solution and getting it to work in my environment. What? Need to be able to omit HTML tags in certain fields of a mySQL database. Why? We are preparing to migrate old content to a new system. From a...

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

Ordered List of over 1000 Itemshttps://www.joellipman.com/articles/web-development/css/ordered-list-of-over-1000-items.html

08 February 2013 So many people asking this when the solution is a bit of aesthetic styling. ol{margin:4px} -- yields 995. 996. 997. 998. 999. 000. 1000 Ordered list resets to zero after the ninth item Ordered List Maximum

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

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 directory and then loop through the line it finds. Why? I use another technology for automation but sometimes the simpler solution is the one I make for other people to use. Explaining MS-DOS batch programs is a lot easier and colleagues trust these...

• Type: Article
• Author: Joel Lipman
• Category: MS-DOS
• 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 could argue this is a problem with your data but the way I see it is it's a space character and TRIM() should work. My solution Include the space (if there is one) in the substitute formula: =SUBSTITUTE(B3, " ₱", "") The resulting value will still need...

• 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 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, or if a...

• 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 ) FROM Person_Staff ps -- In oracle, yields "missing parenthesis" error. So you can see my parentheses are fine. Working Solution: SELECT ps.person_id, ps.person_name, ( select txt from ( select pa.person_text as txt, pa.person_reference as personid,...

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

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

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

Android Background Image Resolutionshttps://www.joellipman.com/articles/google/androidos/android-background-image-resolutions.html

01 December 2014 1600x2133 (364kb) and was not displaying on smaller devices. Configuring drawables for each layout seemed to be the only solution. res/drawable-ldpi 240x320 res/drawable-mdpi 320x480 res/drawable-hdpi 480x800 res/drawable-xhdpi 640x960...

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

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

14 December 2016 will suggest to load the jQueryMobile library but that started messing up the template layouts for me. I really like the solution (and think it should be voted best answer) put forward by Mark Shiraldi: The code is minimal but does what it needs to do...

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

FTP on Mac: Failed to retrieve directory listinghttps://www.joellipman.com/articles/web-development/ftp/ftp-on-mac-failed-to-retrieve-directory-listing.html

06 October 2018 show. There's a good bit of information from the source link listed below but the settings didn't solve the problem. The solution was to change the options on the mac firewall by going into Settings > Security & Privacy > Firewall Click the lock to make...

• Type: Article
• Author: Joel Lipman
• Category: File Transfer Protocol
• Language: *

Zoho Deluge - Hide Reset Button on Formhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-hide-reset-button-on-form.html

15 November 2018 So another quick note as I couldn't find a solution on the forums. This is to hide the reset button on a non-stateless form (state form?). I have posted this on the Zoho forums as well but here goes: Why? Because I can. And because as someone said, a...

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

COVID-19: Working from Homehttps://www.joellipman.com/covid-19-work-from-home.html

05 July 2020 table, my back is suffering terribly. I figured on a personal DSE assessment and setup my workstation as a more permanent solution. For fun, our office have posted what taking your work home, including the work computer, looks like... I made mine into a...

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

Zoho Finance Suite Schedule: PATTERN NOT MATCHEDhttps://www.joellipman.com/articles/crm/zoho/zoho-finance-suite-schedule-pattern-not-matched.html

12 June 2023 is remove any spaces from the name of the schedule. The longer answer is demonstrated in the following screenshots: Error: Solution

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