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

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

    A follow-on article from my previous article ZohoCRM & Xero: Function to pull most recent invoices - along with their Contacts and Items (accounts/contact & products respectively). Why? This took me so much longer than I thought it would. It was meant...

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

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

    error: Accounts associated with Integration cannot be marked Inactive Summary In this case, the client’s bank account had previously been syncing correctly. After several weeks, however, the feed stopped updating, and the option to Refresh Feed was...

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

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

    module" button. Make sure "enabled" is selected in the radio buttons and click on the "Submit" button. Click on "Back to previous page" This will create a module category called ROKBB3 which you should click on to go into. In the bottom right, you can...

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

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

    interested in logging into the administrator section). Updated for Joomla 3.x but pretty much the same system as used for previous versions of Joomla. I hope this helps you tune down those pesky visitors.

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

  5. Basic Android App using Google Maps and Current Locationhttps://www.joellipman.com/articles/else/app-dev/android-os/basic-android-app-using-google-maps-and-current-location.html

    cameraPosition = new CameraPosition.Builder() .target(myCoordinates) // Sets the center of the map to LatLng (refer to previous snippet) .zoom(17) // Sets the zoom .bearing(90) // Sets the orientation of the camera to east .tilt(30) // Sets the tilt of...

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

  6. SSIS Convert a string into a datehttps://www.joellipman.com/component/content/article/ssis-convert-a-string-into-a-date.html?catid=74&Itemid=165

    "00000000" -- Derived column task 2: Add as new Column 'DC_Date' -- (note this is a separate task in the data flow to the previous one): (ISNULL(Date) || (TRIM(Date) == "00000000")) ? NULL(DT_DBTIMESTAMP) : (DT_DBTIMESTAMP)(SUBSTRING(Date,5,4) + "-" +...

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

  7. SSRS External Images don't displayhttps://www.joellipman.com/component/content/article/ssrs-external-images-dont-display.html?catid=75&Itemid=165

    image if file does not exist More of a workaround than a solution but by asking some colleagues who developed the previous version (using 3rd-party components other than Microsoft SSRS) that the existence of a photo depended on the status of a student...

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

  8. Performance Report - Background colors based on dataset valueshttps://www.joellipman.com/component/content/article/green-red-background-colors-based-on-dataset-values.html?catid=75&Itemid=165

    would fail an accessibility test but visually it says straight away which is the better report; and when comparing to the previous runs (using a second dataset) you can tell where changes were made and how this affected the reports' performance. What?...

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

  9. Returning Oracle Stored Procedure Resultset in SSRShttps://www.joellipman.com/component/content/article/returning-oracle-stored-procedure-resultset-in-ssrs.html?catid=75&Itemid=165

    integration"). Yes, I'm trying to get an SSRS report to display the results from an Oracle stored procedure. I have a previous article describing a basic stored procedure in Oracle, this article aims to outline how to apply this to an SSRS 2008 R2...

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

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

    windows. Keep holding the Microsoft Logo key and pressing the Tab key to rotate between the different windows. As with previous versions of MS Windows, holding down the Alt key and pressing Tab will give you the more traditional window switcher (2D)....

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

  11. Apple Magic Trackpad with Windows 11 Intelhttps://www.joellipman.com/component/content/article/apple-magic-trackpad-with-windows-11-intel.html?catid=80&Itemid=165

    64) workstation. Why? I forgot my work Macbook at home and rather than drive the commute back and forth again, I took my previous biscuit box out (a Dell MFF Optiplex 7070) and spent 30 minutes connecting monitors and the logitech receiver for my...

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

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

    dataset DataSet1. Conversion failed when converting date and/or time from character string. Basically I had to look at a previous report and it was just the way I was inserting the parameters into my query. Once you've added your parameters (date/time...

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

  13. Convert to Proper Case in T-SQLhttps://www.joellipman.com/articles/else/database/t-sql/convert-to-proper-case-in-t-sql.html

    any leading and trailing spaces SET @Ret = LTRIM(RTRIM(@Ret)); -- capitalize first character of data irrespective of previous rules SET @Ret = UPPER(SUBSTRING(@Ret,1,1)) + SUBSTRING(@Ret,2,LEN(@Ret)); END ELSE BEGIN -- return the string unaffected if it...

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

  14. MySQL: Display Users and Duration in Matrix Timesheethttps://www.joellipman.com/articles/else/database/mysql/mysql-display-users-and-duration-in-matrix-timesheet.html

    per week per user 3. Combine in a loop to run query against each user. Post-Notes (Update 2012) The performance of the previous version of this query was pretty abysmal and worse if you want to list users who have no associated activities (outer join...

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

  15. Delete related records from multiple tableshttps://www.joellipman.com/articles/else/database/mysql/delete-related-records-from-multiple-tables.html

    refer to the table after the DELETE clause. Rather straightforward but I got this answer from StackOverflow. Based on the previous example, here's the query to only delete records in Session and SessionStudent represented by aliases s and sst...

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

  16. A quick run through of setting up an export process in SITShttps://www.joellipman.com/articles/cms/website-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

    menu system Enter a EOR code (for everyone's sanity, name it something similar to the DOR code) Complete the form as per previous details ensuring you use the same Message Group as the DOR. In our example, our Type is "SQL db connector" and we use a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Extensible Markup Language
    • Language: *

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

    X4 H107C This model is the DJI Phantom FC40 so the first Phantom (v1.2?) with DJI's own FC40 camera It had had a bad crash previously and loosening some of the screws snapped the edges back into place. I thought why stop there? The anatomy of a DJI...

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

  18. Proposed Budget i3 PC under £200https://www.joellipman.com/component/content/article/proposed-budget-i3-pc-under-200.html?catid=116&Itemid=165

    System (in this case Microsoft Windows 7 Pro 32-bit) nor the chassis as we merely transferred the license from our previous machines.

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

  19. Zoho Deluge: Check Time Booking Slotshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-check-time-booking-slots.html

    get in my head the logic if checking a requested time slot isn't a double-booking (as in, the time slot doesn't overlap a previous booking. How? Given a date/time and a duration, we will work out the requested start and end time: req_StartTime =...

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

  20. Restoring your WYSIWYG editor after upgrading Joomlahttps://www.joellipman.com/articles/cms/joomla/restoring-your-wysiwyg-editor-after-upgrading-joomla.html

    it's pretty amazing. Incredibly cross-browser compatible with some MS Office 2007 styling and fortunately maintains it's previous button layout. The features such as full-screen editing, emoticons, and pasting from MS Word documents make it the best in...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
Results 41 - 60 of 61