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

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

    supposed to happen but 2 days later it still wasn't working. I followed the process above and it took immediate effect... Update 2024 So I've run into the issue that when downloading the certificate from GoDaddy and followed the steps above but it kept...

    • Type: Article
    • Author: Joel Lipman
    • Category: cPanel
    • Language: *
  2. Zoho Deluge - Get Full Day Namehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-full-day-name.html

    day (eg. "Mon"). My_Date = today; Day_Name = My_Date.toString("E"); // returns "Mon" How? Well a few methods. Method #0: Update 2020 Tested in CRM and Creator and this is working: My_Date = today; Day_Name = My_Date.toString("EEEE"); // returns "Monday"...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  3. SELECT COUNT(DISTINCT name) FROM tablehttps://www.joellipman.com/articles/cms/joomla/select-count-distinct-name-from-table.html

    1 and 2 return the correct number. I'm still unsure as to why WHERE...GROUP BY... doesn't return the same totals and will update this article when I figure it out.

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  4. Search and Replace in a MySQL Databasehttps://www.joellipman.com/articles/else/database/mysql/search-and-replace-in-a-mysql-database.html

    correctly... well that's usually me. Found it a bit boring but here's a short bit of code to speed it up which I now use: update table_name set field_name=REPLACE(field_name,'string_to_find','string_to_replace'); Source:...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  5. Trim values along with the tabhttps://www.joellipman.com/articles/else/database/mysql/trim-values-along-with-the-tab.html

    then converting to MySQL commands. Unfortunately, the MS Excel software adds tab characters to delimit the columns... How? UPDATE `mytable` SET `myColumn` = TRIM(CHAR(9) FROM TRIM(`myColumn`)); Source: Stack Overflow - How to Remove Tabs

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  6. The Sandpithttps://www.joellipman.com/component/content/article/the-sandpit.html?catid=115&Itemid=165

    an effect called "time-lapse tilt shift photography" where everything is made to look smaller than it actually is. As an update Mar 2011, I just watched Gulliver's Travels (2010) and it looks like the same effect for the intro credits :c) This is "a day...

    • Type: Article
    • Author: Joel Lipman
    • Category: Graphic Design
    • Language: *
Results 121 - 126 of 126