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

  1. Migrating from Joomla 2.5.x to 3.4.xhttps://joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

    `v34_db`.`v34_contact_details` WHERE `v34_contact_details`.`id` >= 1 -- ALTER TABLE `v34_db`.`v34_contact_details` AUTO_INCREMENT = 1 -- Content: UPDATE `v34_db`.`v34_content` SET `created_by` = @v25_admin_id, `created_by_alias` = @v25_admin_alias WHERE...

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

  2. AutoHotkey: App GUI Listview to Rename Fileshttps://joellipman.com/articles/automation/autohotkey/autohotkey-app-gui-listview-to-rename-files.html

    of a directory using an AutoHotkey GUI and display what it will name them. The app needs to rename files but append an incremented count if the name of a file already exists. The original file needs to keep its original name. What I have EDIT 0_00 0_30...

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

  3. Increment a column in MySQL using the UPDATE queryhttps://joellipman.com/articles/database/mysql/increment-a-column-in-mysql-using-the-update-query.html

    Suppose you have a column in your table that you use as a counter (storing the value of the counter - eg. times an article has been displayed). Basically what I used to do is something similar to the following: SELECT counter_field_value FROM table1...

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

  4. Reorder Columns in a Tablehttps://joellipman.com/articles/database/reorder-columns-in-a-table.html

    the order of the columns, for example: -- From CREATE TABLE IF NOT EXISTS `Table1` ( `Column1` int(11) NOT NULL AUTO_INCREMENT, `Column3` int(11) NOT NULL, `Column2` varchar(100) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`Column1`) ) ENGINE=MyISAM...

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

  5. Split a row into multiple rows based on a column valuehttps://joellipman.com/articles/database/t-sql/split-a-row-into-multiple-rows-based-on-a-column-value.html

    002 1.00 2000-02-18 002 1.00 2000-02-19 002 1.00 2000-02-20 003 1.00 1999-02-25 003 1.00 1999-02-26 -- note the dates increment and do not account for days off (eg. Saturday / Sunday) How? Adapted from a forum topic: SQLTeam Forums First of all, we want...

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

  6. ZohoCRM: Get All eBay Active Listingshttps://joellipman.com/articles/crm/zoho/zohocrm-get-all-ebay-active-listings.html

    / v_PerPage); l_AddPages = leftpad(" ", v_TotalNumberOfPages).replaceAll(" ", ",").toList(); for each index v_Increment in l_AddPages { l_Pages.add(v_StartingPageIndex + v_Increment); } v_TotalNumberOfPages = l_Pages.size(); // // declare variables to...

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

  7. Zoho Deluge: Get All Orders from eBayhttps://joellipman.com/articles/crm/zoho/zoho-deluge-get-all-orders-from-ebay.html

    / v_PerPage); l_AddPages = leftpad(" ",v_TotalNumberOfPages).replaceAll(" ",",").toList(); for each index v_Increment in l_AddPages { l_Pages.add(v_Increment + 1); } v_TotalNumberOfPages = l_Pages.size(); // // declare variables to store order details...

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

  8. Excel - Check a column for values found in another columnhttps://joellipman.com/articles/microsoft/excel/excel-check-a-column-for-values-found-in-another-column.html

    the cell to search for those words. Note how I don't add a dollar, this is so that the formula will apply to each row and increment based on how you copy the formula to other cells. You should end up with something like this (I have added some...

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

  9. Zoho CRM: Manage a subform using Client Scripthttps://joellipman.com/articles/crm/zoho/zoho-crm-manage-a-subform-using-client-script.html

    is not null and has not already been listed if (v_SkillName != null && l_AlreadyListed.indexOf(v_SkillName)...

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

  10. ZohoCRM: Import Attachmentshttps://joellipman.com/articles/crm/zoho/zohocrm-import-attachments.html

    v_RunFolder "\Attachments\" v_NewFile, v_OriginalFilePath, v_NewFile, v_DisplayName, A_LoopFileSizeKB) ; increment v_FileCount := v_FileCount + 1 SB_SetText("Scanning Directory... Attachment #" A_Index, 1) ; output to CSV LV_GetText(v_Col01, A_Index, 1)...

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

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

    // // stop the loop if there weren't any more products if(l_ThisList.size()...

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

  12. Zoho Deluge: Determine your Statement Execution Limithttps://joellipman.com/articles/crm/zoho/zoho-deluge-determine-your-statement-execution-limit.html

    will run resulting in the error "Number of statement execution limit exceed Line:(10)" but it will info out each number to increment: // l_Loop = " ".leftpad(5000).replaceAll(" ", ",").toList(); // for each index v_Iteration in l_Loop { info...

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

Joes Word Cloud

Please publish modules in offcanvas position.