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

  1. ZohoDeluge: eBay marketplace account deletion/closure notificationshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zohodeluge-ebay-marketplace-account-deletion-closure-notifications.html

    v_ChallengeCode = m_Params.get("challenge_code"); v_VerificationToken = ""; v_Endpoint = "https://www.zohoapis.com/crm/v7/functions/fn_ebay_alertnotification/actions/execute?auth_type=apikey&zapikey="; v_Response = zoho.encryption.SHA256(v_ChallengeCode...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  2. ZohoCRM to ZohoBooks API: Rounding the cents or pennies when creating an invoicehttps://www.joellipman.com/articles/crm/zoho/zoho-books/zohocrm-to-zohobooks-api-half-a-cent-or-penny-off-when-creating-an-invoice.html

    info "i) " + v_NotRegexedNumber; // Yields: 12345.54 Of course ZohoCRM functions have to treat Regex's slightly differently in ZohoCRM, so if we went with the Regex to truncate, we would need to get rid of the excess escaping backslashes: v_ListPrice =...

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

    o_Params.zapikey = "1003."; var r_QuotedRecord = ZDK.Apps.CRM.Connections.invoke("j_crm", "https://www.zohoapis.com/crm/v7/functions/fn_quotes_getquoteditems/actions/execute", "GET", 1, o_Params, o_Headers); // now parse the output from the function var...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  4. Zoho CRM: JS Widget: Generic Script to pass the Record ID to a CRM functionhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-js-widget-generic-script-to-pass-the-record-id-to-a-crm-function.html

    parameters for the function call var m_Params = { "arguments": JSON.stringify({ "p_AccountID": v_EntityID }) }; ZOHO.CRM.FUNCTIONS.execute( v_FuncName, m_Params ) .then( function( r_SubData ){ console.log("Raw response:", r_SubData); // Check if the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  5. Zoho Survey: Zoho CRM Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-survey-zoho-crm-webhook.html

    a CRM function as a REST API function but here goes a quick recap: Login to ZohoCRM as a user who has permission to create functions Create a CRM function, I'm calling mine "Fn - Submit Suspect Survey - Webhook" with internal name as...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  6. ZohoCRM & Xero: Function to pull most recent quoteshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-xero-function-to-pull-most-recent-quotes.html

    and instead puts the product name in the description field How? Because my head is a little fried, I'm putting the two functions I used here and I'll document further if I remember. Note that the pre-amble is to generate a Xero access token which I...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  7. Installing phpBB3 for Joomla with a RocketTheme templatehttps://www.joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

    sensitive and spelt exactly the same way) Fatal error: Call to a member function acl_get() on a non-object in /includes/functions_display.php on line 135 sometimes line 82 or a blank page. We found this seems to be related to some Virtuemart modules we...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  8. Invalid arguments passed in router.php on line 325https://www.joellipman.com/articles/cms/joomla/invalid-arguments-passed-in-routerphp-on-line-325.html

    The reason I've fixed it the way I did is because I don't need a router.php. The router.php file supposedly holds the two functions to: convert a system URL to a SEF URL convert a SEF URL back to a system URL My site has been switched to SEF in the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  9. Migrate Joomla! 1.5.x to 2.5.x+https://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

    privileges on the new database (only SELECT on the old database will do). Special care has been made to avoid the use of functions, stored procedures, temporary tables, etc. This allows broader compatibility and customers who do not have DBAs to run...

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

    Drive. Note that this example does not involve installing the Google Client Library for PHP. So no classes or built-in functions that you didn't write or know what they're doing. Why? The objective here is to upload a video file to my Google Drive. This...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  11. SSRS Hide results table if emptyhttps://www.joellipman.com/component/content/article/ssrs-hide-results-table-if-empty.html?catid=75&Itemid=165

    the query (SELECT @ncount:=@ncount+1), we're stuck with T-SQL. Ask Google how to iterate in T-SQL and you're confined to functions, temporary tables or little subroutines which just overcomplicates basic simple select queries... However set a counter to...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  12. Before and After, Highs and Lowshttps://www.joellipman.com/component/content/article/before-and-after-highs-and-lows.html?catid=75&Itemid=165

    on that dimension? HAVING is pointless, WITH ROLLUP is interesting, think I'm looking in the wrong place. Using Aggregate Functions? What follows is the T-SQL Query I finally went with. Lots of numbers but I think this pretty much answered my question:...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  13. Basic Oracle Function Structurehttps://www.joellipman.com/articles/else/database/oracle-pl-sql/basic-oracle-function-structure.html

    I need a function in it's simplest form and if I want to torture my successors, I'll complicate the function myself. How? Functions are supposed to return a single value, which is all I need in this case. In my example, I need to submit an Active...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
  14. No rows returned in Oracle causes SP to failhttps://www.joellipman.com/articles/else/database/oracle-pl-sql/no-rows-returned-in-oracle-causes-sp-to-fail.html

    are returned, and not a row of NULL/blank/empty values. Sounds confusing? That's just me, the answer was using two NVL functions which allowed the stored procedure to return no rows without erroring (ie. where rownum/rowcount = 0). Consider the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
  15. Data Randomization Function in Oracle PL/SQLhttps://www.joellipman.com/articles/else/database/oracle-pl-sql/data-randomization-function-in-oracle-plsql.html

    plethora of applications out there result in me using MySQL, Oracle PL/SQL and Transact SQL in my day job. The equivalent functions have to be written up all in the name of "seamless integration"... How? Previously I had tried to write a smart function...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
  16. PHP & MySQL Search Enginehttps://www.joellipman.com/articles/cms/website-development/php/php-a-mysql-search-engine.html

    $sanitized_search=(isset($_GET['search'])&&($sanitized_search==""))?trim(strip_tags(addslashes($_GET['search']))):""; # 2 functions to split up search terms and accepting double-quotes as phrase makers. function search_transform_term($term){ $term =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  17. Foreign Characters create symbols in PHP and MySQLhttps://www.joellipman.com/articles/cms/website-development/php/foreign-characters-create-symbols-in-php-and-mysql.html

    The final fix in my case was due to me not specifying some extra parameters on the htmlentities or htmlspecialchars PHP functions. My database stored the foreign characters as they were so the fault was somewhere between PHP reading from MySQL to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  18. Joes Quicklist Weblinks (JQW) Downloadshttps://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=105&Itemid=165

    3.1 AdrianaV/Vincent - Enhancement: Does not display more images then are available. - Enhancement: Auto-Check for cURL functions enabled on server. - Fixed Bug: cURL_Init uses encoded weblink URL in case of spaces. - Fixed Bug: Auto-Update via Joomla...

    • Type: Article
    • Author: Joel Lipman
    • Category: Downloads
    • Language: *
  19. Zoho Deluge - Get Current User IDhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-current-user-id.html

    being deprecated (end of life at the end of this year). So I'm familiar with the methods in API v2 or just using newer functions. Method #1: API v1 userResp =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB
  20. Zoho Deluge - Pad with leading Zeroshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-pad-with-leading-zeros.html

    like pretty old code and not wanting to cause offence, it isn't the JavaScript style or chain I like which appends the functions instead and is clearer for me personally to understand: // I want 010 v_NextIndex = 10; // yields 10 v_NextIndexStr =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB
Results 41 - 60 of 63