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

  1. Zoho Deluge: Get All Orders from eBayhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-all-orders-from-ebay.html

    have on eBay (check eBay homepage and see number of sales [ will be rounded to nearest 1000 ]) // the actual number may be less than this but this is for pagination estimates v_MaximumOrders = 10000; v_Year = 2022; // // set the filter for orders by...

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

  2. Zoho Inventory: Enable Tracking using the APIhttps://www.joellipman.com/articles/crm/zoho/zoho-inventory/zoho-inventory-enable-tracking-using-the-api.html

    // // key here to enable inventory tracking m_CreateBooksItem.put("item_type","inventory"); // // other less important values to include re purchase information m_CreateBooksItem.put("product_type","goods"); m_CreateBooksItem.put("reorder_level",0);...

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

  3. ZCRM Client Script: Correct Decimal Fields OnLoadhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zcrm-client-script-correct-decimal-fields-onload.html

    on the decimal field even if that's not the field that is being changed: Decimal places for the Unit Price field should be less than or equal to 6 . How? The workaround for staff is to round this up manually and then save the record. But this can be an...

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

  4. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

    task: Create a workflow that runs on lead create (record action) and the criteria can be where "Lead Conversion Time" is less than 4 (4 days not 4 business days?). Though I've removed this condition since go live and simply specified "All Leads". I'm...

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

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

    Here's the immediate solution I have applied now until Zoho enable an option to round via API with a 10th of a penny/cent or less. After creating or updating the invoice, add in the response line something like the following: //... UPDATE INVOICE...

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

  6. Lazy stats: Yootheme / Gavick Pro / Rocket Theme Comparisonhttps://www.joellipman.com/articles/cms/joomla/lazy-stats-yootheme-and-gavick-pro.html

    So this is a comparison chart (at least in my opinion) of 3 major joomla template/extension providers. When I'm less caught up in work I'll try adding to this article. But here's some lazy stats: Package Comparison Table Personal Business Developer...

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

  7. Basic Joomla 2.5 Mootools Formhttps://www.joellipman.com/articles/cms/joomla/basic-joomla-25-mootools-form.html

    that Joomla versions 1.6 to 2.5 included in their basic install (vanilla/out-of-the-box). Will not work with Joomla 1.5 or less - Not 100% sure about this but I tried the example in the Official Joomla Documentation and I couldn't get it to work. They...

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

  8. ReCaptcha disappears from Joomla 2.5 Registrationhttps://www.joellipman.com/articles/cms/joomla/recaptcha-disappears-from-joomla-2-5-registration.html

    registration form... There are two solutions I have found that fix the problem: Method #1 I prefer this method as it changes less code and is more likely to be supported in a Joomla update. Open the file /plugins/captcha/recaptcha/recaptcha.php and find...

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

  9. Migrating from Joomla 2.5.x to 3.4.xhttps://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

    outline of the whole process: Backups Install Users Categories -- unstable Content Weblinks 3rd-party: JComments Here's a less brief outline of the whole process: Pre-Notes: To begin with, ensure that no extra new users are created in the v34 system...

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

  10. Battery Constantly Drained on iPhonehttps://www.joellipman.com/component/content/article/battery-constantly-drained-on-iphone.html?catid=60&Itemid=165

    order to "remind you". The reminder here was to charge the phone but it was the reminder which would drain a full charge in less than a day.

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

  11. SSRS Zero Paddinghttps://www.joellipman.com/component/content/article/ssrs-zero-padding.html?catid=75&Itemid=165

    in the format of -12345. If we want to look them up the error is ORA-12345. Unfortunately Oracle also returns errors of less than 10000 so ORA-00201 would actually be returned as "-201". As I wanted a link so that the user can just click on this link...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *

  12. SSRS Dropdown parameter cannot be blank!https://www.joellipman.com/component/content/article/ssrs-dropdown-to-allow-blank-values.html?catid=75&Itemid=165

    with the charts saying "No Data Available" but I find this better then the alert message "parameter cannot be blank!" and less confusing to the end-user. If this bugs you, you can always include a custom message which displays on top if all 4 parameters...

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

  13. SSRS: Performance Improvements: SELECT TOPhttps://www.joellipman.com/component/content/article/ssrs-performance-improvements-select-top.html?catid=75&Itemid=165

    form in a SQL Server Reporting Services (SSRS) environment. The requirement (amongst others) was that the report ran in less than a few seconds. Analyzing the report through the ReportServer databases (internal auditing) only showed how long the SQL...

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

  14. Windows 7: System Clock is constantly going out of synchttps://www.joellipman.com/component/content/article/windows-7-system-clock-is-constantly-going-out-of-sync.html?catid=80&Itemid=165

    every day, you would use 86400, or 60 seconds * 60 minutes * 24 hours * 1 day. I wouldn’t recommend setting this to anything less than 4 hours worth, or your computer might get banned by the time servers. Change Your Firewall Settings Third party...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *

  15. Drop If Object Existshttps://www.joellipman.com/articles/else/database/t-sql/drop-if-object-exists.html

    it exists IF OBJECT_ID ( '[dbo].[myUserTable]', 'U' ) IS NOT NULL DROP TABLE [dbo].[myUserTable]; GO Types for sys.objects (less used by me) AF = Aggregate function (CLR) C = CHECK constraint D = DEFAULT (constraint or stand-alone) F = FOREIGN KEY...

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

  16. Fix Oracle Tnsping 3511 without Windows Registryhttps://www.joellipman.com/articles/else/database/oracle-pl-sql/fix-oracle-tnsping-3511-without-windows-registry.html

    databases the same version? It's due to the fact that these aren't our databases, we simply help support them. You say less than ideal, I say realistic. Quit complaining about processes and management and instead prove your worth. I'm good at what I do...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB

  17. MySQL: Count occurrences of words in a columnhttps://www.joellipman.com/articles/else/database/mysql/mysql-count-occurrences-of-words-in-a-column.html

    GROUP BY `value` ORDER BY `total` DESC LIMIT 0,50; Additional Note(s): I have added a WHERE clause which omits words less than 5 characters in length, and some other words not to count. I have added the ORDER BY to give me the highest count first in...

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

  18. Difference between two dates - the midnight hourhttps://www.joellipman.com/articles/cms/website-development/difference-between-two-dates-the-midnight-hour.html

    please)? The Solution Eureka! Or duh! for those that it's obvious to... Compare the two timestamps, if the "To date" is less than the "From date" then add 1 day to the date: $thisDateSQL=date("Y-m-d", strtotime($sub_row['DateSession']));...

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

  19. Joes Quicklist Weblinks (JQW) Downloadshttps://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=105&Itemid=165

    AutoDebug: Display module parameters. - Fix Bug: Removed check for "approved" column in weblinks. - Applies to PHP v5.3 or less - Date Uploaded: Fri, 21st Jun 2013 2.2 - Removed popups option - Added Parameter: Optional Registration Key - Added...

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

  20. DJI Phantom FC40 Paint-Job and AerialFreaks Cyclops FC40 Gimbal Upgradehttps://www.joellipman.com/component/content/article/dji-phantom-fc40-paint-job-and-aerialfreaks-cyclops-fc40-gimbal-upgrade.html?catid=113&Itemid=165

    but it's coming out really nicely Sparkly! and Shiny Hmm... wrong way round, the compass cable seems to go across the unit unless I have the top sticker wrong Legs on Checking vents (note I had masked these before painting as per youtube videos)...

    • Type: Article
    • Author: Joel Lipman
    • Category: Quadcopters
    • Language: *
Results 21 - 40 of 41