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

  1. Regular Expression Basic Usage Exampleshttps://joellipman.com/articles/web-development/regular-expression-basic-usage-examples.html

    A quick reminder on basic regular expressions. Match Any Character — Dot The dot operator '.' matches any single character in the current character set. For example, to find the sequence--'a', followed by any character, followed by 'c'--use the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  2. Migrate Joomla! 1.5.x to 2.5.x+https://joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

    to do the following: -- 1) Migrate all users except any matching the new admin in J30 -- 2) Migrate user who's ID in J15 matches the new admin ID in J30 -- 3) Recover odduser's new ID in J30 and re-associate to content -- 4) Recover groups used in J15...

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

    '\\\$1', $string); } # function to list terms into list of regular expressions # eg. search for 'foo' matches 'a foo a' but not 'a food a'. function search_db_escape_terms($terms){ $out = array(); foreach($terms as $term){ $out[] = '[[::]]'; } return...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  4. Preg_Replace all strings between two tagshttps://joellipman.com/articles/web-development/php/preg-replace-all-strings-between-two-tags.html

    $string_formatted = preg_replace( '/@[a-z]+/i','$0', $string_original); -- METHOD #2: equivalent using preg_match_all $matches = null; preg_match_all('/(?!\b)(@\w+\b)/',$string_original,$matches); foreach ($matches as $match) { foreach ($match as...

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

    title. In the stages thereafter, I'm going to simply enhance the relevance factor: Soundex: Built-in function to list matches that sound like the search term. Levenshtein: Allows for typos and matches to words that are 1 or 2 letters mistyped. Grammar:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  6. Zoho Deluge - Some Useful Regular Expressionshttps://joellipman.com/articles/crm/zoho/zoho-deluge-some-useful-regular-expressions.html

    = v_MyString.replaceAll(v_MyRegEx,""); b_Ok = if( v_MyFormattedString == "", true, false); // yields false Yay Zoho has "matches". So this is the regex way to do it: v_MyRegEx = "^[A-Za-z0-9._-]+@[A-Za-z0-9._-]+\.[A-Za-z]{2,}$"; v_MyString =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  7. Zoho CRM: Manage a subform using Client Scripthttps://joellipman.com/articles/crm/zoho/zoho-crm-manage-a-subform-using-client-script.html

    var v_ConsultantLocation = ZDK.Page.getField('Location').getValue(); // only run the rest if record matches criteria if (v_CurrencyCode == "GBP" && v_ConsultantLocation == "UK") { // get value of trigger field var v_RateCard =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  8. SSRS Retrieving Oracle Stored Procedure Success or ErrorLevelhttps://joellipman.com/articles/microsoft/ssrs/ssrs-retrieving-oracle-stored-procedure-success-or-errorlevel.html

    Workaround we actually went with Our Stored Procedure would check if the unique identifying number (in our case StudentID) matches a record in the database table and that the request number was alphanumeric. In addition, this would be checked at the...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  9. How to Display Report Execution Time in SSRS (milliseconds)https://joellipman.com/articles/microsoft/ssrs/how-to-display-report-execution-time-in-ssrs.html

    blank, else, do the rest of the query. Blank out the textbox basically (execution time is kinda irrelevant when you get 0 matches) We went with option 2. Check this result - Possibly from the Reporting Server ExecutionLog? Using the ReportServer...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  10. 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

    stored procedure in a SQL Server Reporting Services (SSRS) environment and don't want to return any rows if there are no matches (not a blank row either) as one of my reports uses a row counter to display a "No data found" message when no rows are...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
  11. MySQL: Display Users and Duration in Matrix Timesheethttps://joellipman.com/articles/database/mysql/mysql-display-users-and-duration-in-matrix-timesheet.html

    . $this_sat . "\t" . $this_sun . "\t" . $this_t . "\t" . $this_t2;...do some more here ???... } } Yields -- Note this data matches the brief as we've converted the seconds to time. -- Using MySQL to convert rather than PHP so as not to have to deal...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  12. Search a database with SOUNDEXhttps://joellipman.com/articles/database/search-a-database-with-soundex.html

    ** ** 15/10/2012 Jlipman 1.2 Added count column to final results. ** ** Added minStrLen and maxStrLen for more accurate matches. ** ** Changed order by MAX(column_source) to MIN(column_source). ** ** 26/10/2012 Jlipman 1.3 Changed into a Stored...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  13. htaccess Rewrites SEF URL and submits to PHPhttps://joellipman.com/articles/web-development/php/htaccess-rewrites-sef-url-and-submits-to-php.html

    rule is: RewriteCond %{REQUEST_URI} ^/([\w]+).html [NC] But, er, I like that first check (myFolder) that the submitted URL matches the format of your site (and a lot more opportunity to check for malicious code).

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  14. ReCaptcha alternative: Integrate PlayThru in JComments 2.3 for Joomla 2.5https://joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-for-joomla.html

    On the dashboard, note the Scoring key (eg. "64d6d442b7e846acfaacef642e1ad173b35503") On the dashboard, check the site URL matches the domain you are trying this on (eg. if you are testing on "http://test.mycompany.com" then the site specified in the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  15. ReCaptcha alternative: Integrate PlayThru in JComments 3.0 for Joomla 3.2https://joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-3-0-for-joomla-3-2.html

    On the dashboard, note the Scoring key (eg. "64d6d442b7e846acfaacef642e1ad173b35503") On the dashboard, check the site URL matches the domain you are trying this on (eg. if you are testing on "http://test.mycompany.com" then the site specified in the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  16. Joes Quicklist Weblinks (JQW) Downloadshttps://joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=92

    Edition- Fixed Bug: Order By Date - Fixed Bug: Order in descending/ascending order - Enhancement: Changed default settings (matches personal site) - IMPORTANT: Cannot use "Public" usergroup to generate images!!! - Date Uploaded: Fri, 21st Dec 2012 2.0.8...

    • Type: Article
    • Author: Joel Lipman
    • Category: Downloads
    • Language: *
  17. Zoho Creator: Retrieve record with case-insensitive queryhttps://joellipman.com/articles/crm/zoho/zoho-creator-retrieve-record-with-case-insensitive.html

    be used on strings or lists containsIgnoreCase case-insensitive search endsWith endsWithIgnoreCase equals equalsIgnoreCase matches notContains though I tend to use !myVar.contains() startsWith startsWithIgnoreCase used in fuzzy logic searches to broaden...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  18. AutoHotkey: App GUI Listview to Rename Fileshttps://joellipman.com/articles/automation/autohotkey/autohotkey-app-gui-listview-to-rename-files.html

    bit: loop while incrementing checking if the value is not already in the list ; also check whether proposed file name matches the original file exists and is an exception for renaming. v_Increment := 1 b_KeepLooping := true while ( b_KeepLooping ||...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  19. ZohoCRM & Xero Real-Time Invoices: Receive Webhookhttps://joellipman.com/articles/crm/zoho/zohocrm-xero-real-time-invoices-receive-webhook.html

    } } } } } } } } // // return return {"crmAPIResponse":m_Response}; If you don't get an OK message then check your CRM code matches as above (with different v_Webhook_Key). If it still doesn't work then try solution #2: using a third-party server...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
Results 1 - 19 of 19

Please publish modules in offcanvas position.