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

  1. Foreign Characters create symbols in PHP and MySQLhttps://joellipman.com/articles/cms/website-development/php/foreign-characters-create-symbols-in-php-and-mysql.html

    MySQL 5.1.4 Databases initially setup with collation 'latin1_swedish_ci' What Another article trying to help people display foreign characters on their website without the funny question marks in diamond symbols and how I solved it in my case. Why? My...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  2. Migrate Joomla! 1.5.x to 2.5.x+https://joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

    -- 1) Create banner-category assets -- 2) Import banner categories -- 3) Migrate banners from J15 to J30 -- 4) Update foreign keys -- 5) Remove notes used by script -- 6) Associate category IDs -- 7) Remove remaining migration notes [Optional Step] --...

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

    to import. So go into a listview of the CRM Contacts and select "Deduplicate Contacts", then say compare by email and the foreign key (3rd-party unique ID for that contact). Error(s) Encountered Could not find a matching parent record for this lookup...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  4. Convert foreign characters to English alphabethttps://joellipman.com/articles/else/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: *
  5. Drop If Object Existshttps://joellipman.com/articles/else/database/t-sql/drop-if-object-exists.html

    (less used by me) AF = Aggregate function (CLR) C = CHECK constraint D = DEFAULT (constraint or stand-alone) F = FOREIGN KEY constraint FN = SQL scalar function FS = Assembly (CLR) scalar-function FT = Assembly (CLR) table-valued function IF = SQL...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  6. Developer's Checklist: Taking over a projecthttps://joellipman.com/articles/cms/website-development/developers-checklist-taking-over-a-project.html

    data types specifically, test by running each function separately) Examine databases (data types, constraints, primary/foreign keys, autoincrements, schema diagram, scheduled jobs) Examine content integrity (what is available front-end and back-end? can...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
Results 1 - 6 of 6