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

  1. MySQL Transactions in PHPhttps://joellipman.com/articles/else/database/mysql/mysql-transactions-in-php.html

    expected result before committing any changes to the data. This where transactions are useful. We can run the queries, then check if some conditions are met before committing the changes in the data: $mysqli->begin_transaction(); $mysqli->query ("UPDATE...

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

    • Type: Article
    • Category: Static Items
    • Language: *
  3. AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktopshttps://joellipman.com/component/content/article/autohotkey-ms-windows-10-open-apps-on-multiple-monitors-and-desktops.html?catid=48&Itemid=165

    basic code to: 1) get all monitors, 2) open an app on a specified monitor, 3) switch to another desktop. Count Monitors and Check it can see left-most, central, and right-most monitors: ; init DetectHiddenWindows, Off v_LeftMost := 0 v_Center := 0...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  4. AutoHotkey: App GUI Listview to Rename Fileshttps://joellipman.com/component/content/article/autohotkey-app-gui-listview-to-rename-files.html?catid=48&Itemid=165

    name if a file with the same name exists. ; ; Date (v1.0): 8 July 2020 ; - Initial Release ; Date (v1.1): 10 August 2020 ; - Checks for duplicates done by searching its own column. ; - Also checks for duplicates if file exists. ; - Leaves original file...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  5. Privacy Policyhttps://joellipman.com/component/content/article/privacy-policy.html?catid=50&Itemid=165

    with this privacy statement. Joel Lipman .Com may change this policy from time to time by updating this page. You should check this page from time to time to ensure that you are happy with any changes. This policy is effective from the 1st of January...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: en-GB
  6. MS-DOS: Copy folders without overwriting fileshttps://joellipman.com/component/content/article/ms-dos-copy-folders-without-overwriting-files.html?catid=51&Itemid=165

    source; run again in m minutes Time, if changed. /RH:hhmm-hhmm :: Run Hours - times when new copies may be started. /PF :: check run hours on a Per File (not per pass) basis. /IPG:n :: Inter-Packet Gap (ms), to free bandwidth on slow lines. /SL :: copy...

    • Type: Article
    • Author: Joel Lipman
    • Category: MS-DOS
    • Language: en-GB
  7. Joes Password Analyzer (JPA)https://joellipman.com/component/content/article/joes-password-analyzer-jpa.html?catid=53&Itemid=165

    is Joe's Password Analyzer? Joe's Password Analyzer is an online tool that quickly checks any password you might want to try using and suggests variations on this. Simply type a word or phrase in the input field and let it do the rest. Background Joe's...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  8. Joes Search Module (JSM)https://joellipman.com/component/content/article/joes-search-module-jsm.html?catid=53&Itemid=165

    other valid values are: categories contacts newsfeeds weblinks To determine yours, do a standard search on your website and check the search results page. There should be several additional options to your search that will be displayed under the "Search...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  9. Zoho Deluge - Generate 5 Letter Booking Retrieval Codehttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-generate-5-letter-booking-retrieval-code.html

    { // init b_BadWordFound = false; // get attempt v_Output = thisapp.generateRetrievalCode(); // see if can use contains but check for word for each v_BadWord in l_BadWords { if(v_Output.indexOf( v_BadWord ) >= 0) { b_BadWordFound = true; } } // if not...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  10. Zoho Deluge: Convert Xero Date (Unix Timestamp) to Standard Date Stringhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-convert-xero-date-unix-timestamp-to-standard-date-string.html

    v_ZohoTime = v_ZohoEpoch.toLong().toTime("yyyy-MM-dd HH:mm:ss", v_ZohoTZ); info v_ZohoTime; // check if timezone was included or not v_RegexPattern = "/Date\((\d+)([+-]\d{4})?\)/"; v_ZohoEpoch = v_XeroTime.replaceAll(v_RegexPattern,"$1",false); info...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  11. Zoho Deluge: Setup an API Connection for InvokeURLhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-setup-an-api-connection-for-invokeurl.html

    the Connector How do I determine what datacenter to use? To find out which datacenter your client/customer is using in Zoho, check the domain and specifically the top-level-domain (TLD) part. For example, if it says zoho.com, then this means the US...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  12. Zoho Deluge: Search Records with Special Characters (COQL)https://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-search-records-with-special-characters-coql.html

    } Note that for the above, if there are no matching records, r_Coql will simply return an empty string. Hence the check for isNull on the keys info and data. And yes, the part that took me about 8 hours and the key point above is to replace the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  13. Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments)https://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-download-file-from-zohocrm-field-type-file-upload-not-attachments.html

    v_PublishKey = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKL"; // // check if already exists (double-security: Email and File Ref must match) r_CreatorFile = Download_File[Owner_Email ==...

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

    Choose Field "Save & Close" Name the workflow "OnSubmit_SaveClose" Add your deluge code that should: Validate the fields (checks mandatory fields have been entered) for example: // // check mandatory fields have been entered l_Errors = List();...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  15. Zoho CRM & Zoho Books: Get SalesPersonshttps://joellipman.com/articles/crm/zoho/zoho-books/zoho-crm-zoho-books-get-salespersons.html

    = ""; // // eval v_BooksOrgID = 12345678901; r_SoDetails = zoho.crm.getRecordById("Sales_Orders",p_SoID); // // check if owner and get matching salesperson ID if(!isnull(r_SoDetails.get("Owner"))) { v_OwnerID = r_SoDetails.get("Owner").get("id");...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  16. Zoho Deluge: Date from a String (dd/MM/yyyy to yyyy-MM-dd)https://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-date-from-a-string-dd-mm-yyyy-to-yyyy-mm-dd.html

    Tue, 7 Jan 1975 ********************* 1975-01-07 07-Jan-1975 Tue, 7 Jan 1975 Additional You would of course need to check that there is nothing wrong with the date that was submitted. Especially if it is coming from a data source, the Zoho deluge...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  17. Zoho CRM: Permission Denied for Quote Conversion Mappinghttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-permission-denied-for-quote-conversion-mapping.html

    on "Save" Re-click on "Organize Modules" and disable the "Invoices" module. Test converting a quote to a sales order and check the fields mapped correctly. Source(s): the amazing Zoho Support team

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  18. Zoho Creator: Prevent Endless Loops On User Input of a Fieldhttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-prevent-endless-loops-on-user-input-of-a-field.html

    of fields. if(zoho.currenttime > input.DateTime_form_was_loaded.addSeconds(10)) { // do my stuff here } Method #2: Boolean checkbox to switch on/off workflow Another method I tried was adding a checkbox/decision box (boolean) to the form called...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  19. ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.https://joellipman.com/articles/crm/zoho/zoho-books/zohocrm-to-zohobooks-please-ensure-that-the-shipping_address-has-less-than-100-characters.html

    v_AddressIndex = v_AddressIndex + 1; } // check that there was something to actually update rather than wasting an API call if(m_ShippingAddress.size() > 0) { // endpoint TLD is EU for Europe DC and COM for US DC v_Endpoint =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  20. Zoho CRM & Zoho Books: Get Books Currency and Tax IDshttps://joellipman.com/articles/crm/zoho/zoho-books/zoho-crm-zoho-books-get-books-currency-and-tax-ids.html

    immediately over. Get Currencies Remember to replace the v_BooksOrgID with your client's Organization ID for Zoho Books and check the URL for whether it will be https://books.zoho.eu or https://books.zoho.com. You will also need your own CRM to Books...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
Results 81 - 100 of 173