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

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

    and products if required m_Params.put("pageSize",v_PageSize); // // order by date descending (most recent first) - sometimes need to use Date%20DESC m_Params.put("order","UpdatedDateUTC DESC"); // // get the first page of Xero invoices...

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

    and products if required m_Params.put("pageSize",v_PageSize); // // order by date descending (most recent first) - sometimes need to use Date%20DESC m_Params.put("order","UpdatedDateUTC DESC"); // // get the first page of Xero Quotes r_AllXeroQuotes =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *

  3. ZohoBooks: Broken UK Banking Feedhttps://www.joellipman.com/articles/crm/zoho/zoho-books/zohobooks-broken-uk-banking-feed.html

    I made along the way. When a Zoho Books bank feed stops syncing in the United Kingdom, there are a few possible causes. Sometimes the issue is with the bank or the Open Banking token, but other times the feed itself becomes stuck and cannot be refreshed...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *

  4. Installing phpBB3 for Joomla with a RocketTheme templatehttps://www.joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

    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 had installed (well all...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *

  5. Anti-Spam override for all submitted datahttps://www.joellipman.com/articles/cms/joomla/anti-spam-override-for-all-submitted-data.html

    I used to have Captcha on my K2 by Joomlaworks but if you did the sound version, it didn't work properly. I found that sometimes the captcha wouldn't even match what you typed and what it displayed!!! I have written this article to be another one of...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *

  6. Protecting your Joomla Administrator Sectionhttps://www.joellipman.com/articles/cms/joomla/protecting-your-joomla-administrator-section.html

    any third-party extensions and will remain in place even if you update your Joomla CMS. Why? When checking audit logs, I sometimes see that my administrator url is accessed more than my front-end. The below has worked for me on Joomla websites in...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB

  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

    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 Responses: "In the Excel connection you cannot...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB

  8. Windows 7 Aero Featureshttps://www.joellipman.com/component/content/article/windows-7-aero-features.html?catid=80&Itemid=165

    surprised by the Aero features and weren't aware that these existed in Windows Vista (and originally from Linux variants). Sometimes you may only have partial Aero effects. This can be because Windows may not think your machine is powerful enough to run...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB

  9. T-SQL example of Case-Sensitive Soundexhttps://www.joellipman.com/articles/else/database/t-sql/t-sql-example-of-case-sensitive-soundex.html

    default values, let's use the example "Data Not Yet Available". Unfortunately the end-user reported these default values sometimes list twice, especially when the case is different, eg. "Data not yet available". The final system (qlikview) was...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB

  10. Developer's Checklist: Taking over a projecthttps://www.joellipman.com/articles/cms/website-development/developers-checklist-taking-over-a-project.html

    their technical knowledge/skills) Availability via Phone/Email/In person? (not relying on this but it can save time... sometimes) Service Transition Security rights/roles in the system (reasons for different accesses) Get all known logins (database,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *

  11. Is it a scam? Gumtree.com's warning signshttps://www.joellipman.com/component/content/article/is-it-a-scam-gumtreecoms-warning-signs.html?catid=116&Itemid=165

    laundering. A key warning sign should be any 'job' that involves you receiving cheques and cashing them. These jobs are sometimes referred to as ‘money mules’. Another warning sign is a job that doesn’t require a face to face interview. Other work from...

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *

  12. Docman - Uploaded a document and can't see ithttps://www.joellipman.com/articles/cms/joomla/docman-uploaded-a-document-and-cant-see-it.html

    As with all Joomla articles and files, you need to check that they have been published and approved. Sometimes you don't have to and it's all automatic, but if they're not showing: Check that they're in the right section and category Check that they...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *

  13. SELECT COUNT(DISTINCT name) FROM tablehttps://www.joellipman.com/articles/cms/joomla/select-count-distinct-name-from-table.html

    above statement. Why? The MySQL statement SELECT COUNT(DISTINCT name) FROM table is valid but I get what you mean and it's sometimes difficult to explain why you want to use it. How? Method #1: Add an alias to the field: -- Note the alias for the field...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *

  14. SSRS Border Problemhttps://www.joellipman.com/component/content/article/ssrs-border-problem.html?catid=75&Itemid=165

    You may find that BIDS or Report Builder (however you're building your report) will apply the border to some cells and sometimes a whole section of the report with just one border??? How? In Design view, click on the first cell (top-left), hold down the...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB

  15. MySQL Transactions in PHPhttps://www.joellipman.com/articles/else/database/mysql/mysql-transactions-in-php.html

    Sometimes it is critical to ensure a group of queries are all executed successfully to maintain the integrity of our data. Let's say we have a banking app where we need to subtract funds from one account and add funds to another: $mysqli->query...

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