Advanced Search

Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming either is required, the following 79 results were found.

  1. Licence GNU/GPLhttps://www.joellipman.com/component/content/article/licence-gnugpl.html?catid=50&Itemid=165

    work is called a “modified version” of the earlier work or a work “based on” the earlier work. A “covered work” means either the unmodified Program or a work based on the Program. To “propagate” a work means to do anything with it that, without...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  2. SSRS Querying on either of 2 Parametershttps://www.joellipman.com/component/content/article/ssrs-querying-on-either-of-2-parameters.html?catid=75&Itemid=165

    not - note the DBMS is not hugely relevant for the purposes of this article). The end-user must be able to search on EITHER the student's username or the student's ID (2 report parameters: @StudentADAccount [varchar] and @StudentReference [int]...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  3. ZohoCRM: Make either Mobile or Email mandatoryhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-make-either-mobile-or-email-mandatory.html

    What? A really quick article on a pretty cool requirement, making 2 fields mandatory but if one is completed then making the other optional. Why? My use-case is that the mobile or email field on a Zoho CRM contact record is used to authenticate the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  4. Zoho Deluge - Get Refresh/Access Token API v2https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-refresh-access-token.html

    an authtoken v1 (CRM Deprecation Sunset Date: 31st December 2019). Go to the Zoho Developer Console Create a Zoho Client ID Either use self-client for a code or use the below to generate one. Code Here you will need your own client ID and client secret...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB
  5. Zoho Projects: Add a Time Log to an Issue using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-projects/zoho-projects-add-a-time-log-to-an-issue-using-deluge.html

    format "HH:mm" (eg. "34:06" = 34 hours and 6 minutes). Error(s) Input Parameter Missing (6831): Can happen when there are either too many parameters or one is missing. Instead of abiding by the API documentation which was out of date at time of print,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Projects
    • Language: *
  6. Keyboard and mouse shortcuts in Google Chromehttps://www.joellipman.com/component/content/article/keyboard-and-mouse-shortcuts-in-google-chrome.html?catid=61&Itemid=165

    Click a tab with your middle mouse button (or mousewheel). Closes the tab you clicked. Right-click, or click and hold either the Back or Forward arrow in the browser toolbar. Displays your browsing history in the tab. Press Backspace, or Alt and the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  7. Apple Magic Trackpad with Windows 11 Intelhttps://www.joellipman.com/component/content/article/apple-magic-trackpad-with-windows-11-intel.html?catid=80&Itemid=165

    MS Windows 11 pro already. Wifi was ok to connect and my Microsoft Office apps, well it's a Windows box so no issues there either... Webcam and headset previously connected to my docking station weren't too much of an issue either as MS Windows detected...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  8. T-SQL Record Separatorhttps://www.joellipman.com/articles/else/database/t-sql/t-sql-record-separator.html

    I mentioned at the beginning of this article, I am comparing on Day names. The above query generates a last column which is either empty or says "Separator Marker". Based on the CTE above, I now need to add an actual row separating the different days...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  9. Joes FREE Website Thumbnailer (JWT)https://www.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=53&Itemid=165

    for scripts, programs and extensions to existing web-development systems. I use it to store notes that other websites either do not have or have stopped providing, or just because it's easier for me. This program can be downloaded by visiting...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  10. Joes DNS Correction (JDC)https://www.joellipman.com/component/content/article/joes-dns-correction2.html?catid=53&Itemid=165

    item from TFS and before I get to update it, my connection will drop and my computer will say that it could not connect to either the TFS or my target deploy location. I found a quicker fix than rebooting your computer which is to open a command prompt...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  11. Zoho Creator: Two submit buttons on a non-stateless form with 2 different redirectshttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-two-submit-buttons-on-a-non-stateless-form.html

    () to the page won't help as you need to submit the form before redirecting the user. A HTML element to the page won't help either as you need to redirect the user to the specified report after submitting the form. How? Well as always, I'm going to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  12. Zoho Analytics & Zoho People: Monitor DataSource Sync https://www.joellipman.com/articles/crm/zoho/zoho-analytics/zoho-analytics-zoho-people-monitor-datasource-sync.html

    + ifnull(m_DataSourceInfo.get(v_DataSourceKey),"?") + " "; } } else { v_Message = v_Message + " No Datasource Information! Either the data source synchronization has been switched off or there is an error with a connection account between Zoho People...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  13. Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Templatehttps://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-books-estimates-quotes-accept-decline-buttons-on-template.html

    then done. One of the biggest hurdles here, which may sound trivial, was the response when an end customer clicks on either the accept or decline button. Using ZohoFlow or other Zoho app for a webhook response, would result in the end customer suddenly...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  14. Community Builder in Joomla Vulnerabilityhttps://www.joellipman.com/articles/cms/joomla/community-builder-in-joomla-vulnerability.html

    domain as they love playing this about and giving all russians a bad name on the net. If you visit your site and receive either the above error or the alert that a malware was detected: congratulations! you've been hacked. So first of all check that...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  15. Setting up your store to use SSLhttps://www.joellipman.com/articles/else/e-commerce/setting-up-your-store-to-use-ssl.html

    To setup your store to use SSL (Secure Socket Layer) you will first need an SSL certificate. Many hosting companies will either provide (or can offer) "Shared SSL" or the option to buy a "Dedicated SSL" certificate. Shared SSL means that your store...

    • Type: Article
    • Author: Joel Lipman
    • Category: eCommerce Systems
    • Language: *
  16. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/component/content/article/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html?catid=74&Itemid=165

    a mixture of mostly lowercase and some UPPERCASE. Why? I'm writing this article because other solutions on the net were either incomplete, did not work for me or simply did not match the requirements (do they ever?). The script must be able to be copied...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  17. SSRS Hide results table if emptyhttps://www.joellipman.com/component/content/article/ssrs-hide-results-table-if-empty.html?catid=75&Itemid=165

    my end-users to have faith in my report. The report just returning blank can also mean "I don't know". I want the report to either return the correct value or say "No data found". My end-users would otherwise ask is the data value reliable if it's...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  18. Regular Expression Basic Usage Exampleshttps://www.joellipman.com/articles/cms/website-development/regular-expression-basic-usage-examples.html

    List You use the matching character list to search for an occurrence of any character in a list. For example, to find either 'a', 'b', or 'c' use the following regular expression: [abc] This expression matches the first character in each of the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  19. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPUhttps://www.joellipman.com/component/content/article/pc-build-2022-5-monitors-connected-to-1-pc-using-1-gpu.html?catid=45&Itemid=165

    it (I had no idea whether my motherboard supported it as it kept talking about AMD Crossfire/NVidia SLI and I'm doing neither). But that didn't work, then I found you need to do an extra step in your Windows OS... Now for the BIOS: Restart your PC While...

    • Type: Article
    • Author: Joel Lipman
    • Category: Articles
    • Language: *
  20. Write a Calendar in Autohotkeyhttps://www.joellipman.com/component/content/article/write-a-calendar-in-autohotkey.html?catid=48&Itemid=165

    a mix between HTML and autohotkey syntax (note we're making a table with 9 columns and 6 rows - there's a spacing column on either side): htmlText:="" htmlText:=htmlText " " htmlText:=htmlText "" htmlText:=htmlText " " htmlText:=htmlText " M "...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
Results 1 - 20 of 79