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

  1. ZohoCRM & Xero: Function to pull most recent invoiceshttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-xero-function-to-pull-most-recent-invoices.html

    - Date Created: 2025-10-13 (Ascent Business - Joel Lipman) - Initial release Date Modified: ??? - ??? More Information: Ensure that all possible tax rates in Xero match those in Zoho (eg. 20.000, 17.500, 15.000, 10.000, 5.000,...)...

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

    Inputs: - Outputs: - Date Created: 2025-10-13 (Joel Lipman) - Initial release Date Modified: ??? - ??? More Information: Ensure that all possible tax rates in Xero match those in Zoho; the output of this function will give you a copy&paste list...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  3. ZohoBooks: Broken UK Banking Feedhttps://joellipman.com/articles/crm/zoho/zoho-books/zohobooks-broken-uk-banking-feed.html

    accounts: Deleting a bank account can affect balances and reconciliations. Always confirm with Zoho before deletion to ensure historical manual imports are preserved. Manual import workaround: During any downtime, you can manually upload transactions...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  4. Could not instantiate mail functionhttps://joellipman.com/articles/cms/joomla/could-not-instantiate-mail-function.html

    with Dovecot/Maildir): /var/spool/virtual/domain.com 770 username:mail /var/spool/virtual/domain.com/* 660 username:mail 8) Ensure your hostname does not contain any upper case letters. 9) Make sure that your main server IP has a reverse lookup on it.

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  5. Creating a custom form field type for Joomla XML fieldsethttps://joellipman.com/articles/cms/joomla/creating-a-custom-form-field-type-for-joomla-xml-fieldset.html

    on some dynamic variables. Why? In Joomla, the XML type of "sql" is extremely limited. The component I'm making has to ensure user's can only see their own projects and not everyone's: SELECT * FROM #__projects ORDER BY name -- yields all projects...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  6. 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

    an about-us page but I already have two items using the alias "about" and "about-us": Login to the Joomla Admin Panel and ensure any similar menu items are accounted for. Remove them if they are not used. Create the menu item that caused the warning but...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  7. Basic Android App using Google Maps and Current Locationhttps://joellipman.com/articles/else/app-dev/android-os/basic-android-app-using-google-maps-and-current-location.html

    if you are still getting problems, I have the following fields that I also use related to Google Maps v2: Last Additional Ensure that when Google asks for your Android API key, you enter the production key (which may be the same as your testing key);...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  8. Android: Keytool and Google Maps displaying greyhttps://joellipman.com/articles/else/app-dev/android-os/android-keytool-and-google-maps-displaying-grey.html

    Windows 7 Pro Android Studio v0.8.6 beta Java Development Kit v1.8.0_20 What? The article below serves as a checklist to ensure I don't release an app that only displays maps to myself (again). Why? This took me a while to figure out so hopefully this...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  9. Transferring Apps (purchases) from iPhone 4s to 5s on a Windows PChttps://joellipman.com/articles/else/app-dev/ios/transferring-apps-purchases-from-iphone-4s-to-5s-on-a-windows-pc.html

    after having gone through the process of setting up the phone and finishing on the "Get Started" (including Touch ID). Ensure your old phone's iOS is fully updated. (I did this while the phone was NOT connected to the computer, ie via the Settings >...

    • Type: Article
    • Author: Joel Lipman
    • Category: iOS
    • Language: *
  10. SSRS External Images don't displayhttps://joellipman.com/component/content/article/ssrs-external-images-dont-display.html?catid=75&Itemid=165

    two of the above worked for us, which indicated an issue with the credentials we were using to access the the photos, so: Ensure the "Unattended User Account" can see the photos. - This solved the problem for us Some forums suggested to put this user...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  11. Returning Oracle Stored Procedure Resultset in SSRShttps://joellipman.com/component/content/article/returning-oracle-stored-procedure-resultset-in-ssrs.html?catid=75&Itemid=165

    a dataset Follow these steps carefully. I've added some screenshot images to help and highlighted areas which you should ensure are correct (or which applies to your report) 4a. Add a dataset: query type "Stored Procedure" Click on the radio button when...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  12. Include a carriage return in a column headinghttps://joellipman.com/component/content/article/include-a-carriage-return-in-a-column-heading.html?catid=78&Itemid=165

    the Excel spreadsheet for it to wrap text and save the file. Hereafter, you will NOT need to do this on each data refresh. Ensure that there is a trailing space after the label and before the carriage return otherwise the column will return as one word...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server
    • Language: *
  13. Windows OS: Alt Codes / Symbols / Special Charactershttps://joellipman.com/component/content/article/windows-os-alt-codes-symbols-special-characters.html?catid=80&Itemid=165

    but there will be times when you have lost the formatting and get weird question mark characters instead such as: . How? Ensure you are using the numbers on your numeric keypad and NOT the numbers at the top of your keyboard for the following steps....

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  14. Accessing a MySQL Database with Business Intelligence Development Studiohttps://joellipman.com/articles/else/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

    the local server machine, or enable remote errors I fixed this by repeating stages 1 and 2 (above) on the Reporting Server. Ensure you name them the same thing as you did in the report. I am looking at ways of doing this without logging into the...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  15. Convert foreign characters to English alphabethttps://joellipman.com/articles/else/database/mysql/convert-foreign-characters-to-english-alphabet.html

    This is nice but its search engine doesn't work properly as it thinks "riviere" is different to "rivière". We need to ensure that a search for any of these kind of words will return results of similarly typed/sounding words. How? Here's just a splurge...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  16. Regular Expression Basic Usage Exampleshttps://joellipman.com/articles/cms/website-development/regular-expression-basic-usage-examples.html

    in your regular expression where only one character would otherwise be allowed. For example, you can use this operator to ensure that the collating sequence 'ch', when defined in a locale such as Spanish, is treated as one character in operations that...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  17. Inline Labels in Form Fields using Javascripthttps://joellipman.com/articles/cms/website-development/js/inline-labels-in-form-fields-using-javascript.html

    field is empty, if it is, change the value back to "Name:" and the color back to grey. If it isn't, then leave as is and ensure the color is still black. Additional Note that instead of just saying if this value equals "Name:" I've added some code to...

    • Type: Article
    • Author: Joel Lipman
    • Category: JavaScript
    • Language: en-GB
Results 41 - 57 of 57