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

  1. Zoho Deluge - Get English Ordinalhttps://joellipman.com/articles/crm/zoho/zoho-deluge-get-english-ordinal.html

    This is a very quick note with the code to determine the English ordinal of a date (eg. "st" of "1st"). So in a date, instead of "Tuesday, 6 November 2018", I could want "Tuesday 6th of November 2018". Why? Well there's a long a way to do it (but...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  2. Convert foreign characters to English alphabethttps://joellipman.com/articles/database/mysql/convert-foreign-characters-to-english-alphabet.html

    A quick article showing my MySQL statement when I want to remove all the accents from foreign characters and return the English equivalent. Why? A content management system (CMS) that I'm working on has just gone international and started including the...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  3. Google Event Ilustrations aka Flairshttps://joellipman.com/articles/google/google-event-ilustrations-aka-flairs.html

    tuba, music ensemble, string quartett, guitar lesson, classical music, choir learnlanguage: French Course, German Course, English Course, …, French Class, German Class, English Class, …, Practice French, Practice German, Practice English, … lunch:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: *
  4. Language Codeshttps://joellipman.com/articles/cms/joomla/language-codes.html

    components, it was important that I get a general idea as to what languages are abbreviated to. Usually I only write english files (en-GB) but it's not very international and narrow-minded to think only English speakers will use Joomla! CMS. The below...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  5. Formatting a date in an MDX queryhttps://joellipman.com/articles/database/t-sql/formatting-a-date-in-an-mdx-query.html

    then I just replaced "=NOW()" [yields: 01/01/2011 01:00:00] with "=Today()" [yields: 01/01/2011] and this did the trick. English Ordinal Suffix in T-SQL for MDX Working in the UK my bosses like the English Ordinal Suffix. I haven't seen this anywhere in...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  6. Add Image Mouseover effect in AutoHotkey GUIhttps://joellipman.com/articles/automation/autohotkey/add-image-mouseover-effect-in-autohotkey-gui.html

    I put them in folders. Here's the whole code to make a gui with 1 image mouseover: ; ; AutoHotkey Version: 1.x ; Language: English ; Platform: Win9x/NT ; Author: A.N.Other ; ; Script Function: ; Template script (you can customize this template by...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  7. Is it a scam? Gumtree.com's warning signshttps://joellipman.com/hardware/is-it-a-scam-gumtreecoms-warning-signs.html

    them from an overseas location, or even get you to book seats on a plane. These are usually sought after dog breeds such as English Bulldogs, Yorkshire Terriers and Chihuahuas. These ads are usually accompanied by staged pictures. The pets don't exist...

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *
  8. Search a database with SOUNDEXhttps://joellipman.com/articles/database/search-a-database-with-soundex.html

    NOT pick up were words like "dayname" and "dynamite". Additional Notes Our database and environment need to be in British English, the collation used in the example above is where the server is set to "Latin1_General_CI_AS" [General Latin,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  9. Upgrading a Joomla 1.5 module to Joomla 2.5https://joellipman.com/articles/cms/joomla/upgrade-a-joomla-1-5-module-to-joomla-1-6.html

    more tweaks to do. How? For demo purposes we will be referring to a Joomla module called "mod_moduletoupgrade" in British English (en-GB). I don't think it actually exists in reality but you replace the name "moduletoupgrade" with whatever you're...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  10. Convert to Proper Case in T-SQLhttps://joellipman.com/articles/database/t-sql/convert-to-proper-case-in-t-sql.html

    UPPERCASE text into mixed case. The feed is originally for a personnel feed so it won't be converting long paragraphs of English text. Instead it will be applied to names and addresses as well as job titles and departments. Why? We wanted a T-SQL...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  11. AHK Countdown Tooltiphttps://joellipman.com/articles/automation/autohotkey/ahk-countdown-tooltip.html

    an executable, and schedule it as a windows task for when you are logged in: ; ; AutoHotkey Version: 1.0.47.06 ; Language: English ; Platform: Win9x/XP ; Author: Joel Lipman ; Date Created: 15-July-2014 ; ; Script Function: ; Just a countdown for my...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  12. Joes Revolver Map (JRM) Downloadshttps://joellipman.com/component/content/article/joes-revolver-map-jrm-downloads.html?catid=92

    Fri, 30th Jul 2010 1.1- Separated all parameters to be configured in the Joomla admin panel - Language file created (English GB only) - Date Uploaded: Fri, 9th Jul 2010 1.0- Added GNU/GPL License information to xml/php - Behaves like custom module and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Downloads
    • Language: *
  13. AutoHotkey: App GUI Listview to Rename Fileshttps://joellipman.com/articles/automation/autohotkey/autohotkey-app-gui-listview-to-rename-files.html

    has 2 columns: the 1st lists the files in that directory, the 2nd displays the new filenames of the files. ; ; Language: English ; Platform: Microsoft Windows 7 Professional ; AutoHotkey: v1.33.02 ; Author: - ; Description: This program will remove the...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  14. Windows OS: Alt Codes / Symbols / Special Charactershttps://joellipman.com/articles/microsoft/windows-os/windows-os-alt-codes-symbols-special-characters.html

    Why? Being able to type international characters from other alphabets is necessary when dealing with languages other than English. Preserving files in unicode or utf-8 encoding will help but there will be times when you have lost the formatting and get...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  15. Zoho Deluge: Today, Tomorrow, Day After but Skip Sundayhttps://joellipman.com/articles/crm/zoho/zoho-deluge-today,-tomorrow,-day-after-but-skip-sunday.html

    // Monday 01-Nov-21 // Tuesday 02-Nov-21 Note that Sunday is day 1 of the week. Saturday is day 7 of the week. Here's the English ordinal bit I used: m_Ordinals = {1:"st",21:"st",31:"st",2:"nd",22:"nd",3:"rd",23:"rd"}; v_Day3_Ordinal =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  16. ZohoCRM: Import Attachmentshttps://joellipman.com/articles/crm/zoho/zohocrm-import-attachments.html

    the original files and will collapse any subfolders as well as rename the files to unique filenames. ; ; Language: English ; Platform: Microsoft Windows 11 ; Author: Joel Lipman ; Version: 1.0 ; Description: This program will generate a clean...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  17. Zoho Deluge: Proper Case for Nameshttps://joellipman.com/articles/crm/zoho/zoho-deluge-proper-case-for-names.html

    There are a number of combinations that I won't have thought of but the below code sufficed for my current task, common English and some European names: // // set first and last name v_FirstName = "BILLIE-JO"; v_LastName = "MCDONALD-O'LEARY ii OF...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  18. MySQL: Find all non-alphanumeric rowshttps://joellipman.com/articles/database/mysql/mysql-find-all-non-alphanumeric-rows.html

    Quick note on how to do this. I was tasked with cleaning up an english database by replacing all special alphabets (ë to e) and non-alphanumeric symbols with URL friendly characters. How? -- return all records that contain non-alphanumeric characters...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
Results 1 - 18 of 18

Please publish modules in offcanvas position.