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

03 August 2010 Thought I'd put this error in here and how I fixed it. Basically because 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...

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

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

23 February 2011 We want the report to open with the specified day expanded and the remaining days that week to be collapsed (hidden). The first time I did this, I couldn't expand the remaining days so don't forget to tick the option "display can be toggled by this...

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

Code Troubleshooting Checklisthttp://mail.joellipman.com/articles/web-development/code-troubleshooting-checklist.html

03 June 2011 that ("working backward") If the problem is abstract, try examining a concrete example. Try solving a more general problem first.

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

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

26 October 2011 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... obviously). I...

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

MySQL day of week ending on Fridayhttp://mail.joellipman.com/articles/database/mysql/mysql-day-of-week-ending-on-friday.html

26 April 2012 didn't get me very far until I decided to write this article: DAYOFWEEK(myDate, 1) or WEEKDAY(mydate, 1) MySQL code for first and last day of week. Day of Week starting on Monday.

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

Trim in T-SQL and SSIShttp://mail.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

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

03 October 2013 FOR /F "tokens=2,3* delims=_" %%A IN ('DIR InitializingFile*') DO ECHO %%A -- yields: 123.csv 456.csv So that's our first loop, here's what the second loop should do: -- the following loops through a line and separates by period (.) FOR /F "tokens=1,2*...

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

Regular Expressions in SQLhttp://mail.joellipman.com/articles/database/regular-expressions-in-sql.html

09 January 2014 -- REGEXP_SUBSTR('oracle', 'o r a c l e', 1, 1, 'x') Microsoft T-SQL Note the circumflex/hat to negate the expression in the first example, and then the use of NOT LIKE in the second example: SELECT * FROM [STUDENTS] WHERE [S_SURNAME] LIKE...

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

SSRS Border Problemhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-border-problem.html

20 January 2014 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 (top-left), hold down the shift key and click on the last cell (bottom-right). This selects all cells. Now open the...

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

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

08 April 2014 types of results: Success, Failure, Unknown. My images are circles with the background being transparent. I want the first column to display an image based on the status result. If I simply insert an image, the report would use the background color of...

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

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

08 August 2014 How? I had this in my training environment but not in my development environment. I had to create a Data Exchange Format first: Run the DEF from the menu Clear and create a new one based on the following: Now you can go and retrieve a student/staff...

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

Joes Transmission Detector (JTD) Downloadshttp://mail.joellipman.com/component/content/article/joes-transmission-detector-jtd-downloads.html?catid=92

07 September 2015 minimize - Background made transparent - Added received/sent data graph progress bars - Listview rolls messages (deletes first one and adds to last) - Date Uploaded: Thu, 29th Sep 2011 Download

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

Zoho Deluge: Convert Map to URL Parametershttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-convert-map-to-url-parameters.html

09 March 2020 article on converting a Map (associative array with keys and values) into a URL string to pass as URL parameters. How? Let's first define a map: m_Payload = Map(); m_Payload.put("client_id","my-unique-client-id");...

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

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

13 March 2020 would 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: *