Licence GNU/GPLhttps://joellipman.com/static-items/licence-gnugpl.html

03 April 2009 “Licensees” and “recipients” may be individuals or organizations. To “modify” a work means to copy from or adapt all or part of the work in a fashion requiring copyright permission, other than the making of an exact copy. The resulting work is called a...

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

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

26 October 2011 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" then "Parent Group..." Specify the "Group by" (in my case "Day"), the grey part will display a grouping...

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

Improve Default Joomla Search https://joellipman.com/articles/cms/joomla/improve-default-joomla-search-heuristics.html

07 May 2013 Joomla search into par with Google and Wikipedia (or near enough). How? I'd like to use various techniques, and the first part of this article (Stage 1) is the only part you need to modify as this will improve your Joomla search results by giving...

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

Migrate Joomla! 1.5.x to 2.5.x+https://joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 the single script "migrate_j15_to_j25_new_v1_8.sql" For larger sites (~200'000 articles), then you will need to use the 3-part script "migrate_j15_to_j25_new_v1_6_pt1.sql", "migrate_j15_to_j25_new_v1_6_pt2.sql", "migrate_j15_to_j25_new_v1_6_pt3.sql"....

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

Zoho Deluge: Search Records with Special Characters (COQL)https://joellipman.com/articles/crm/zoho/zoho-deluge-search-records-with-special-characters-coql.html

28 August 2020 2. Determine the client datacenter Look at the URL (website address) of the CRM you are wanting to do this on. The part after Zoho is the top level domain (TLD) and will be either .COM, .EU or as per your region. If the first part of your URL says:...

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

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

09 March 2020 v_ReturnedUrl = "https://api.joellipman.com/myapi?isAuthSuccessful=true&code=my_own_code&expires_in=299"; l_ReturnedUrlParts = v_ReturnedUrl.subString(v_ReturnedUrl.indexOf("?")+1).toList("&"); m_UrlParams = Map(); for each r_Part in l_ReturnedUrlParts...

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

GDPR Privacy Policyhttps://joellipman.com/static-items/gdpr-privacy-policy.html

14 February 2019 on consumer privacy while delivering amazing experiences. Think of it as experiential privacy — having privacy as a key part of the customer experience, through relevant privacy notices presented in context and choices that are on brand. More info about...

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

Report Builder 2.0 - Hide Series1https://joellipman.com/articles/microsoft/ssrs/report-builder-20-hide-series1.html

06 May 2010 To Full Name] '' Note that this excludes all the data that doesn't have a matching label. Which can be a major part of your charts if this is a normal part of your database. In my example, the team members could have changed and that a person doing most...

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

SSRS Dropdown parameter cannot be blank!https://joellipman.com/articles/microsoft/ssrs/ssrs-dropdown-to-allow-blank-values.html

14 December 2011 #3 parameter cannot be blank!". Before you ask, I have ticked both "Allow Blank" and "Allow NULL". How? This is the tough part. I was reading up on the MSDN page for the closest solution but it still didn't work for me. But the idea of inserting a NULL...

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

No rows returned in Oracle causes SP to failhttps://joellipman.com/articles/database/pl-sql/no-rows-returned-in-oracle-causes-sp-to-fail.html

24 January 2012 ORA-06512: at "BASETABLEOWNER.MY_STUPID_PROCEDURE", line 56 ORA-01403: no data found ORA-06512: at line 1" error Failing part of the stored procedure: -- the version of the first query which would fail the stored procedure SELECT...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

Google Authentication - OAuth 2.0 using PHP/cURLhttps://joellipman.com/articles/google/google-authentication-oauth-2-0-using-php-curl.html

31 October 2018 Google Authentication process and if you store the credentials in a file, then the JWT is also in the file. A JWT is a three part value delimited by a period/dot. Base64 decode the second part and this will reveal the user's name and email (along with...

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

Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

02 February 2019 prompt for a user. Again this script doesn't need the client libraries, composer, vendor, etc. Why? This took me the best part of a month to get working. It is taken from Google's documentation as well as other forums and websites that try to explain...

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

Zoho Deluge: Setup an API Connection for InvokeURLhttps://joellipman.com/articles/crm/zoho/zoho-deluge-setup-an-api-connection-for-invokeurl.html

12 August 2020 Deluge: Get Refresh/Access Token API v2 (Zoho to Zoho service) and different to my Zoho CRM: APIv2 using PHP & cURL (3rd-Party to Zoho), in that this details how to setup a connection to use in an invoke URL statement. Specifically for Zoho Books,...

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

Zoho Inventory & eBay Picture Services: UploadSiteHostedPictureshttps://joellipman.com/articles/crm/zoho/zoho-inventory-ebay-picture-services-uploadsitehostedpictures.html

31 March 2022 Standalone Click on Create Give it the parameter/argument p_InventoryitemID as an Integer/Long/Number datatype As the first part of your code, enter the following as code (you'll need to speify your own App Owner and App Name): // //...

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

Zoho Creator: Embed Forms/Reports on a Pagehttps://joellipman.com/articles/crm/zoho/zoho-creator-embed-forms-reports-on-a-page.html

05 May 2022 set the parameters of the form/report. Then this shows how to embed using a DIV layer which allows for CSS styling. The last part shows how to embed using an IFRAME tag which isn't great for CSS styling as you can't do cross-dom acoss child iframes; but...

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

Terms & Conditionshttps://joellipman.com/static-items/terms-conditions.html

30 May 2009 this website is for your general information and use only. It is subject to change without notice. Neither we nor any third parties provide any warranty or guarantee as to the accuracy, timeliness, performance, completeness or suitability of the...

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

Copyrighthttps://joellipman.com/static-items/copyright.html

30 May 2009 and its content is copyright of Joel Lipman .Com © 1999 - 2009. All rights reserved. Any redistribution or reproduction of part or all of the contents in any form is prohibited other than the following: you may print or download to a local hard disk...

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

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

23 September 2009 prompted, type a search term, and press Enter. Performs a search using the search engine associated with the URL. Type the part of a URL between 'www.' and '.com', then press Ctrl+Enter. Adds www. and .com to your input and open the resulting URL. Type...

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

Write a Calendar in Autohotkeyhttps://joellipman.com/articles/automation/autohotkey/write-a-calendar-in-autohotkey.html

27 January 2010 an offline version in the GUI. To display the following code in this website though, I've had to omit a lot of the HTML part. This is the code in full; apologies for the mess coding but it's a mix between HTML and autohotkey syntax (note we're making a...

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

Webdeveloper-Speakhttps://joellipman.com/articles/web-development/webdeveloper-speak.html

13 July 2010 others but this one's got that "kiwi" approach) A few terms I wanted to list up: "above the fold" or "before-the-scroll" The part of a webpage that is visible in the web browser window when the page first loads is described as being ‘above-the-fold’....

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