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

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

    if 1 of the 2 invoice types selected if ((v_InvoiceType == "Deposit" || v_InvoiceType == "Final Balance") && v_QuoteID != null) { // prompt with a confirmation box var b_Proceed = ZDK.Client.showConfirmation('Changing Invoice Type to '+v_InvoiceType+'...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  2. Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttps://www.joellipman.com/articles/crm/zoho/zoho-analytics/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

    > i."Response Date" OR (j."Response Date" = i."Response Date" AND j."Attempt ID" > i."Attempt ID")) WHERE j."Attempt ID" IS NULL GROUP BY i."Attempt ID", i."Page Number" Export the web chart from Analytics and attach as an image on the CRM record So the...

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

    WHERE `name` LIKE '%.category.%' ORDER BY `lastcatid` DESC LIMIT 0,1); SET @new_jos_assets_last_inc=( SELECT IFNULL(@new_jos_assets_last_inc, 0)); SET @new_jos_assets_id_last_lft=( SELECT MAX(`lft`) FROM `my_new_database`.my_prefix_assets); SET...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  4. MacOs: Transcribe Training Video using OpenAI Whisperhttps://www.joellipman.com/component/content/article/macos-transcribe-training-video-using-openai-whisper.html?catid=60&Itemid=165

    -U openai-whisper Determine PATH of Whisper: find ~/.local/bin /usr/local/bin ~/Library/Python/*/bin -name whisper 2>/dev/null Add to PATH Edit your zsh file: nano ~/.zshrc Append the PATH line: export PATH="$PATH:/Users/yourname/Library/Python/3.9/bin"...

    • Type: Article
    • Author: Joel Lipman
    • Category: Apple
    • Language: *
  5. List all cron jobs for all usershttps://www.joellipman.com/component/content/article/list-all-cron-jobs-for-all-users.html?catid=63&Itemid=165

    Insert the user's name between the # five time fields and the command. while read user ; do crontab -l -u "${user}" 2>/dev/null | clean_cron_lines | sed --regexp-extended "s/^((\S+ +){5})(.+)$/\1${user} \3/" >>"${temp}" done <

    • Type: Article
    • Author: Joel Lipman
    • Category: Linux
    • Language: *
  6. MessageBox or AlertDialog in Android Javahttps://www.joellipman.com/articles/else/app-dev/android-os/messagebox-or-alertdialog-in-android-java.html

    // get the AlertDialog XML layout file final View v = getLayoutInflater().inflate(R.layout.my_custom_dialog, null); // set the hint of the EditText in the AlertDialog EditText inputText = (EditText) v.findViewById(R.id.hangar_item_menu_name_field);...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  7. SSIS Skip Rows in Excel Source filehttps://www.joellipman.com/component/content/article/ssis-skip-rows-in-excel-source-file.html?catid=74&Itemid=165

    We add a conditional split task to the data flow which only passes through rows from the Excel sheet which are not blank/null. Browsing the net, I found this is sometimes also used for inserting blank rows to act as dividers. Microsoft Certified...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  8. SSIS Multiple Lookups in onehttps://www.joellipman.com/component/content/article/ssis-multiple-lookups-in-one.html?catid=74&Itemid=165

    LEFT JOIN [sourcedb].[dbo].[lookup_ethnicities] f ON x.student_ethnicity_code=f.lookup_ethnicity_code Note this also allows NULLs so, our sequence identifier and student reference are never blank so it is safe to to use "Lookup Match Output" as rows...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  9. Stored Procedure to List Distinct Values and Countshttps://www.joellipman.com/articles/else/database/t-sql/stored-procedure-to-list-distinct-values-and-counts.html

    means I only specify the table and then the columns. How? IF OBJECT_ID('usp_ListDistinctValuesAndCounts', 'P') IS NOT NULL DROP PROCEDURE [usp_ListDistinctValuesAndCounts]; GO CREATE PROCEDURE [usp_ListDistinctValuesAndCounts] ( @p_SearchTable...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  10. Preg_Replace all strings between two tagshttps://www.joellipman.com/articles/cms/website-development/php/preg-replace-all-strings-between-two-tags.html

    = preg_replace( '/@[a-z]+/i','$0', $string_original); -- METHOD #2: equivalent using preg_match_all $matches = null; preg_match_all('/(?!\b)(@\w+\b)/',$string_original,$matches); foreach ($matches as $match) { foreach ($match as $mystring) {...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *
  11. 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

    quoted by the PHP htmlspecialchars: "As of PHP 5.4 they changed default encoding from "ISO-8859-1" to "UTF-8". So if you get null from htmlspecialchars or htmlentities..." Source: PHP Manual My fix (in some cases): $my_description =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  12. Make bootstrap carousel responsive to swipehttps://www.joellipman.com/articles/cms/website-development/bootstrap/make-bootstrap-carousel-responsive-to-swipe.html

    } } function h(){ this.removeEventListener("touchmove",o),u=null,c=!1 } var u,c=!1;"ontouchstart"in document.documentElement&&this.addEventListener("touchstart",e,!1) } ),this } }(jQuery); $('.carousel').bcSwipe({ threshold: 50 }); Source(s): Stack...

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

    users = userResp.executeXPath("/users/user"); if ((users != null) && (users != "")) { userList = users.toList("-|-"); for each user in userList { emailNode = user.executeXPath("/user/@email"); email = emailNode.executeXPath("/email/text()"); if (email...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB
Results 61 - 73 of 73