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

  1. Zoho Deluge: Connect to Shopifyhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-connect-to-shopify.html

    is not for an app embedded in the Shopify instance but for a third-party app, such as a Zoho Creator app, to connect to the data within Shopify. Why? At time of print, we have woken up to the news that including a username and password, or a client and...

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

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

    bank again and follow the wizard through. When it comes to the date filter, pay special attention to the date you select. Datacleansing / Tidy Up There's a strong chance of duplicate transactions; unique from the automatic feed, and some from your...

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

  3. Zoho Deluge - Multi-line Variable Assignments and Expressionshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-multi-line-statements-using-semi-colon-termination.html

    a map This builds a JSON string over several lines, then converts it into a map so values can be accessed by key. v_InputData = "{" + "\"ID\":\"TEST-1001\"," + "\"FirstName\":\"John\"," + "\"LastName\":\"Doe\"" + "}"; m_InputData = v_InputData.toMap();...

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

  4. K2 Items disappearhttps://www.joellipman.com/articles/cms/joomla/k2-items-disappear.html

    on line 145 So I checked these pages and the error is at a foreach() line where it's pulling data from the database. I asked to see the jos_k2_items table and it returned the following error: #145 - Table './jos_k2_items' is marked as crashed and should...

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

  5. Registered Users Cannot Login - Super Users Canhttps://www.joellipman.com/articles/cms/joomla/registered-users-cannot-login-super-users-can.html

    on ACL managers? How? In our case, the website had recently been migrated from Joomla 1.5.x to 2.5.x. I asked to examine the database and a quick scan in the assets table revealed 3 assets had the parent_id = 0. Only one asset can have that and that is...

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

  6. Upgrading Joomla CMS version 3.x to Joomla CMS 5.xhttps://www.joellipman.com/articles/cms/joomla/upgrading-joomla-cms-version-3-x-to-joomla-cms-5-x.html

    I'm used to doing this without any third-party extensions. I strongly recommend you do a backup beforehand of the database and of all your files Why? I keep getting complaints that my server wants to upgrade my PHP v7.x to PHP v8.x. I also get...

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

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

    navigate to different buttons on the toolbar. Ctrl+Shift+J Opens Developer Tools. Ctrl+Shift+Delete Opens the Clear Browsing Data dialog. F1 Opens the Help Center in a new tab (our favorite). Address bar shortcuts Use the following shortcuts in the...

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

  8. Android: Replace return key with done, go, send...https://www.joellipman.com/articles/else/app-dev/android-os/android-replace-return-key-with-done-go-send.html

    a user can enter any text value but if they typed a return character, the app would crash because it didn't understand the data. I tried replacing the new lines but just stopping the return key or trying to catch it is an obsolete method. How? The...

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

  9. Room Availability Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/component/content/article/room-availability-calendar-in-business-intelligence-development-studio.html?catid=75&Itemid=165

    wizard here but without it just add a matrix with [time] in the "column" and [room] in the "row" and [note/status] in the "data" cells. 2. Use the SQL code above: So you can paste this straight into the textarea or use "Query Builder". 3. Select Matrix...

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

  10. Before and After, Highs and Lowshttps://www.joellipman.com/component/content/article/before-and-after-highs-and-lows.html?catid=75&Itemid=165

    yesterweek, yestermonth, yesteryear and do the layout in PHP. Now let's say I have one RDL or SSRS Solution. I could do a dataset per SQL query but it doesn't seem that ideal. In Theory: SELECT ItemName, DATEPART(dayofyear, ItemDate) as DayOfYear,...

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

  11. SSRS Parameters in Oracle Stored Procedurehttps://www.joellipman.com/component/content/article/ssrs-parameters-in-oracle-stored-procedure.html?catid=75&Itemid=165

    did lead us to a workaround. So this is regarding an error when trying to add parameters to a Stored Procedure of an Oracle database from within Microsoft SQL Server Reporting Services. The Error ORA-00911: invalid character ORA-06512: at...

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

  12. How to Display Report Execution Time in SSRS (milliseconds)https://www.joellipman.com/component/content/article/how-to-display-report-execution-time-in-ssrs.html?catid=75&Itemid=165

    0 seconds was just confusing the end-user... Workaround #1 Although I'm convinced of a solution considering the ReportServer database will be able to tell you how many milliseconds it took for a report to execute... I decided to do a database level...

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

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

    Objective The plan will be to replace the default "" with a custom null entry and the end-user will be none the wiser. OLD: Dataset to populate the dropdown SELECT Name, ItemID FROM Catalog WHERE Type = 2 ORDER BY Name ASC NEW: Dataset to populate the...

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

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

    (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 query would take to recover the data and present it in a report, which would...

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

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

    16Gb one but my 32Gb ones have all failed at some point. I went for a cheap one on Play.com (Verbatim 32Gb@£49.99 & Kingston DataTraveler@?) and an even cheaper one on Ebay.com (Leather 64Gb@£29.99). In hindsight, the Ebay one was obviously going to...

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

  16. Run commands for Windowshttps://www.joellipman.com/component/content/article/run-commands-for-windows.html?catid=80&Itemid=165

    Setup Wizard netsetup.cpl Notepad notepad Nview Desktop Manager (if installed) nvtuicpl.cpl Object Packager packager ODBC Data Source Administrator odbccp32.cpl On Screen Keyboard osk Opens AC3 Filter (if installed) ac3filter.cpl Outlook Express msimn...

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

  17. Windows 10: Shortcut Apps to Settingshttps://www.joellipman.com/component/content/article/windows-10-shortcut-apps-to-settings.html?catid=80&Itemid=165

    & Internet Airplane mode ms-settings:network-airplanemode ms-settings:proximity Cellular & SIM ms-settings:network-cellular Data usage ms-settings:datausage Dial-up ms-settings:network-dialup DirectAccess ms-settings:network-directaccess Ethernet...

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

  18. Error during processing - Converting Date/Timehttps://www.joellipman.com/articles/else/database/t-sql/error-during-processing-converting-datetime.html

    was An error occurred during local report processing. An error has occurred during report processing. Cannot read the next data row for the dataset DataSet1. Conversion failed when converting date and/or time from character string. Basically I had to...

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

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

    but my SQL Server 2008 Management Studio doesn't like this and refuses to understand what I'm trying to do. Why? As this data seemed to be across various websites, I wanted a page which has all of them in one place. So here you go, I hope it's of some...

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

  20. T-SQL concatenate an incremental row numberhttps://www.joellipman.com/articles/else/database/t-sql/t-sql-concatenate-an-incremental-row-number.html

    This is a quick article on how to use a counter added to the end of a field column of data. Eh. What? Assume the following two tables exist: TABLE: Employee -------------------------------------------------- ID FirstName Surname 1 Joel Lipman 2 Another...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
Results 181 - 200 of 229