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

  1. Alternative method of displaying Unicode in Autohotkey GUIhttps://www.joellipman.com/articles/automation/autohotkey/alternative-method-of-displaying-unicode-in-autohotkey-gui.html

    Char Description ------- ------- ------- ------- --------------------------------------- 128 80 U+00C7 Ç latin capital letter c with cedilla 129 81 U+00FC ü latin small letter u with diaeresis 130 82 U+00E9 é latin small letter e with acute 131 83...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  2. Zoho Deluge - Generate 5 Letter Booking Retrieval Codehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-generate-5-letter-booking-retrieval-code.html

    This is a quick article on how to generate a 5 letter code from several functions: one which returns 5 randomly selected characters and another two which convert a number to 5 letters. Why? Zoho doesn't have a function to generate random numbers or...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  3. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

    #1: As an SSIS Script Task My solution so far: The following script will convert to lowercase and then capitalize the first letter in addition to the above specification. I am storing it here so that I can work on improving it: /* Microsoft SQL Server...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  4. Convert to Proper Case in T-SQLhttps://www.joellipman.com/articles/database/t-sql/convert-to-proper-case-in-t-sql.html

    This was my first attempt based on snippets around the web. This one has two sections, the first part capitalizes any letter after a non-alpha letter. The remainder of it is to deal with exceptions to the rule, words that you want in a specific case....

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  5. Zoho Deluge: Proper Case for Nameshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-proper-case-for-names.html

    This is an open article without any completion in mind; to set the proper case of a name, as in capitalize the first letter, lower case the rest but then with exceptions. Why? Some of the Zoho Apps are incredibly case-sensitive and consider some records...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  6. UNC Paths in Sharepoint 2007 linkshttps://www.joellipman.com/articles/microsoft/sharepoint/unc-paths-in-sharepoint-2007-links.html

    on some network shares. I want to use UNC paths such as \\myServer\myShare\myFile.doc. I could map the UNC path to a drive letter and then link to it (eg. I:\myFile.doc)but what if other users haven't mapped the same drive letter to the path? Then they...

    • Type: Article
    • Author: Joel Lipman
    • Category: SharePoint
    • Language: *
  7. Installing phpBB3 for Joomla with a RocketTheme templatehttps://www.joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

    it was text-only with no styles working... Incredibly frustrating because I felt I had followed the instructions to the letter. I then played about, deleting the other templates other than the one I wanted (affinity) using the Styles tab in phpBB3's...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  8. Webdeveloper-Speakhttps://www.joellipman.com/articles/web-development/webdeveloper-speak.html

    of parody/social criticism. initialism An initialism is a phrase or multi-word name that has been abbreviated to the first letter of each word, and is pronounced as a series of individual letters. For example HTML (the computer language used to author...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  9. URL passed settings in Reporting Serviceshttps://www.joellipman.com/articles/microsoft/ssrs/url-passed-settings-in-reporting-services.html

    to do this? When does this report automatically expire? Reminder on Paper Sizes A4 = 8.27in (width) × 11.69in (height) Letter = 8.5in (width) x 11in (height) Switch width's for height to convert these to landscape.

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  10. PHP & MySQL Search Enginehttps://www.joellipman.com/articles/web-development/php/php-a-mysql-search-engine.html

    $out=array(); foreach($terms as $term) { # remove terms that are not long enough (so no searches for the letter "e") # remove terms that are in the omit word database if ((!in_array($term, $omit_search_words))&&(strlen($term)>=$MinimimumStringLength)) {...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  11. Hide a Drive per User in Windows 7https://www.joellipman.com/articles/microsoft/windows-os/hide-a-drive-per-user-in-windows-7.html

    values together -- For Example: To Restrict B & C, enter 6 decimal -- " " E & G, enter 80 decimal or 50 hexadecimal Drive Letter Decimal Hex A 1 1 B 2 2 C 4 4 D 8 8 E 16 10 F 32 20 G 64 40 H 128 80 I 256 100 J 512 200 K 1024 400 L 2048 800 M 4096 1000 N...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  12. Quadcopter App with Flight Restrictions (JQA)https://www.joellipman.com/component/content/article/quadcopter-app.html?catid=40

    to using Google Services as they are more likely to find locations that openweathermap.org cannot. Add a comma and the two letter country code (preferably "iso-3166-1 alpha-2") to the name if the location of the same name exists in multiple countries of...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  13. Excel: convert degrees minutes seconds to decimalhttps://www.joellipman.com/articles/microsoft/excel/excel-convert-degrees-minutes-seconds-to-decimal.html

    to a database where DECIMAL(10,7) ). Merging the lot If B1 contains the coordinates and there is a space after the first letter (N or S): // for latitude =IF(MID(B1,FIND("″",B1)+1, 1)="N", (MID(B1, 1, FIND("°", B1)-1) + (MID(B1,FIND("°",B1)+1,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  14. URL Alias uniqueness with PHP & MySQLhttps://www.joellipman.com/articles/web-development/php/url-alias-uniqueness-with-php-mysql.html

    for the sake of search-engine friendliness. There are no silver bullets here but I want to block any character that isn't a letter, a number or an underscore. How? Suppose the following exists as a MySQL database table called my_table_name: What we...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  15. Joel's Reference to MidJourney v4 Promptshttps://www.joellipman.com/graphic-design/joel-s-guide-to-midjourney-prompts.html

    which represent a whole string of words that you may use often but don't feel like typing every time. (follow these to the letter or it will simply reset your custom option): type /prefer option set then a In the "option" box, type an easy to remember...

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

    lesbian march, lesbian parade, lesbian pride, euro pride, europride, world pride, worldpride reachout: reach out to, write letter, send invitations read: reading, newspaper repair: fridge repair, handyman, electrician, DIY running: jog, jogging,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: *
  17. Windows 7 and Google Chrome incognito mode by defaulthttps://www.joellipman.com/articles/google/windows-7-and-google-chrome-incognito-mode-by-default.html

    Note 201004201256: The shortcut key within Google Chrome is holding down the Control and Shift key and then pressing the letter N.

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  18. Regular Expressions in SQLhttps://www.joellipman.com/articles/database/regular-expressions-in-sql.html

    FROM [STUDENTS] WHERE [S_SURNAME] NOT LIKE '%[a-zA-Z0-9]%' -- returns all rows where the student surname does NOT contain a letter or number -- eg. O'Brien will NOT be returned as it contains letters MySQL And my favorite. Note the circumflex as we are...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: *
  19. MySQL Updating a database table from another tablehttps://www.joellipman.com/articles/database/mysql/mysql-updating-a-database-table-from-another-table.html

    comparison. Why? I have several database tables which replicate country names and I would rather they all use the ccTLD two letter code. This article was written because it took me so long to work it out. How? UPDATE `table_to_update` a INNER JOIN...

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

Donate & Support

If you like my content, and would like to support this sharing site, feel free to donate using a method below:

Paypal:
Donate to Joel Lipman via PayPal

Bitcoin:
Donate to Joel Lipman with Bitcoin bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4

Ethereum:
Donate to Joel Lipman with Ethereum 0xb038962F3809b425D661EF5D22294Cf45E02FebF

Please publish modules in offcanvas position.