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

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

    */ // attempt try { // get the type of invoice selected var v_InvoiceType = ZDK.Page.getField('Invoice_Type').getValue(); // check source quote is specified var v_QuoteID = ZDK.Page.getField('Converted_From_ID').getValue(); // only make changes to the...

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

    ZOHO.CRM.FUNCTIONS.execute( v_FuncName, m_Params ) .then( function( r_SubData ){ console.log("Raw response:", r_SubData); // Check if the response contains the expected structure let output = r_SubData?.details?.output; // If the output is JSON text,...

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

    for each m_XeroContact in l_XeroContacts { if(!isNull(m_XeroContact.get("ContactID"))) { // // to check if we want to update the CRM record for the account v_XeroTime = m_XeroContact.get("UpdatedDateUTC"); d_XeroAccountLastUpdated =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  4. Community Builder in Joomla Vulnerabilityhttps://joellipman.com/articles/cms/joomla/community-builder-in-joomla-vulnerability.html

    either the above error or the alert that a malware was detected: congratulations! you've been hacked. So first of all check that this is not just a hack to your index.html file in your web root folder (you may find a .heder.php file as well in your...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  5. Migrate JComments from Joomla 1.5.x to Joomla 2.5.xhttps://joellipman.com/articles/cms/joomla/migrate-jcomments-from-joomla-15x-to-joomla-25x.html

    userid, name, username, email, homepage, title, comment, ip, date, isgood, ispoor, published, subscribe, source, source_id, checked_out, checked_out_time, editor ) SELECT id, parent, CASE WHEN SUBSTRING(path, LOCATE(',', path)+1, LOCATE(',', path,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  6. Basic Joomla 2.5 Mootools Formhttps://joellipman.com/articles/cms/joomla/basic-joomla-25-mootools-form.html

    #ccc; width:300px; float:left; } Basic Mootools Form in Joomla 2.5 Basic Mootools Form in Joomla 2.5 Name: E-Mail: Sample CheckBox: Sample SelectList: yes no Ajax Response Ready, Willing and Able Big Note: UPDATE 2012 It is important to refer to the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  7. Joomla article modal with clear buttonhttps://joellipman.com/articles/cms/joomla/joomla-article-modal-with-clear-button.html

    paste the below into a PHP file and include it in your component, the solution is really that straightforward. Feel free to check for any dodgy code but I've simply added the clear button to the existing article modal file (Joomla 1.6.x to 2.5.x). Don't...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  8. Registered Users Cannot Login - Super Users Canhttps://joellipman.com/articles/cms/joomla/registered-users-cannot-login-super-users-can.html

    Database Settings : Database Tables Prefix It should be a short alphanumeric value with a trailing underscore (eg. "abc12_") Check if you have more than one asset with a parent_id equal to zero: SELECT COUNT(*) FROM #__assets WHERE parent_id=0 -- where...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  9. ReCaptcha alternative: Integrate PlayThru in JComments 2.3 for Joomla 2.5https://joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-for-joomla.html

    On the dashboard, note the Scoring key (eg. "64d6d442b7e846acfaacef642e1ad173b35503") On the dashboard, check the site URL matches the domain you are trying this on (eg. if you are testing on "http://test.mycompany.com" then the site specified in the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  10. ReCaptcha alternative: Integrate PlayThru in JComments 3.0 for Joomla 3.2https://joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-3-0-for-joomla-3-2.html

    On the dashboard, note the Scoring key (eg. "64d6d442b7e846acfaacef642e1ad173b35503") On the dashboard, check the site URL matches the domain you are trying this on (eg. if you are testing on "http://test.mycompany.com" then the site specified in the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  11. Warning: Save failed. Another menu item has the same aliashttps://joellipman.com/articles/cms/joomla/warning-save-failed-another-menu-item-has-the-same-alias.html

    item has the same alias in Root. Root is the top level parent You will need: Access to the Joomla Administration Panel (to check for and remove expired menu items) A good database administrator who is comfortable with making changes to the database Why?...

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

    python Upgrade to latest PIP: pip3 install --user --upgrade pip Install Numpy As user (safest): pip3 install --user numpy Check numpy version python3 -c "import numpy; print(numpy.__version__)" Use OpenAI Whisper Install Whisper using PIP: pip3 install...

    • Type: Article
    • Author: Joel Lipman
    • Category: Apple
    • Language: *
  13. Setting up your store to use SSLhttps://joellipman.com/articles/else/e-commerce/setting-up-your-store-to-use-ssl.html

    browser it should be setup ok. Again, if you have any error messages or warnings please conatct your hosting company. To check Virtuemart under SSL you will need to go to the install location. In our example this would be:...

    • Type: Article
    • Author: Joel Lipman
    • Category: eCommerce Systems
    • Language: *
  14. List MediaWiki Articleshttps://joellipman.com/articles/cms/mediawiki/list-mediawiki-articles.html

    WHERE p.page_namespace=0 AND t.old_text='' AND p.page_is_redirect=0 My custom query To list access levels (this needs to check categories with access levels table), I have a separate table containing the wiki categories associated with local wiki groups...

    • Type: Article
    • Author: Joel Lipman
    • Category: MediaWiki
    • Language: en-GB
  15. Android Java: Remove first two entries from Google News feed in SimpleRssReaderhttps://joellipman.com/articles/else/app-dev/android-os/android-java-remove-first-two-entries-from-google-news-feed-in-simplerssreader.html

    News feed. Modifying the strings can be done in the PcWorldRssParser.java (without it crashing the app). The gist is to check for a description (the first two items do not have one). The following will also return a publishing date: Find the List...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  16. Android: Function to let user take photo or choose existinghttps://joellipman.com/articles/else/app-dev/android-os/android-function-to-let-user-take-photo-or-choose-existing.html

    } } Just in case The ImageView I have (minus the width, height, margins, etc): Additional To check if the user has a camera beforehand, apparently if(hasSystemFeature(PackageManager.FEATURE_CAMERA)) is a way to go. I haven't tested yet as I need a...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  17. SSIS Convert a string into a datehttps://joellipman.com/component/content/article/ssis-convert-a-string-into-a-date.html?catid=74&Itemid=165

    character value for cast specification". Exceptions for text file where I needed two derived column tasks, the first checks if the Date was blank and puts a NULL string. The second takes this string and converts it to a date: -- Assuming EndDate is...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  18. Room Availability Calendar in Business Intelligence Development Studiohttps://joellipman.com/component/content/article/room-availability-calendar-in-business-intelligence-development-studio.html?catid=75&Itemid=165

    hour of the day SET @EndTime = @GivenDate + ' 23:30:00'; --First time of the day (required to display empty rooms) END Add check to SQL to remove rooms with no name. Show hour in top column only on the hour =IIF(MINUTE(Fields!Time.Value)=30, "",...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  19. SSRS Hide results table if emptyhttps://joellipman.com/component/content/article/ssrs-hide-results-table-if-empty.html?catid=75&Itemid=165

    WHERE re.RoomId=@GivenRoom AND re.SetId=@setId Reminder: The counter = 1 means that if I call on the sum of these, I can check if zero rows were returned because Sum(Fields!Counter.Value, "Equipment") should come back as zero. MDX Expression: One final...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  20. SSRS Querying on either of 2 Parametershttps://joellipman.com/component/content/article/ssrs-querying-on-either-of-2-parameters.html?catid=75&Itemid=165

    to populate itself if it is left blank when the report is executed. So my first dataset has to include the Username check as well (…WHERE StudentID=@StudentReference OR StudentName=@StudentADAccount). And according to other web articles on this matter,...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
Results 121 - 140 of 173