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

  1. Oracle: order by subquery missing right parenthesishttps://www.joellipman.com/articles/else/database/oracle-pl-sql/oracle-order-by-subquery-missing-right-parenthesis.html

    = ps.person_reference order by pa.last_modified_date desc ) FROM Person_Staff ps -- In oracle, yields "missing parenthesis" error. So you can see my parentheses are fine. Working Solution: SELECT ps.person_id, ps.person_name, ( select txt from ( select...

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

  2. PHP & MySQL Search Enginehttps://www.joellipman.com/articles/cms/website-development/php/php-a-mysql-search-engine.html

    ' ', $str); // replace any asterisk signs with a single-space $str = str_replace("(", ' ', $str); // replace any open parenthesis with a single-space $str = str_replace(")", ' ', $str); // replace any closing parenthesis with a single-space $str =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB

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

    This is an article to remind me how to search for CRM records by a value that may contain an ampersand or parenthesis. Why? I wrote this article because some searches will work for me and sometimes it won't. Escaping the ampersand with a backslash or...

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

  4. Zoho CRM: searchRecords with sorted resultshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-searchrecords-with-sorted-results.html

    criteria string to your specific requirements (:equals:, :starts_with:, |=|). If 1 expression then you can omit the parenthesis. If multiple expressions then separate each with parenthesis joined by "and" or "or". Nulls are not returned. Set the...

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

  5. ZohoCRM: Using Criteria with Module Record Counthttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-using-criteria-with-module-record-count.html

    Example: Consider the search term: ((Last_Name:equals:Burns,B)and(First_Name:starts_with:M)) After escaping comma and parenthesis in the value: ((Last_Name:equals:Burns\,B)and(First_Name:starts_with:M)) After encoding the value:...

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

  6. Performance Report - Background colors based on dataset valueshttps://www.joellipman.com/component/content/article/green-red-background-colors-based-on-dataset-values.html?catid=75&Itemid=165

    Right-click on the grey left margin and select "Insert Row" then "Outside Group - Below". Delete the row with the left parenthesis Click on the dropdown of "Data" and select "TimeStamp". Click in the left of that column and type the word "TimeStamp"....

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

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

    expression 00936. 00000 - "missing expression" The solution was to enclose the subquery with an opening and closing parenthesis. -- Erroring: SELECT NVL( SELECT student_accounts.student_username FROM student_accounts WHERE student_accounts.studentID =...

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

  8. Regular Expression Basic Usage Exampleshttps://www.joellipman.com/articles/cms/website-development/regular-expression-basic-usage-examples.html

    the following strings: abcdef abc The backreference counts subexpressions from left to right starting with the opening parenthesis of each preceding subexpression. The backreference lets you search for a repeated string without knowing the actual string...

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

  9. A quick run through of setting up an export process in SITShttps://www.joellipman.com/articles/cms/website-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

    by double chevrons. Add the DataChange-out-tray Rule Element (DRE) records by clicking on the "Add" button Use brackets/parenthesis if you need to Enter the field to monitor under "Old field/Value" enclosed by double chevrons Enter the same field to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Extensible Markup Language
    • Language: *

  10. Reminder on SSRS row separatorhttps://www.joellipman.com/component/content/article/reminder-on-ssrs-row-seperator.html?catid=75&Itemid=165

    (usually "Group1") by clicking the grey part above it Delete this column. Check that the grouping grey part (a giant parenthesis) is still there. Right-click on the grey header of the tablix row again (left-most grey part) Select "Insert Row" and I...

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