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

14 January 2010 if I clicked on one of the articles (rokstory), I would get a page with the article on it but with the following error (3x) above it: Warning: Invalid argument supplied for foreach() in /home/.../components/com_content/helpers/route.php on line 106...

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

Increment a column in MySQL using the UPDATE queryhttps://www.joellipman.com/articles/database/mysql/increment-a-column-in-mysql-using-the-update-query.html

18 February 2010 value of the counter - eg. times an article has been displayed). Basically what I used to do is something similar to the following: SELECT counter_field_value FROM table1 WHERE column1='this_article' Add 1 to counter_field_value UPDATE table1 SET...

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

Joomla - How to preview module positions in a given templatehttps://www.joellipman.com/articles/cms/joomla/joomla-how-to-preview-module-positions-in-a-given-template.html

02 April 2010 out where the positions are, like USER 1 and TAB 4 etc..." To open a web-browser window or tab with this preview, type the following in the address bar after your website URL: http://www.yourdomainname.com/index.php?tp=1&template=thetemplatename where...

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

SSRS Report Builder 2.0 - Error during processinghttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-report-builder-20-error-during-processing.html

06 May 2010 The Issue After modifying a report and on running it, Report Builder 2.0 returns the following error: An error occurred during local report processing. An error has occurred during report processing. Query execution failed for dataset 'DataSet1'. The...

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

If Then Else in Report Builder 2.0 Expressionshttps://www.joellipman.com/articles/microsoft/ssrs/if-then-else-in-report-builder-20-expressions.html

06 May 2010 Google properly. Anyway here's just a quick note on how to do if else statements in Report Builder 2.0 I'm looking at the following if statement: If (MyFieldName = 0) Then Return 1 Else Return MyFieldName Can be expressed as:...

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

SSRS Use T-SQL Like with a Parameterhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-use-t-sql-like-with-a-parameter.html

04 April 2011 fast for it to auto-scroll down to the desired name. Our advanced users are exceptions to the rule. Problem Consider the following query: SELECT rb.[GivenDate] , rb.[DateStart] , rb.[DateFinish] , rb.[ContactUsername] , rb.[ContactName] , rb.[Room] ,...

• 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 query. The function that did work errored persistently complaining about the delimiter, create the function by running the following: SET GLOBAL log_bin_trust_function_creators=1; DROP FUNCTION IF EXISTS fnStripTags; DELIMITER | CREATE FUNCTION...

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

MediaWiki: MySQL to extract path to imageshttps://www.joellipman.com/articles/cms/mediawiki/mediawiki-mysql-to-extract-path-to-images.html

06 December 2011 the last export but then needed to send all images that had also been either added/modified since. How? Using MySQL, the following query lists the image name, size, user who uploaded, timestamp and the path. Remember that the paths are determined using...

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

Drop If Object Existshttps://www.joellipman.com/articles/database/t-sql/drop-if-object-exists.html

03 August 2012 go, I hope it's of some use. If it's wrong then just post a comment at the bottom of this page. Go go go Note that in the following examples, I'm checking under the [Common] schema, this might be [dbo] for you or a more specific one. -- drop a stored...

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

Joomla field types clear my htmlhttps://www.joellipman.com/articles/cms/joomla/joomla-field-types-clear-my-html.html

09 August 2012 Content Management System (CMS - phew what a mouthful) Joomla! version 1.6.x to 2.5.x; no wonder customers have difficulty following. How? So it's the field on the XML file /models/forms/whatever.xml which needs the filter=raw attribute, for example:...

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

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

13 September 2012 note and more of a personal opinion then factual, but beyond the inventors of the Internet or any hardware has to be the following notion from IBM: a 1976 research report by Lance A. Miller and John C. Thomas of IBM, noted that "It would be quite useful...

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

Leap Motion and AR Dronehttps://www.joellipman.com/articles/_other-misc/quadcopters/leap-motion-and-ar-drone.html

17 May 2013 It's noted for it's accuracy and response to finger gestures and it's compatibility with major platforms. The following videos were shown to me by a colleague at work. I was so impressed I just had to post them. So here's a screenshot, read more if you...

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

Joomla Development: Possible XML Filtershttps://www.joellipman.com/articles/cms/joomla/joomla-development-possible-xml-filters.html

17 October 2013 to be alphanumeric (Letters and numbers only. No special characters) CMD Forces the value to be alphanumeric plus the following three special characters _ (underscore) . (dot) - (dash) BASE64 Forces the value to be a base64 encoded the string. Note 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 conversion rate, it returns #VALUE! How? The problem is that I have a column which includes the currency symbol as per the following image: I create another column with the symbol omitted using the formula: =SUBSTITUTE(B3, "₱", "") Which leaves the...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• 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 I get this error when having to use an ORDER BY clause in a subquery within an Oracle 11g environment. How? Consider the following: SELECT ps.person_id, ps.person_name, ( select pa.person_reference as personid, pa.person_text as txt from Person_Academia...

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

Regular Expressions in SQLhttps://www.joellipman.com/articles/database/regular-expressions-in-sql.html

09 January 2014 is a start. This article serves as a quick note on how to use regular expressions within SQL statements: How? For the following examples, I am pretending to select rows from a table called `STUDENTS`. Oracle PL/SQL Looking for abnormal data, note the...

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

Two icons created on Androidhttps://www.joellipman.com/articles/google/androidos/two-icons-created-on-android.html

20 October 2014 stumped for a bit until I found it on the a forum: Stack Overflow: Android App Development. How? Basically don't have the following declared more than once in the AndroidManifest.xml

• Type: Article
• Author: Joel Lipman
• Category: AndroidOS
• 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 reset button (usually "zc-live-secondary-btn") Add a notes field to your form Click on the HTML button to add HTML Add the following HTML: .zc-live-secondary-btn{display:none;} Done

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

Zoho Inventory Template Issue: First Page is Blankhttps://www.joellipman.com/articles/crm/zoho/zoho-inventory-template-issue-first-page-is-blank.html

15 November 2018 HTML knowledge as well... ahem... well in this particular case CSS... so maybe this will help others: The culprit is the following CSS line: page-break-inside:avoid // change to page-break-inside:auto Resolution Find the CSS attribute...

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

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 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 Restore what was originally selected as selected....

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