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 tags is required, the following 27 results were found.

  1. Zoho Deluge: Using Remove Key on a Map and Copying Record Tagshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-using-remove-key-on-a-map.html

    A quick article on how to use remove() on a map variable as well as a snippet of code to copy tags from a contact to a deal record. Why? Anything that stumps me for 30 minutes is worth writing a quick article on. In this case, I had a function querying...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  2. Preg_Replace all strings between two tagshttps://www.joellipman.com/articles/cms/website-development/php/preg-replace-all-strings-between-two-tags.html

    Convert: this='some string' » this='some string' $string_formatted = preg_replace ( '/\'([^\']+)\'/e', 'stripslashes(strip_tags("$0"))', $string_formatted ); // really important to suffix the expression with 'e' $string_formatted = preg_replace (...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *
  3. Zoho Creator: Public URL of an Image field / Upload to Shopify APIhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-public-url-of-an-image-field-upload-to-shopify-api.html

    m_Image.put("attachment",v_EncodedImg); l_AllImages.add(m_Image); } } m_Product.put("images",l_AllImages); } // // shopify tags l_Tags = input.Tags; m_Product.put("tags",l_Tags); // // JSON product request m_CreateRecord = Map();...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  4. PHP & MySQL Search Enginehttps://www.joellipman.com/articles/cms/website-development/php/php-a-mysql-search-engine.html

    and apostrophes may be an issue; Full PHP: $sanitized_search=(isset($_GET['search'])&&($sanitized_search==""))?trim(strip_tags(addslashes($_GET['search']))):""; # 2 functions to split up search terms and accepting double-quotes as phrase makers....

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  5. Zoho Deluge: Generate List of TimeZoneshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-generate-list-of-timezones.html

    the double-quotes, then prepend with a list declaration and append with a end of list suffix; loop through removing HTML tags and while we're at it, storing it in a list for Zoho Deluge: First of all, here's the HTML SELECT dropdown I just nabbed from...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  6. Migrating from Joomla 2.5.x to 3.4.xhttps://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

    = @v34_admin_id; UPDATE `v34_db`.`v34_content` SET `modified_by` = @v25_admin_id WHERE `modified_by` = @v34_admin_id; -- Tags: UPDATE `v34_db`.`v34_tags` SET `created_user_id` = @v25_admin_id WHERE `created_user_id`= @v34_admin_id; UPDATE...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  7. Joes Quicklist Weblinks (JQW) Downloadshttps://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=105&Itemid=165

    code. - Enhancement: Made popup span tag exclusive. - Enhancement: Date is now "created" date. - Enhancement: Included span tags for individual elements. - Enhancement: Using div layers instead of tables. - Fixed Bug: Switched CSS ID tag to CLASS for...

    • Type: Article
    • Author: Joel Lipman
    • Category: Downloads
    • Language: *
  8. Strip HTML in MySQLhttps://www.joellipman.com/articles/else/database/mysql/strip-html-in-mysql.html

    as I have spent ages looking for a solution and getting it to work in my environment. What? Need to be able to omit HTML tags in certain fields of a mySQL database. Why? We are preparing to migrate old content to a new system. From a MediaWiki CMS to a...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  9. GDPR Privacy Policyhttps://www.joellipman.com/component/content/article/gdpr-privacy-policy.html?catid=50&Itemid=165

    • Type: Article
    • Category: Static Items
    • Language: *
  10. Joes Syntax Styler (JSS)https://www.joellipman.com/component/content/article/joes-syntax-styler-jss.html?catid=53&Itemid=165

    solution? So here I am making my own again. I wanted something really basic that simply lets me style content within the tags: Use PHP or JavaScript (avoiding Framework conflicts) You select what words are highlighted what color. Uses separate CSS file...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  11. Zoho Deluge - Some Useful Regular Expressionshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-some-useful-regular-expressions.html

    \& \ Sidekick \(1\) v_FormattedString = v_MyString.replaceAll("%"),"\u0025",true); The following will strip all HTML/XML tags: v_MyString = "Hello World 123"; v_MyFormattedString = v_MyString.replaceAll("",""); // yields Hello World 123 URL safe slug:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  12. Zoho Creator: info/alert/modal/popup notification for any userhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

    would need to apply specifically to the contents in the popup. Find the modal or popup name to isolate these from other CSS tags sharing the same name. Alternative Solution Some of you may be asking why not use openUrl with a popup parameter, such as:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  13. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL)https://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-shopify-api-integration-oauth-2-0-update-2022.html

    use to store details about a product, and then to push that product out to their Shopify store with a pre-built description, tags and inventory details. This means the app needs to be able to sync all of its products, customers, and orders with Shopify...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  14. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRMhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-zohowriter-generate-rich-email-signatures-in-crm.html

    = ""; v_Logos_PartnersHTML = ""; // // the generic signature for all users with merge fields enclosed with square tags: v_RecodedSignature = " [AB-StaffName] [AB-JobTitle] [AB-MobilePhone] [AB-Email] www.joellipman.com " + v_Icon_TwitterHTML + " " +...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  15. Zoho CRM: JS Widget: Generic Script to pass the Record ID to a CRM functionhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-js-widget-generic-script-to-pass-the-record-id-to-a-crm-function.html

    and using CoPilot or OpenAI ChatGPT for parsing the return value of the function (note that I have SCRIPT within the BODY tags and not in the HEAD): Loading... Please Wait... console.clear(); ZOHO.embeddedApp.on("PageLoad", function(r_Data) { // for...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  16. ZohoBooks: Broken UK Banking Feedhttps://www.joellipman.com/articles/crm/zoho/zoho-books/zohobooks-broken-uk-banking-feed.html

    From 2024 onward, Zoho migrated UK accounts to Open Banking connections handled by Plaid. The “via Plaid” or “via Yodlee” tags no longer appear in the UK interface; instead, you’ll see the bank listed as “& Country (United Kingdom).” Deleting accounts:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  17. Upgrading a Joomla 1.5 module to Joomla 2.5https://www.joellipman.com/articles/cms/joomla/upgrade-a-joomla-1-5-module-to-joomla-1-6.html

    /language/en-GB/en-GB.mod_moduletoupgrade.ini Upgrade XML File: Change open/close tags to (update attributes, eg. ) Change to Change to Change all

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  18. Mediawiki Extension for Camtasia Studio SWF videoshttps://www.joellipman.com/articles/cms/mediawiki/mediawiki-extension-for-camtasia-studio-swf-videos.html

    final code to the wiki } Amend your skin files Amend your skins to include the reference to this script in between the head tags of every page, so Amend your LocalSettings.php file Add the following the the LocalSettings.php file in your mediawiki root...

    • Type: Article
    • Author: Joel Lipman
    • Category: MediaWiki
    • Language: en-GB
  19. T-SQL: Parse an XML valuehttps://www.joellipman.com/articles/else/database/t-sql/t-sql-parse-an-xml-value.html

    Y INSERT 2014-03-27 Extracting the Gender: We're going to extract the value in between the opening and closing XML tags: -- Using .query() SELECT CAST(CAST(Event_XML AS XML).query('data(/STAFF/GENDER)') AS VARCHAR(10)) AS Gender FROM [dbo].[XML_EVENTS]...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  20. Quickly update all content in mySQL database replacing a stringhttps://www.joellipman.com/articles/else/database/mysql/quickly-update-all-content-replacing-a-string.html

    modifying other data such as modified date and author. Why? I used to have a third-party plugin that would replace my HTML tags with . Not I want to switch these back. How? For demo purposes, I'm searching a column called introtext in a database table...

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