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

  1. Error 1065: Query was Emptyhttps://joellipman.com/articles/database/mysql/error-1065-query-was-empty.html

    are entered in the data. Those who are security-conscious will also make their system escape apostrophes (') and double-quotes ("). But who can honestly build a system that thinks of everything from day one? How? Check all required values to escape have...

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

    strings Convert: Hello World! » Hello World! $startPoint = ''; $endPoint = ''; $string_formatted = preg_replace('#('.preg_quote($startPoint).')(.*)('.preg_quote($endPoint).')#si', '$0', $string_original); Replace all @words Convert: Hello @World »...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *
  3. Improve Default Joomla Search https://joellipman.com/articles/cms/joomla/improve-default-joomla-search-heuristics.html

    if word is twice then 2000pts) // + 60 pts if in introtext // + 40 pts if in fulltext $sql_keyword = strtolower(trim($db->Quote($db->escape($text, true), false))); $query->select(' (1000*((LENGTH(TRIM(a.title)) - LENGTH(REPLACE(LOWER(TRIM(a.title)),...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  4. Zoho CRM REST API: Stop Workflow from Triggeringhttps://joellipman.com/articles/crm/zoho/zoho-crm-rest-api-stop-workflow-from-triggering.html

    options but I'm listing the one(s) to stop workflows below to see if this helps anyone: Stop Workflows from executing: l_Quotes = List(); l_Quotes.add(m_CreateCrmQuote); m_Data = Map(); m_Data.put("data",l_Quotes); l_Triggers = List();...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  5. ZohoCRM: zoho.crm.searchRecords only returns certain recordshttps://joellipman.com/articles/crm/zoho/zohocrm-search-records-only-returns-certain-records.html

    was that we were creating a custom related list on a Zoho Finance > Sales Orders module but it wasn't finding all the Quotes related to this Sales Order. How? The quick answer is buried in Zoho documentation and due to the searchRecords function...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  6. Joomla WHERE clause with ORhttps://joellipman.com/articles/cms/joomla/joomla-where-clause-with-or.html

    $db->query('SELECT * FROM #__myTable WHERE condition1=true or condition2=true') Method #1 - chain: $query ->where($db->quoteName('condition1') . ' = '. $db->quote('true'),'OR') ->where($db->quoteName('condition2') . ' = '. $db->quote('true')) Method #2...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  7. PHP & MySQL Search Enginehttps://joellipman.com/articles/web-development/php/php-a-mysql-search-engine.html

    # 2 functions to split up search terms and accepting double-quotes as phrase makers. function search_transform_term($term){ $term = preg_replace("/(\s)/e", "'{WHITESPACE-'.ord('\$1').'}'", $term); $term = preg_replace("/,/", "{COMMA}", $term); return...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  8. SSRS External Images don't displayhttps://joellipman.com/articles/microsoft/ssrs/ssrs-external-images-dont-display.html

    sources are specific saying that the account will need to be able to logon to the external server holding the files. MSDN Quote: When the report is previewed in Report Designer, preview uses the credentials of the user to display the image. When the...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  9. Joomla article modal with clear buttonhttps://joellipman.com/articles/cms/joomla/joomla-article-modal-with-clear-button.html

    button is essential as some article_modal fields may not be required and are difficult to clear once set. How? Well don't quote me on this but I haven't needed to modify this script for any different component. Simply include this file in the fields...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  10. Zoho Templates - Font size is inexplicably tinyhttps://joellipman.com/articles/crm/zoho/zoho-templates-font-size-is-inexplicably-tiny.html

    to 46pt throughout the template: Screenshot #2: This screenshot is of the PDF preview of my HTML code where I've selected a quote and applied a template to it: The Solution After removing all styling, taking away classes and ID fields that might have...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: en-GB
  11. CSS Ordered List 1, 1.1...1.10 Formatting and Alignmenthttps://joellipman.com/articles/web-development/css/css-ordered-list-1-1-1-1-10-formatting-and-alignment.html

    Why? I'm finding that I need to do this quite often for some clients who want to include their terms and conditions in quote/invoice templates and want the HTML to be indented neatly. Other examples out there will work, but I found that once the list...

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: en-GB
  12. Zoho CRM: Get Unique Values of a Text Fieldhttps://joellipman.com/articles/crm/zoho/zoho-crm-get-unique-values-of-a-field.html

    so we'll skip to the COQL query. This is what I have: // // build up COQL query v_CoqlQuery = "select distinct Currency from Quotes where Subject!=''"; // // build up parameters m_Params = Map(); m_Params.put("select_query",v_CoqlQuery); // // invokeUrl...

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

    when creating a custom app. Why? My use-case scenario here is that we have a Zoho Creator app which comprises of a custom quote builder that staff use to store details about a product, and then to push that product out to their Shopify store with a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  14. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbohttps://joellipman.com/articles/crm/zoho/zoho-cliq-integrate-openai-and-chatgpt-3-5-turbo.html

    + ")?"; m_Response = {"text":v_Response }; } } return m_Response; Error(s) Encountered: Exceeded Quote Limit: Try generating a new API key (aka Secret). If you need a paid plan, then you can access this by logging into OpenAI and browsing to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  15. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Signhttps://joellipman.com/articles/crm/zoho/zoho-crm-zoho-sign-send-crm-merged-template-for-zoho-sign.html

    ").getPrefix("+").toString(v_TimeFormat),"-"); // // generate XML related list response // don't forget to escape quote name with CDATA in case of XML banned characters v_RelatedListXML = v_RelatedListXML + ""; v_RelatedListXML = v_RelatedListXML + "";...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
Results 21 - 35 of 35

Donate & Support

If you like my content, and would like to support this sharing site, feel free to donate using a method below:

Paypal:
Donate to Joel Lipman via PayPal

Bitcoin:
Donate to Joel Lipman with Bitcoin bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4

Ethereum:
Donate to Joel Lipman with Ethereum 0xb038962F3809b425D661EF5D22294Cf45E02FebF

Please publish modules in offcanvas position.