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

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

    previous solution. I wanted to use a regex rather than treat the number as a string and truncate it that way. Given the possible options of numbers given, it has to work with every number so here's both in Zoho Deluge Tryout: v_Rate = 12345.545; info...

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

    - 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. Migrate Joomla! 1.5.x to 2.5.x+https://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

    the Joomla Web-based Installation GUI until the process deletes the Installation folder. Avoid installing Sample Data if possible (there will be some but this script has been reworked to potentially accommodate). Download my migration script Decide on...

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

    then leave this as having a parent_id of 0. The fix is immediate after the change is committed to the database. NTS: Possible Related Error: "You cannot access the private section of this site"

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  5. Keyboard and mouse shortcuts in Google Chromehttps://www.joellipman.com/component/content/article/keyboard-and-mouse-shortcuts-in-google-chrome.html?catid=61&Itemid=165

    bar drop-down menu with your keyboard arrows, then press Shift+Delete. Deletes the entry from your browsing history, if possible. Click an entry in the address bar drop-down menu with your middle mouse button (or mousewheel). Opens the entry in a new...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  6. Sort order a dropdown list in MS InfoPath without programminghttps://www.joellipman.com/component/content/article/sort-order-a-dropdown-list-in-ms-infopath-without-programming.html?catid=73&Itemid=165

    specify the column to sort by. Save the view by clicking the OK button. You'll be returned to your datasheet and it's possible it isn't in any different order. I re-checked out my InfoPath form, looked at the dropdown that was already configured to read...

    • Type: Article
    • Author: Joel Lipman
    • Category: Infopath
    • 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

    rows to act as dividers. Microsoft Certified Responses: "In the Excel connection you cannot skip Nth rows." "It is not possible." I am shocked at how responses to this and opinions vary between "Microsoft Certified Professionals", just a piece of paper...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  8. Remove write-protect from USB pen in Windowshttps://www.joellipman.com/component/content/article/remove-write-protect-from-pen-in-windows.html?catid=80&Itemid=165

    It’s called Urescue and it’s become my favourite program (despite the fact that I want to need to use it as little as possible, i.e. once)!!! To find it go to http://emea.apacer.com/en/support/downloads.asp then search for “AH128 Handy Steno Repair...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
  9. Windows 7 Aero Featureshttps://www.joellipman.com/component/content/article/windows-7-aero-features.html?catid=80&Itemid=165

    enough to run these effects without affecting performance. If this is happening to you, and you don’t mind about a possible slight slow down on performance you can force enable them - Go to Control Panel -> System and Security -> System Click on...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
  10. DataTumble - Randomize Data Rowshttps://www.joellipman.com/articles/else/database/t-sql/datatumble-randomize-data-rows.html

    a table. ** ** The process will mix the Data using a random function. ** ** Once the Data has been scrambled it won't be possible to get the original set of Data. ** ** ** ** Usage Examples: ** ** EXEC usp_ScrambleMultivalue 'dbo.TableA', 'ColumnNameA';...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  11. MySQL: Find records in one table that are not in another.https://www.joellipman.com/articles/else/database/mysql/mysql-find-records-in-one-table-that-are-not-in-another.html

    when I work this out without using two SQL scripts. Currently I've returned to the process where one SQL query returns all possible results and the PHP script runs another SQL query for each row to check the ID does not exist in the audit table... --...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  12. htaccess Rewrites SEF URL and submits to PHPhttps://www.joellipman.com/articles/cms/website-development/php/htaccess-rewrites-sef-url-and-submits-to-php.html

    my error rules (they basically redirect to a branded error page). So I sanitize on the receiving index.php file: Check for possible Code Injection Do NOT allow the use of apostrophe or double-quotes, convert these to a numerical representation only if...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  13. DJI Phantom FC40 - Fun at the raceshttps://www.joellipman.com/component/content/article/dji-phantom-fc40-fun-at-the-races.html?catid=113&Itemid=165

    whole track beforehand and plan a route). Strong Winds: Fighting the wind to keep up with the cars. Keep as much space as possible between our marshall. Not Near People: I could not risk flying low so I took a measure of about 3 people high and stood so...

    • Type: Article
    • Author: Joel Lipman
    • Category: Quadcopters
    • Language: *
  14. Proposed Budget i3 PC under £200https://www.joellipman.com/component/content/article/proposed-budget-i3-pc-under-200.html?catid=116&Itemid=165

    equipment and the verdict is that our workstations need upgrading (it always is). So on a budget (ie. as cheap as possible), we'll skip Windows 8 and wait for Windows 9, but in the meantime we need something that flows as smooth as any other Microsoft...

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *
  15. 404: Page Not Foundhttps://www.joellipman.com/component/content/article/404.html?catid=50&Itemid=165

    Sorry, but the content you requested could not be found. It is possible that you have followed an out-of-date link or incorrectly typed an address. We have revamped this website as of September 2015 and tidied up some of our URLs. Some sections will...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  16. MySQL Transactions in PHPhttps://www.joellipman.com/articles/else/database/mysql/mysql-transactions-in-php.html

    WHERE 'user' = 'Fred'"); What if one of the queries fails? To mitigate the chances of misplacing our millions due to some possible error we must ensure that both queries are executed with the expected result before committing any changes to the data....

    • Type: Article
    • Author: Ike Francis
    • Category: MySQL
    • Language: en-GB
Results 21 - 36 of 36