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

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

    only applies to MySQL. So the following query will return a count of each word in your database column by order of most used first (replace 'mydbprefix_content' with the name of your database table AND `introtext` with the name of your column): SELECT...

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

  2. Webdeveloper-Speakhttps://www.joellipman.com/articles/cms/website-development/webdeveloper-speak.html

    up: "above the fold" or "before-the-scroll" The part of a webpage that is visible in the web browser window when the page first loads is described as being ‘above-the-fold’. "belt-and-suspenders" Just like the UK's idiom "belt-and-braces",...

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

  3. CSS Printing - Page Break Inside with Headers and Footershttps://www.joellipman.com/articles/cms/website-development/css/css-printing-page-break-inside-with-headers-and-footers.html

    Fine on screen but this is obviously for when it comes to printing. Why? I needed to create a template in HTML where the first page is a cover page (background image filling the page with a logo floating at the centre) and the next page has a table...

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: *

  4. htaccess Rewrites SEF URL and submits to PHPhttps://www.joellipman.com/articles/cms/website-development/php/htaccess-rewrites-sef-url-and-submits-to-php.html

    If you allow percents (%) or apostrophes (*) then you are asking for trouble. Note my redirect for errors. Split the first string "myFolder" with the slash (/) as a delimiter, controlling the syntax/format of your site URLs. For Example...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB

  5. Convert XML UTF-16 to JSON UTF-8 with PHP cURLhttps://www.joellipman.com/articles/cms/website-development/php/convert-xml-utf-16-to-json-utf-8-with-php-curl.html

    have seen this all over the Internet as the accepted solution... Doesn't work for me because I'm using cURL but it's a first point of reference. This will work if the received XML is a string. // setting XML value $string = ' 2/13/2013 10:37:24 PM...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB

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

    which will be specific to your business requirements. Why? If you're developing in SITS, and you use the client, the first time(s) you do this, the task is rather daunting. Having done it a few times and run through a few, I thought I'd note this down...

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

  7. MS Excel - Split Workbook into separate files per sheethttps://www.joellipman.com/component/content/article/ms-excel-split-workbook-into-separate-files-per-sheet.html?catid=110&Itemid=165

    How? In summary, we are going to move the Excel file to a folder of its own. We're going to run two VBScripts in two stages, firstly to split the specified rows into sheets, then each sheet into a file each. And we want all the files generated to be...

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

  8. GoDaddy Apache cPanel: Install SSL Certificatehttps://www.joellipman.com/component/content/article/godaddy-apache-cpanel-install-ssl-certificate.html?catid=111&Itemid=165

    a purchased SSL certificate seems to require re-installing each year despite it's expiry in a couple years time. The first time I did it, there were more steps; the second time I just did as per the below. If I ever have to do the long process again,...

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

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

    photographic memory to do the same. My beloved DJI Phantom and the Hubsan 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...

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

  10. Zoho Deluge - Get Full Day Namehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-full-day-name.html

    the full day name from a date (eg. "Monday"). Why? If I use the toString() function to get the day, it only returns the first 3 letters of the day (eg. "Mon"). My_Date = today; Day_Name = My_Date.toString("E"); // returns "Mon" How? Well a few methods....

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

  11. Border settings not saving in SSRShttps://www.joellipman.com/component/content/article/border-settings-not-saving-in-ssrs.html?catid=75&Itemid=165

    the project but when I come back to the setting, it's still black. I found that you have to select a color or expression first, then define which border (top, right, bottom, left) the settings apply to... Mad. 1. Type your expressions/specify color...

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

  12. Set default parameter dates to start and end of monthhttps://www.joellipman.com/component/content/article/set-default-parameter-dates-to-start-and-end-of-month.html?catid=75&Itemid=165

    all results between two dates instead of just specifying the one day. If the second parameter (ToDate) is the same as the first (FromDate), then the range is for that particular date. Solution Easy for some but anything that I spend 30 minutes googling...

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

  13. Convert Decimal (Person Days) to Time in Excelhttps://www.joellipman.com/component/content/article/convert-decimal-person-days-to-time-in-excel.html?catid=110&Itemid=165

    on projects by IT Service colleagues. The main report is a pivot table with staff members along the top, tasks down the first column, and time spent in the form of person days in the cross-join. Why? Currently the smallest bookable time by low-level...

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

  14. Zoho Cliq: Integrate OpenAI ChatGPT with Conversation Threadshttps://www.joellipman.com/articles/crm/zoho/zoho-other/zoho-cliq-integrate-openai-chatgpt-with-conversation-threads.html

    all the messages of the chat/conversation thread so that we send the OpenAI ChatGPT bot the full conversation thread. First getting the messages relating to this chat: You will need a connection that has the necessary scope(s). Note that you have to do...

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

  15. AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktopshttps://www.joellipman.com/component/content/article/autohotkey-ms-windows-10-open-apps-on-multiple-monitors-and-desktops.html?catid=48&Itemid=165

    of left to right. So the above code tries to determine the leftmost monitor and rightmost with the last being in the centre. First of all here's the code to open a windows application on a non-default monitor: ; Get full screen coordinates for the...

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

  16. AutoHotkey: Get Media Information and Displayhttps://www.joellipman.com/component/content/article/autohotkey-get-media-information-and-display.html?catid=48&Itemid=165

    in MS Windows 7 to display the properties of sound files though this is also applicable to media files in general. How? So first I'm going to list a function I use called "Filexpro()", then list some examples of usage. And in the second-to-last section,...

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

  17. Licence GNU/GPLhttps://www.joellipman.com/component/content/article/licence-gnugpl.html?catid=50&Itemid=165

    holder is reinstated permanently if the copyright holder notifies you of the violation by some reasonable means, this is the first time you have received notice of violation of this License (for any work) from that copyright holder, and you cure the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *

  18. Batch Process to rename multiple files using Windows DOShttps://www.joellipman.com/component/content/article/batch-process-to-rename-multiple-files-using-windows-dos.html?catid=51&Itemid=165

    to !newName! RENAME "!oldName!" "!newName!" ) This code will rename the files. I did not find a way to undo so just run the first code to double-check what you're about to do. Save and Close the notepad file Return to the command prompt and type...

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

  19. Joes Word Cloud (JWC)https://www.joellipman.com/component/content/article/module-joes-word-cloud-jwc.html?catid=53&Itemid=165

    View the module on your front-end to see if it does what you want it to do. Modify the module parameters as necessary. Setup First of all, you need to make it visible. These 3 steps will have your module ready: The further steps below are how to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *

  20. Joes Search Module (JSM)https://www.joellipman.com/component/content/article/joes-search-module-jsm.html?catid=53&Itemid=165

    be able to use this search or see the restricted documents. I've googled far and wide but as usual, I find myself to be the first to address this. How? The module I have made is very basic and not in an MVC structure but it has been tested on Joomla...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
Results 101 - 120 of 215