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

  1. Basic Oracle Stored Procedure Structurehttps://www.joellipman.com/articles/else/database/oracle-pl-sql/basic-oracle-stored-procedure-structure.html

    use this number in a second query which we're hoping will be quicker than a straightforward table join. Syntax CREATE [OR REPLACE] PROCEDURE stored_procedure_name [ (parameter [,parameter]) ] IS | AS [declaration_section] BEGIN executable_section...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
  2. Convert XML UTF-16 to JSON UTF-8 with PHP cURLhttps://www.joellipman.com/articles/cms/website-development/php/convert-xml-utf-16-to-json-utf-8-with-php-curl.html

    if the received XML is a string. // setting XML value $string = ' 2/13/2013 10:37:24 PM Failure Incorrect Contact ID '; // Replace UTF-16 with UTF-8 $xml_string = preg_replace('/( urlencode($last_name), 'fname' => urlencode($first_name), 'title' =>...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  3. Warning call_user_func: First argument is expected to be a valid callbackhttps://www.joellipman.com/articles/cms/joomla/warning-call-user-func-first-argument-is-expected-to-be-a-valid-callback.html

    Find the following piece of code around line 311: foreach($this->horizontalCookie[$row] as $block) { $block = str_replace('-', '', $block); $this->module_row1 .= call_user_func($block, $this, $mClasses); } And change it to:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  4. 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

    A quick note on how to copy files and folders over without overwriting existing files. It's easy to say "Yes" and replace all files. What I need is something that synchronizes files on an internal hard drive to an external one. I wanted it to copy only...

    • Type: Article
    • Author: Joel Lipman
    • Category: MS-DOS
    • Language: en-GB
  5. Joes Bug Tracker (JBT)https://www.joellipman.com/component/content/article/joes-bug-tracker-jbt.html?catid=53&Itemid=165

    component for the third time (previously known as "downloadtracker" and "joesdownloadtracker"); for ages I have needed a replacement for the download component managers for Joomla! CMS. I've tried all the following for about a year each and these are my...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  6. Quadcopter App with Flight Restrictions (JQA)https://www.joellipman.com/component/content/article/quadcopter-app.html?catid=53&Itemid=165

    Map: progress spinner v1.5.x [28 Oct 2014] - [1.5.2] Map: link android key to google maps API - [1.5.2] Map: regulations replaced with icons - [1.5.1] Help: moved about to Help - [1.5.1] Map: restored blue range - [1.5.0] Map: tooltip changed to icons -...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  7. Zoho CRM/Creator - Common Errors & Gotchashttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-creator-common-errors-gotchas.html

    = v_File.toList("\\"); info l_FileParts.get(l_FileParts.size() - 1); // yields C:\Documents\My_File.txt Solution: Replace the backslash first with another character: v_File = "C:\Documents\My_File.txt"; v_FileString = v_File.toString().replaceAll("\\",...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  8. Zoho CRM: Update a custom field in line items / product details using REST API v2.1https://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-update-a-custom-field-in-line-items-product-details.html

    Item Tax does not submit in API v2.1 Trial and error resolved this one. Submit the line item but instead of "line_tax", replace this with "Line_Tax" (note the capitalized letters). I have included this in the example above. Line Item Tax doesn't display...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  9. Zoho Deluge: Generate and Send a CSV via Emailhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-generate-and-send-a-csv-via-email.html

    and can you archive the data and email it to me every month"... How? Rather than just babble on about it, here's the code, replace what you need just noting that I'm enclosing each value with double-quotes because the values might have commas and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  10. Zoho Creator: Receive JSON via a Shopify Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-receive-json-via-a-shopify-webhook.html

    did, you can eventually develop this to do more but I'm coding for this example and for this demonstration only (obviously replace the my_owner and my_app with your Zoho Creator owner and app name respectively) Update 2022: I've included the code to...

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

    in case they add a currency or tax rate and want to push a sales order 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  12. Zoho Creator / eBay: Get all Active Productshttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-ebay-get-all-active-products.html

    l_OutputFields.add("TotalNumberOfEntries"); m_Params.put("OutputSelector",l_OutputFields); // // convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  13. Zoho Deluge: Generate List of TimeZoneshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-generate-list-of-timezones.html

    remove the HTML tags: l_TimeZones = List(); for each v_TimeZoneOption in l_TimeZoneOptions { v_TimeZone = v_TimeZoneOption.replaceAll("",""); // replace any commas in the value (for list conversion later on) v_TimeZone = v_TimeZone.replaceAll(","," ",...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  14. Zoho Creator: eBay: Get Item Transactionhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-ebay-get-item-transaction.html

    //m_ActiveList.put("Sort","ItemID"); m_Params.put("ItemID",p_ItemID); // // convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params = x_Params.toString().replaceFirst("",""); // //...

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

    string p_StringToDecode ) { // initialize v_StringToDecode = ifnull(p_StringToDecode,""); // // map string replacements m_HtmlEntity = Map(); m_HtmlEntity.put("&","&"); m_HtmlEntity.put(" "," "); // // loop through each of the above replacing where...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  16. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeroshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-regex-rounding-and-or-removing-trailing-zeros.html

    words, it didn't remove the unnecessary zeros. Note that in the following regex, and if using Zoho Creator, you need to replace the double-backslash with a single backslash: v_Test1 = 12.300; info v_Test1.toString().replaceAll("(\\.\\d*?[1-9])0+$",...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  17. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictureshttps://www.joellipman.com/articles/else/e-commerce/ebay/zoho-inventory-ebay-picture-services-uploadsitehostedpictures.html

    m_Params.put("PictureName","OhBeautifulMe"); m_Params.put("PictureSet","Supersize"); // // convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Ebay
    • Language: *
  18. ZohoDeluge: Get All eBay Orders Given a From and Till Datehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zohodeluge-get-all-ebay-orders-given-a-from-and-till-date.html

    m_Params.put("CreateTimeTo",v_timeTill); m_Params.put("OrderRole","Seller"); // // convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params = x_Params.toString().replaceFirst("","");...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  19. ZohoCRM: Get All eBay Active Listingshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-get-all-ebay-active-listings.html

    available pages v_TotalNumberOfPages = ceil(v_MaximumProducts / v_PerPage); l_AddPages = leftpad(" ", v_TotalNumberOfPages).replaceAll(" ", ",").toList(); for each index v_Increment in l_AddPages { l_Pages.add(v_StartingPageIndex + v_Increment); }...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  20. Zoho Deluge: Get All Orders from eBayhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-all-orders-from-ebay.html

    available pages v_TotalNumberOfPages = ceil(v_MaximumOrders / 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 =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
Results 41 - 60 of 100