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

  1. Migrate Joomla! 1.5.x to 2.5.x+https://joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

    c.`title`, c.`alias`, CONCAT('Import from J15. PreviousID=catid', c.`id`) AS note, c.`description`, c.`published`, CASE WHEN c.`access`=0 THEN 1 WHEN c.`access`=1 THEN 2 WHEN c.`access`=2 THEN 7 END AS access, '{"target":"","image":""}' AS params,...

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

  2. T-SQL Record Separatorhttps://joellipman.com/articles/database/t-sql/t-sql-record-separator.html

    allowed -- refer to 6th line of this query for order by) ) AS t1 ) -- Query that will display extracted data SELECT t2.*, CASE WHEN t2.Day=t3.Day THEN NULL ELSE 'Separator Marker' END as 'Marker' FROM tblDifference t2 Left Outer Join tblDifference t3 On...

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

  3. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

    Visual C# 2008 What? So like lots of people on the net, I've been given a datasource with names and addresses all in UPPERCASE. Initially, no one seemed bothered but now the request came through asking if this could be restored to a normal case, a...

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

  4. Zoho Deluge: Proper Case for Nameshttps://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: *

  5. Improve Default Joomla Search https://joellipman.com/articles/cms/joomla/improve-default-joomla-search-heuristics.html

    article you visit a lot, it would be nicer just to type a number like "1234" and this returns that specific article. In the case of Joomla, we'll use the article ID. Pre-Notes: This article consists of instructions to hard-code some core files in...

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

  6. Convert to Proper Case in T-SQLhttps://joellipman.com/articles/database/t-sql/convert-to-proper-case-in-t-sql.html

    So this is an article exploring how to convert 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...

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

  7. Compare two databases using T-SQLhttps://joellipman.com/articles/database/t-sql/compare-two-databases-using-t-sql.html

    on table and column names, lists diffences if any SELECT t1.TABLE_CATALOG AS [DB1_Name], t2.TABLE_CATALOG AS [DB2_Name], CASE WHEN t1.TABLE_NAME IS NULL AND t2.TABLE_NAME IS NOT NULL THEN t2.TABLE_NAME + ' (new)' WHEN t1.TABLE_NAME IS NOT NULL AND...

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

  8. SQL: Use CASE for Relevance columnhttps://joellipman.com/articles/database/mysql/sql-use-case-for-relevance-column.html

    form: -- where @ThisSearch is a posted (and sanitized) variable SET @ThisSearch:="Brains"; SELECT columnID, columnFullName, CASE WHEN columnFirstName LIKE @ThisSearch THEN 20 WHEN columnFullName LIKE @ThisSearch THEN 10 WHEN columnLastName LIKE...

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

  9. Upgrading Joomla CMS version 3.x to Joomla CMS 5.xhttps://joellipman.com/articles/cms/joomla/upgrading-joomla-cms-version-3-x-to-joomla-cms-5-x.html

    v8.x. I also get complaints (from my server not from humans) that my Joomla version needs updating... I'm writing this in case I ever have to upgrade other people's Joomla CMS and if it helps anyone else out there. How? There aren't too many steps but...

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

  10. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPUhttps://joellipman.com/pc-build-2022-5-monitors-connected-to-1-pc-using-1-gpu.html

    but I put in some more to get the Graphics Card, more RAM, more fans, more... What I had: Personal Home PCWork-from-Home PC CaseAntec Fusion Black 430Dell OptiPlex 9020 Micro Form Factor CPUi3 4th Geni7 4th Gen RAM4Gb8Gb GPUNvidia Geforce GT 610???...

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

  11. Inline Labels in Form Fields using Javascripthttps://joellipman.com/articles/web-development/js/inline-labels-in-form-fields-using-javascript.html

    field so we can reference it later. style="color:grey" - add a styling to it by default (on initial load), in this specific case the color grey. value="Name:" - give this field a default value. In this specific case, we are giving it the label value to...

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

  12. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttps://joellipman.com/articles/crm/zoho/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

    allowed me to set up a daily reminder to the lead record owner but to no avail. An assignment rule wouldn't work in this case as it had to be the lead owner (there is no owner at assignment rule stage). A workflow email notification doesn't do the popup...

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

  13. T-SQL example of Case-Sensitive Soundexhttps://joellipman.com/articles/database/t-sql/t-sql-example-of-case-sensitive-soundex.html

    This article is for demonstrating how to use a SOUNDEX in a select and then listing all the variations based on case-sensitivity. Why? We have a database with data in it. For a particular column we have setup default values, let's use the example "Data...

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

  14. Zoho Creator: Retrieve record with case-insensitive queryhttps://joellipman.com/articles/crm/zoho/zoho-creator-retrieve-record-with-case-insensitive.html

    Thought I'd put an article here to remind me how to make the retrieval of a record case-insensitive. Why? Consider that I have the following creator table: Product_Name Product_SKU -------------- ------------- MyProduct1 TEST01 Myproduct2 TEST02...

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

  15. SQL Queries for Statisticshttps://joellipman.com/articles/database/mysql/sql-queries-for-statistics.html

    1, 0)) Student, SUM(IF(t2.VisitorType='Anonymous', 1, 0)) Guests FROM ( SELECT b.user_name User, CASE WHEN INSTR(b.user_name, '@staff') THEN 'Staff' WHEN INSTR(b.user_name, '@bournemouth') THEN 'Student' WHEN t1.ID=0 THEN 'Anonymous' END VisitorType,...

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

  16. T-SQL Conversion failed when converting the varchar to data type inthttps://joellipman.com/articles/database/t-sql/t-sql-conversion-failed-when-converting-the-varchar-to-data-type-int.html

    A very quick note in case I forget this one. If you are trying to join two tables and receiving the error "Conversion failed when converting the varchar value 'B110' to data type int" then read on. How? So where does the 'B110' string come from, well...

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

  17. Call to a member function mark() on a non-object in Joomla CMShttps://joellipman.com/articles/cms/joomla/call-to-a-member-function-mark-on-a-non-object.html

    out and you will get errors regarding other elements of the CMS. This error could have been caused by many things but in the case of one of my clients, the error was due to an update process gone wrong. Not really the fault of Akeeba, Joomla or anyone,...

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

  18. ZohoCRM: Import Attachmentshttps://joellipman.com/articles/crm/zoho/zohocrm-import-attachments.html

    errors I encountered below but also to document the import process of a bunch of files into a ZohoCRM system. Why? Our use-case here is a data migration for a client from a legacy CRM to ZohoCRM. They have a lot of files they want attached to their...

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

  19. Add the website name to the page title in Joomla!https://joellipman.com/articles/cms/joomla/add-the-website-name-to-the-page-title.html

    Configuration" and set the "Include site name in page titles" setting to "No" Open your templates component file (in the case of Yootheme using the Warp Framework this is \templates\\warp\systems\joomla\layouts\head.php, in the case of others this is...

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

  20. Unix Date Format Specifiershttps://joellipman.com/articles/linux/unix-date-format-specifiers.html

    00–99 Date %D mm/dd/yy 07/4/11 %x locale's date representation (mm/dd/yy) 07/4/2011 %F %Y-%m-%d 2011-07-4 Hours %l (Lowercase L) hour (12 hour clock) 1 %I (Uppercase I) hour (12 hour clock) zero padded 01 %k hour (24 hour clock) 13 %H hour (24 hour...

    • Type: Article
    • Author: Joel Lipman
    • Category: Linux
    • Language: *
Results 1 - 20 of 133

Joes Word Cloud

Please publish modules in offcanvas position.