After installing rokstories, get invalid argument 106https://joellipman.com/articles/cms/joomla/after-installing-rokstories-get-invalid-argument-106.html

14 January 2010 Warning: Invalid argument supplied for foreach() in /home/.../components/com_content/helpers/route.php on line 106 After googling I found an unlikely solution which is becoming typical of Joomla. I hadn't switched the site to SEF friendly yet but I did...

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

Sort order a dropdown list in MS InfoPath without programminghttps://joellipman.com/articles/microsoft/infopath/sort-order-a-dropdown-list-in-ms-infopath-without-programming.html

21 July 2011 when I made my form dropdown read from the list, it just put elements in the order that I entered them in the datasheet. Googling this led me to browse MSDN for an hour before I realised all those experts were using programming solutions that seemed a...

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

MySQL parameters in Excel 2007 PivotTableshttps://joellipman.com/articles/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

24 August 2011 the title doesn't put you off but after much Googling and Bing-ing, I still couldn't figure out how to do this. Hopefully this article will help you more than my search engine skills do. My Setup Windows XP Workstation...needs to open... Excel 2007 SP2...

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

Add "Command prompt from here" to right-click context menuhttps://joellipman.com/articles/microsoft/windows-os/add-command-prompt-from-here-to-right-click-context-menu.html

27 January 2010 How? I keep having to do this every year as I reghost all my machines (=restore to sorta factory settings), so instead of googling it and going through other websites that work and don't; I thought I might as well post the way I do it: Open up windows...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Border settings not saving in SSRShttps://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

SSRS Parameters in Oracle Stored Procedurehttps://joellipman.com/articles/microsoft/ssrs/ssrs-parameters-in-oracle-stored-procedure.html

02 September 2011 storing a note here because it took a while to figure out and googling other solutions did not answer our questions but did lead us to a workaround. So this is regarding an error when trying to add parameters to a Stored Procedure of an Oracle database...

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

Returning Oracle Stored Procedure Resultset in SSRShttps://joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

19 January 2012 So I've spent a fun time googling and binging but still haven't found a simple and complete example of getting a resultset from an Oracle stored procedure and displaying this in SQL Server Reporting Services (SSRS). Well "non-productive" more than "fun"...

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

Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://joellipman.com/articles/crm/zoho/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

15 May 2020 Creator would like access to bla bla bla and click on "Accept" Get the file URL (ie. the PermaLink) So if you've been googling how to download a file that was uploaded into a Creator form, you may have come across forums that are over 10 years old; URLs...

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

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

05 April 2011 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 how I did it and what worked for me... Set the...

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

Link to a Joomla article from within another articlehttps://joellipman.com/articles/cms/joomla/link-to-a-joomla-article-from-within-another-article.html

04 December 2012 Quick article here as googling/binging for how to refer to Joomla articles after versions 1.5.x wasn't obvious. This article is to demonstrate how to write the webaddress for a Joomla article even when you have Search-engine-friendly website addresses...

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

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

03 June 2014 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 Microsoft...

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