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

  1. Joomla article modal with clear buttonhttps://www.joellipman.com/articles/cms/joomla/joomla-article-modal-with-clear-button.html

    I found was that no one posted this solution which I found is compatible with almost any site and with all my components without having to modify the below script. Why? The article modal is a much easier way for the end-users to select a Joomla! article...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  2. Things to Check if Joomla Password Reminder email not being senthttps://www.joellipman.com/articles/cms/joomla/things-to-check-if-joomla-password-reminder-email-not-being-sent.html

    (but don’t create a new one – we’re just checking something) In the right pane, type “COM_USERS_EMAIL_PASSWORD_RESET_BODY” without the quotes and tick the “Constant” radio box and click on the “Search” button. What displays in the search results should...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  3. ReCaptcha disappears from Joomla 2.5 Registrationhttps://www.joellipman.com/articles/cms/joomla/recaptcha-disappears-from-joomla-2-5-registration.html

    = function() { Recaptcha.focus_response_field(); } '; } Additional This applies to a case where the code WAS working and without any changes to the server (no updates), and the recaptcha simply stopped displaying. Public Key and Private Key have been...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  4. 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

    Most of the users as per -- previous steps will match up, anonymous users (non-registered members) -- will be migrated without association (retain UserID=0). The article IDs -- should also match up. --...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  5. Joomla: Remove IDs from URLs for out-of-the-box SEFhttps://www.joellipman.com/articles/cms/joomla/joomla-remove-ids-from-urls.html

    that does this for you or spend time tweaking your .htaccess file. Or you can take advantage of a Joomla update and do this without any coding... Pre-amble To allow the Joomla CMS to manage your SEFs you need to setup your htaccess file: Open the root...

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

    for me or for whoever dares to upgrade their Joomla CMS from version 3 to version 5. Disclaimer: 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  7. MacOs: Transcribe Training Video using OpenAI Whisperhttps://www.joellipman.com/component/content/article/macos-transcribe-training-video-using-openai-whisper.html?catid=60&Itemid=165

    morning I had a "transcript.txt" file in the working directory. However, the outputted transcript file is all in lowercase without any punctuation so ChatGPT was not able to make much sense of it and reformat it. [Score: 1/10 for effort] I gave the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Apple
    • Language: *
  8. 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

    content from the clipboard. Place your cursor in a text field, then press Ctrl+Shift+V. Paste content from the clipboard without formatting. Highlight content in a text field, then press Ctrl+X or Shift+Delete. Deletes the content and copies it to the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  9. Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://www.joellipman.com/component/content/article/google-drive-oauth-using-service-account-in-php.html?catid=61&Itemid=165

    leave this blank, the script will run through and connect to Google Drive using the Service Account. The script will work without being authorized, it just won't see any files other than its own. If you specify an impersonator and you have NOT...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  10. Android Java: Remove first two entries from Google News feed in SimpleRssReaderhttps://www.joellipman.com/articles/else/app-dev/android-os/android-java-remove-first-two-entries-from-google-news-feed-in-simplerssreader.html

    first two entries from a news feed from a Google News feed. Modifying the strings can be done in the PcWorldRssParser.java (without it crashing the app). The gist is to check for a description (the first two items do not have one). The following will...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  11. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/component/content/article/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html?catid=74&Itemid=165

    System.Globalization; // for cultureinfo and textinfo using System.Reflection; // for looping through all input fields without direct references using System.Text; using System.Threading; // for threading namespace JLDataFlowTransformations {...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  12. SSIS: How to loop through multiple flat files as data sourceshttps://www.joellipman.com/component/content/article/ssis-how-to-loop-through-multiple-flat-files-as-data-sources.html?catid=74&Itemid=165

    path and the first file including its extension (eg. "C:\Temp\SourceFiles\File00001.txt" - although I used a network share without any issues) Add a Connection Manager Right-click in "Connection Managers" Select "New Flat File Connection..." Browse to...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  13. 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

    times the Dates cte can recurse OPTION (MAXRECURSION 100) 1. Create a new report: We're going to run the 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  14. SSRS Retrieving Oracle Stored Procedure Success or ErrorLevelhttps://www.joellipman.com/component/content/article/ssrs-retrieving-oracle-stored-procedure-success-or-errorlevel.html?catid=75&Itemid=165

    which updates the student record as well as an audit table. The Problem The last report will execute the stored procedure without any problems. I added a second dataset on this report to select the updated data that this stored procedure commits but...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  15. Connection Strings for SQL Serverhttps://www.joellipman.com/component/content/article/connection-strings-for-sql-server.html?catid=78&Itemid=165

    is ignored if Unix socket is used. Multiple servers Use this to connect to a server in a replicated server configuration without concern on which server to use. Server=serverAddress1 & serverAddress2 &...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server
    • Language: *
  16. 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

    and headset previously connected to my docking station weren't too much of an issue either as MS Windows detected these without needing software. Long rant to justify why I didn't want to drive home (~20 to 40 minutes commute) and pick up my laptop....

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  17. Compare two databases using T-SQLhttps://www.joellipman.com/articles/else/database/t-sql/compare-two-databases-using-t-sql.html

    databases What? A quick article on how to compare two Microsoft databases using the tools provided with SQL Server and without having to download any third-party products. Why? I googled and binged and all I could find were people selling third party...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  18. 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

    yet... So would this work if I switched MyTable1 with MyTable2? Um I'll get back on this article 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  19. MySQL parameters in Excel 2007 PivotTableshttps://www.joellipman.com/articles/else/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

    to the specific logged activity event (smallest unit of the drilldown). What's the problem? Enter this as a query in Excel without the parameters and it will work. Set MySQL parameters (using @ - same as T-SQL) and Microsoft Excel 2007 gets confused....

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  20. Generate Academic Calendar using MySQLhttps://www.joellipman.com/articles/else/database/mysql/generate-academic-calendar-using-mysql.html

    WHERE NOW() >= acyear.StartDate ORDER BY acyear.StartDate DESC LIMIT 0,1 ) ORDER BY calendar.weekNumber Same Query but without using % (avoids MySQL Error 1065: Works within PHP scripts) SELECT calendar.WeekNumber AS AcademicWeek, CONCAT(...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
Results 81 - 100 of 124