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

  1. Connection Strings for SQL Serverhttps://www.joellipman.com/component/content/article/connection-strings-for-sql-server.html?catid=78&Itemid=165

    Connectors from dev.MySQL.com MySQL Connector/Net Type: .NET Framework Class Library Usage: MySql.Data.MySqlClient.MySqlConnection Manufacturer: MySQL Standard Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; Default port is...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server
    • Language: *
  2. Regular Expression Basic Usage Exampleshttps://www.joellipman.com/articles/cms/website-development/regular-expression-basic-usage-examples.html

    What? 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  3. AutoHotkey: Get Media Information and Displayhttps://www.joellipman.com/component/content/article/autohotkey-get-media-information-and-display.html?catid=48&Itemid=165

    to media files in general. How? So first I'm going to list a function I use called "Filexpro()", then list some examples of usage. And in the second-to-last section, I'll quickly convert a 100 nanoseconds unit to display Hours : Minutes : Seconds. We...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  4. Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library)https://www.joellipman.com/component/content/article/upload-file-to-google-drive-with-php-curl-and-api-rest-v3-without-library-install.html?catid=61&Itemid=165

    '.curl_error($ch2); } else{ $output = $response; } // close second request handler curl_close($ch2); } return $output; } Usage: $mime_type = 'video/mp4'; // could be 'image/jpeg', etc. $new_name = 'My Video'; $the_file_and_path =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  5. Autohotkey Count Number of Files/Folders in a Directoryhttps://www.joellipman.com/component/content/article/autohotkey-count-number-of-files-folders-in-a-directory.html?catid=48&Itemid=165

    SC_Name[A_Index] := A_LoopFileName SC_TotalFiles := A_Index } } -- put this function at the end of the script. -- usage: SC_Load("C:\*.*", 1) MsgBox, TotalFiles %SC_TotalFiles% -- yields number of files in a directory recursively. Method #4:...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  6. Terms & Conditionshttps://www.joellipman.com/component/content/article/terms-conditions.html?catid=50&Itemid=165

    users to distinguish between official Joel Lipman .Com website administrators and other registered members. WEBSITE USAGE Welcome to our website. If you continue to browse and use this website you are agreeing to comply with and be bound by the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  7. Zoho Deluge: Text (SMS) reminder using Twilio API (LocalSense)https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-text-sms-using-twilio-api-localsense.html

    the message we want to send v_Message = "This is a test text"; // // build up the endpoint (see https://www.twilio.com/docs/usage/requests-to-twilio#http-methods for latest endpoint) v_Endpoint = "https://" + v_Account_SID + ":" + v_Auth_Token +...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  8. 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

    API (eg. website checkouts) then set these. Mine don't as the Creator app I'm making is for staff only. REST Admin API: Usage: Here's a quick test I do retrieving 5 products using the REST admin API: // // app specific r_ShopifyAPI =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  9. Zoho Books: Get Invoice Payment Terms via APIhttps://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-books-get-invoice-payment-terms-via-api.html

    { "payment_terms_id": "", "is_mandatory": true, "payment_terms": -3, "payment_terms_label": "Due end of next month" } ] } } Usage: This is just a snippet of usage and obviously not the whole function to generate an invoice. Please refer to the Zoho...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  10. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/component/content/article/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html?catid=74&Itemid=165

    string errorMsg1 = "Invalid datatype for {0}. Inputs must be DT_STR or DT_WSTR"; string errorMsg2 = "Invalid usage type for {0}. Inputs must be READWRITE"; // Check whether each column type is DT_STR/DT_WSTR for (int x = 0; x...

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

    ROBOCOPY :: Robust File Copy for Windows ------------------------------------------------------------------------------- Usage :: ROBOCOPY source destination [file [file]...] [options] source :: Source Directory (drive:\path or \\server\share\path)....

    • Type: Article
    • Author: Joel Lipman
    • Category: MS-DOS
    • Language: en-GB
  12. Joe's Unduplicater (JUD)https://www.joellipman.com/component/content/article/joes-unduplicater.html?catid=53&Itemid=165

    have to go through a few hundred files manually checking that I have the converted version and deleting the original. SAMPLE USAGE: If you have a portable media player that needs to convert media files before they can be transferred to the device, then...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  13. Zoho Deluge: Duplicate/Clone a Recordhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-duplicate-clone-a-record.html

    the popup. You should be redirected to a page which lists the "status" as connected as well as a snippet of Deluge for the usage Source(s): Zoho CRM Developer - getFields Method - Comparison

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  14. Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party APIhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-post-a-multi-dimensional-or-nested-array-to-a-3rd-party-api.html

    me. Note that usually I could customize the receiving PHP script to receive a JSON request and process it that way but my usage was to send data to a Third-Party API over which I had no control. What I need to send to the 3rd-party API: { "auth": {...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  15. 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

    r_UploadPhoto = invokeurl [ url :v_Endpoint type :POST parameters:m_Params.toString() headers:m_Header ]; } } And it's usage: // somewhere in the beginning l_ShopifyPictures = List(); v_ListingPublishKey =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  16. Zoho Deluge: a HTML Entity Decoderhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-a-html-entity-decoder.html

    = v_StringToDecode.replaceAll(v_HtmlKey, m_HtmlEntity.get(v_HtmlKey), true); } // // output return v_StringToDecode; } Usage: v_TestString = "Father & Sons"; v_DecodedString = thisapp.DataCleansing.fn_DecodeHtmlEntities(v_TestString); info...

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

    this up would be to setup a bot in ZohoCliq and then to edit either a message handler or participation handler. As for the usage, simply ask the Cliq Bot a question and it will forward the query and respond with the response from the OpenAI API. Setup a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Other
    • Language: *
  18. Zoho Deluge: Determine if Daylight Savings are in effecthttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-determine-if-daylight-savings-are-in-effect.html

    "GMT"), true, false); info b_IsDSTInEffect; // v_TimeZoneOffset = if(b_IsDSTInEffect, "+01:00", "+00:00"); // // usage v_SendToCRM_DateTime = zoho.currenttime.toString("yyyy-MM-dd'T'HH:mm:ss","Europe/London") + v_TimeZoneOffset; Note(s): This was done...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  19. Joomla article modal with clear buttonhttps://www.joellipman.com/articles/cms/joomla/joomla-article-modal-with-clear-button.html

    You then refer to it in your XML file where instead of type="sql" use type="modal_article". A usage example is: Just copy & paste the below into a PHP file and include it in your component, the solution is really that straightforward. Feel free to check...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  20. SSRS AlphaNumeric Parameter Validationhttps://www.joellipman.com/component/content/article/ssrs-alphanumeric-validation.html?catid=75&Itemid=165

    -- 1 if is alphanumeric, 0 if not alpha numeric. SELECT @ParameterToCheck REGEXP '^[A-Za-z0-9]+$' AS AlphaNumeric FROM... Usage -- Using the ORACLE example SELECT Column1, Column2, (LENGTH( TRIM( TRANSLATE( :ParameterToCheck,...

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