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

  1. T-SQL functions to convert Strings to Tableshttps://www.joellipman.com/articles/else/database/t-sql/t-sql-functions-to-convert-strings-to-tables.html

    to: Microsoft SQL Server 2008 R2 Microsoft SQL Server 2012 What? These were in a solution and I thought I'd note them on my site so I can refer to them more easily. How? Let's start with a function that just converts a string of words delimited by...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB

  2. Merge the content of two similar tables in MySQLhttps://www.joellipman.com/articles/else/database/mysql/merge-the-content-of-two-similar-tables-in-mysql.html

    (table name: jos_content): id title introtext -------------------------------------------------------------------------- 1 Welcome This is Joomla 2 Copyright This site and its design is property of JoelLipman.com HP Articles (table name: jos_hp_items):...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB

  3. Php convert filesizes to bytes kb mb gbhttps://www.joellipman.com/articles/cms/website-development/php/php-convert-filesizes-to-bytes-kb-mb-gb.html

    Just a quick note on how to format a given filesize and to reduce the display output to a small string, eg: 196 bytes : displays as => "196 bytes" 12945 bytes : displays as => "12 Kb" 1478515 bytes : displays as => "1 Mb" 8798745455 bytes : displays as...

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

  4. mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connecthttps://www.joellipman.com/articles/else/database/mysql/mysqldump-got-error-2049-connection-using-old-pre-4-1-1-authentication-protocol-refused-client-option-secure-auth-enabled-when-trying-to-connect.html

    to: MySQL Database v5.0.45 MySQL Workbench v6.0.8.11354 build 833 What? This is a quick article on how to get around the problem of backing up your MySQL database when attempting to "Data Export" using MySQL Workbench. This is not regarding the...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *

  5. Write a Calendar in Autohotkeyhttps://www.joellipman.com/component/content/article/write-a-calendar-in-autohotkey.html?catid=48&Itemid=165

    who calculates how many days there are in a month so this is a crude solution ; This checks if this year is a leap year Check1:=Mod(A_YYYY,4) Check2:=Mod(A_YYYY,100) Check3:=Mod(A_YYYY,400) if (Check1=0) AND (((Check2=0)and(Check3=0)) OR (Check20))...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB

  6. 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

    UserFolder:="C:" -- UserFolder := RegExReplace( MyInputField, "\\$") ; gets rid of trailing slash if required -- Method #1 count := 0 Loop, %UserFolder%\*.*, 0, 1 count++ -- note for future use: ; if A_LoopFileAttrib contains H,R,S ; continue This works...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB

  7. Licence GNU/GPLhttps://www.joellipman.com/component/content/article/licence-gnugpl.html?catid=50&Itemid=165

    you must show them these terms so they know their rights. Developers that use the GNU GPL protect your rights with two steps: (1) assert copyright on the software, and (2) offer you this License giving you legal permission to copy, distribute and/or...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *

  8. Zoho Deluge - First Monday of Month or Last Tuesday of Monthhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-first-monday-of-month-or-last-tuesday-of-month.html

    current date, then set it to the last Tuesday of next month. Why? This was a request by a client who instead of specifying the 1st of every month, or 15th of each month, to say the first Monday of the month (ignoring bank holidays) or to say the last...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB

  9. ZohoCRM: Process all records of a modulehttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-process-all-records-of-a-module.html

    the Module Layout and delete the "Processed" field. [Optional conditionally] Reactivate any workflows you deactivated in step 1. Sample Code Consider the following standalone function which loops through every contact and deletes the duplicate lead (if...

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

  10. Zoho Deluge: Calculate Days, Hours, Minutes, Seconds between two Timestampshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-calculate-days,-hours,-minutes,-seconds-between-two-timestamps.html

    seconds. // the now time v_NowTime = zoho.currenttime; // // correction: I want to specify a from datetime v_NowTime = '2021-09-21 21:27:15'; // // now specify a to datetime (we're doing a working day so we add 1 business day) v_NextTime =...

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

  11. Zoho Deluge: Shopify API: Get all active products with GraphQL and Paginationhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-shopify-api-get-all-active-products-with-graphql-and-pagination.html

    An article to resolve my frustration in being able to ONLY retrieve the first 100 products using GraphQL, so page 1 of Shopify products. Why? Our use-case is that we retrieve the 100 most recently modified products at the end of each day and run some...

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

  12. Zoho Deluge and Wordpress/WooCommerce API: Get All Productshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-and-wordpress-woocommerce-api-get-all-products.html

    We need this to get the count of all products (if there's another way, I'd love to hear it). We don't have more than 100 product categories so we'll just to page 1 but specifying 100 per page as the default is only 10. // // API keys (these are made up...

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

  13. Zoho CRM: Updating a CRM record Custom Line Items using API v7https://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-updating-a-crm-record-using-api-v7.html

    Actions when a quote is modified Inputs: int p_QuoteID - the ID of the CRM Quote Record Outputs: void Date Created: 2024-12-10 (Joel Lipman) - Initial release Date Modified: ??? - ??? More Information: Any information that may help...

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

  14. ZohoCRM Client Script: On Change of Dropdown: Subform Rewrite: REST Functionhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-client-script-on-change-of-dropdown-subform-rewrite-rest-function.html

    Prepares the invoice as a deposit invoice or final balance invoice Inputs: string value Outputs: - Date Created: 2025-03-31 (Joel Lipman) - Initial release Date Modified: ??? - ??? More Information: Any information that may help...

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

  15. 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

    uploads and names the file in a single request, and the third is a 'nice-to-have' upload to the specified folder. Method #1: two requests 1. Send the media file 2. Update the name of the file you just uploaded $GAPIS = 'https://www.googleapis.com/';...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB

  16. The ReportServer Databasehttps://www.joellipman.com/articles/else/database/the-reportserver-database.html

    username and domain of the person running the report (eg. MYDOMAIN\myusername) RequestType bit NOT NULL User or System. Can be 1 or 0. This was zero "0" when I would run a report as a user. Format nvarchar(26) NULL This is the rendering format. Mostly...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB

  17. MySQL Data Type Reference Tablehttps://www.joellipman.com/articles/else/database/mysql/mysql-data-type-reference-table.html

    (~64Kb) rather than LONGTEXT (~4Gb). Data Type Column Type Range or Description Storage Numeric TinyInt Signed values from -128 to 127 1 byte Unsigned values from 0 to 255 Numeric SmallInt Signed values from -32768 to 32767 2 bytes Unsigned values from...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB

  18. MySQL parameters in Excel 2007 PivotTableshttps://www.joellipman.com/articles/else/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

    the side)......staff in columns (along the top)......persondays in values (the number my bosses want - 7h 24m or 26640s is 1 person day)... With date range as parameters...ouch......and it was so easy up to here... Tables of interest StaffActivities...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB

  19. Sort an associative array by values in Javascripthttps://www.joellipman.com/articles/cms/website-development/js/sort-an-associative-array-by-values-in-javascript.html

    browser. I wanted to: Sort the array by its values my_records.sort(); Iterate through and output these in HTML for(i=0;i y ? 1 : 0; }); // use built-in JSON stringify function newSortedArrayObject = JSON.stringify(my_records_copy); // note: will convert...

    • Type: Article
    • Author: Joel Lipman
    • Category: JavaScript
    • Language: *

  20. Upgrading a Joomla 1.5 module to Joomla 2.5https://www.joellipman.com/articles/cms/joomla/upgrade-a-joomla-1-5-module-to-joomla-1-6.html

    So this is a note to myself so that I have a checklist and can quickly update any extensions designed for Joomla 1.5.x and make these compatible with Joomla 2.5.x websites. In the past, I have only ever changed the words to but for more stability, there...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
Results 61 - 80 of 337