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 Mine was generated by "http://www.notwebdesign.com/joomla-component-creator/". I don't need one because although I rely on data submitted through the forms ($_GET array), all the submitted data on the front-end of my component is controlled and not...

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

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

25 March 2011 Development Studio 2008 Often happens to me and not sure why. You open the project and the window panel for the Report Data containing the parameters and datasets isn't there. I spent a bit of time enabling/disabling toolbars before I found this. Open a...

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

Select unique values in Microsoft Excel columnhttp://mail.joellipman.com/articles/microsoft/excel/select-distinct-values-in-microsoft-excel-column.html

03 July 2012 excludes the blank/empty cells. Display all Unique Found this note on one of Microsoft Help sites: Office 2010: Select the data range to do this to. Click on the "Data" tab. Click on "Advanced" (Advanced Filter). Tick the "Unique records only" box. A...

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

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

21 August 2012 How to use the randomization features 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)]...

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

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

15 April 2014 IIF (if-then-else) statement displays "#Error". You should get errors referring to converting strings to dates and incorrect data types. How? The fix is to simply get the field and both results to be of the same data type:...

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

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

07 September 2015 VersionPlatform ChangeLogOptions1.0- Read data packets without causing network traffic - Display program used to open port - Disallow program minimize - Background made transparent - Added received/sent data graph progress bars - Listview rolls...

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

Upgrading Joomla CMS version 3.x to Joomla CMS 5.xhttp://mail.joellipman.com/articles/cms/joomla/upgrading-joomla-cms-version-3-x-to-joomla-cms-5-x.html

04 February 2025 I'm used to doing this without any third-party extensions. I strongly recommend you do a backup beforehand of the database and of all your files Why? I keep getting complaints that my server wants to upgrade my PHP v7.x to PHP v8.x. I also get...

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

Disclaimerhttp://mail.joellipman.com/static-items/disclaimer.html

30 May 2009 without limitation, indirect or consequential loss or damage, or any loss or damage whatsoever arising from loss of data or profits arising out of, or in connection with, the use of this website. Through this website you are able to link to other...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Keyboard and mouse shortcuts in Google Chromehttp://mail.joellipman.com/articles/google/keyboard-and-mouse-shortcuts-in-google-chrome.html

23 September 2009 navigate to different buttons on the toolbar. Ctrl+Shift+J Opens Developer Tools. Ctrl+Shift+Delete Opens the Clear Browsing Data dialog. F1 Opens the Help Center in a new tab (our favorite). Address bar shortcuts Use the following shortcuts in the...

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

Remove write-protect from USB pen in Windowshttp://mail.joellipman.com/articles/microsoft/windows-os/remove-write-protect-from-pen-in-windows.html

13 April 2010 16Gb one but my 32Gb ones have all failed at some point. I went for a cheap one on Play.com (Verbatim 32Gb@£49.99 & Kingston DataTraveler@?) and an even cheaper one on Ebay.com (Leather 64Gb@£29.99). In hindsight, the Ebay one was obviously going to...

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

Crystal Reports: Exporting to Excel omits column headershttp://mail.joellipman.com/articles/microsoft/excel/crystal-reports-exporting-to-excel-omits-column-headers.html

03 June 2010 to it working: Checked all headings text boxes are aligned to one gridline and they're the same height. Checked all data field text boxes are aligned and the same width as their respective column heading. Remove any ruler gridlines that don't truly...

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

Error during processing - Converting Date/Timehttp://mail.joellipman.com/articles/database/t-sql/error-during-processing-converting-datetime.html

13 July 2010 was An error occurred during local report processing. An error has occurred during report processing. Cannot read the next data row for the dataset DataSet1. Conversion failed when converting date and/or time from character string. Basically I had to...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

K2 Items disappearhttp://mail.joellipman.com/articles/cms/joomla/k2-items-disappear.html

27 August 2010 on line 145 So I checked these pages and the error is at a foreach() line where it's pulling data from the database. I asked to see the jos_k2_items table and it returned the following error: #145 - Table './jos_k2_items' is marked as crashed and should...

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

UTF8 Unicode PHP MySQL for International Charactershttp://mail.joellipman.com/articles/web-development/php/utf8-unicode-php-mysql-for-international-characters.html

22 October 2010 The Joomla! articles were displaying the correct characters for that language set. I needed to make my extension read data from a MySQL database and display the caracters as intended with UTF8. I tried enough extensions and forum solutions, and although...

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

Merge the content of two similar tables in MySQLhttp://mail.joellipman.com/articles/database/mysql/merge-the-content-of-two-similar-tables-in-mysql.html

11 January 2011 of SomeoneElse.com Obviously the two above tables are very similar with different column names. I also don't want the data to produce double the number of columns. My Solution SELECT title, intro FROM ( SELECT `title`, `introtext` intro FROM...

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

Room Availability Calendar in Business Intelligence Development Studiohttp://mail.joellipman.com/articles/microsoft/ssrs/room-availability-calendar-in-business-intelligence-development-studio.html

23 March 2011 wizard here but without it just add a matrix with [time] in the "column" and [room] in the "row" and [note/status] in the "data" cells. 2. Use the SQL code above: So you can paste this straight into the textarea or use "Query Builder". 3. Select Matrix...

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

Inserting incremental weeks in MySQLhttp://mail.joellipman.com/articles/database/mysql/inserting-incremental-weeks-in-mysql.html

15 April 2011 Situation: I have a silly database table (not mine) storing CMIS Facility week numbers and their starting dates. For those of you unfamiliar with this system, the reason week numbers are different to normal people's week numbers is because these are...

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

Run commands for Windowshttp://mail.joellipman.com/articles/microsoft/windows-os/run-commands-for-windows.html

05 July 2011 Setup Wizard netsetup.cpl Notepad notepad Nview Desktop Manager (if installed) nvtuicpl.cpl Object Packager packager ODBC Data Source Administrator odbccp32.cpl On Screen Keyboard osk Opens AC3 Filter (if installed) ac3filter.cpl Outlook Express msimn...

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

Joes Bug Tracker (JBT)http://mail.joellipman.com/component/content/article/joes-bug-tracker-jbt.html?catid=40

07 July 2011 tools and instead have built a back-end Joomla! administration component that only works in MS Internet Explorer; any database hacks or FTP file uploads immediately corrupt this component. The component itself is sort of good, but file description has...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Before and After, Highs and Lowshttp://mail.joellipman.com/articles/microsoft/ssrs/before-and-after-highs-and-lows.html

03 August 2011 yesterweek, yestermonth, yesteryear and do the layout in PHP. Now let's say I have one RDL or SSRS Solution. I could do a dataset per SQL query but it doesn't seem that ideal. In Theory: SELECT ItemName, DATEPART(dayofyear, ItemDate) as DayOfYear,...

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