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

  1. PHP: First name and Initial of Surnamehttps://www.joellipman.com/articles/cms/website-development/php/php-first-name-and-initial-of-surname.html

    A note for myself on some code to convert a string of two names into a string made up of the first name and then using the initial of the second name. -- What I have John Smith Fred.Bloggs -- What I want John S. Fred B. How? So different ways, the first...

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

    then with exceptions. Why? Some of the Zoho Apps are incredibly case-sensitive and consider some records containing people's names as duplicates, when actually they are the same entity but may have uppercased a letter in their name while the other entry...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  3. MS-DOS: Copy folders without overwriting fileshttps://www.joellipman.com/component/content/article/ms-dos-copy-folders-without-overwriting-files.html?catid=51&Itemid=165

    or \\server\share\path). destination :: Destination Dir (drive:\path or \\server\share\path). file :: File(s) to copy (names/wildcards: default is "*.*"). :: :: Copy options : :: /S :: copy Subdirectories, but not empty ones. /E :: copy subdirectories,...

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

    on each iteration so as to avoid session timeouts and memory issues. Edit the script, renaming the database and table names used (DO NOT CONFUSE THE FOLLOWING DATABASE NAMES OR YOU WILL END UP WITH NEITHER SITE WORKING!!!) Open the SQL file in your...

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

    A and the word Attachments - no other option). The Attachments folder must contain no subfolders and only unique filenames herein. Perhaps if you were doing this over several imports, you could use the same filenames, I didn't try this, instead my...

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

    going to populate two arrays / lists; retrieve the index value; and use this in the second array as follows: // lists Day_Names = List:String({"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"}); Day_Abbreviations =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  7. Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-mapping-a-multi-user-or-multi-lookup-field-using-deluge.html

    from associating user " + _ApprovalUser.get("id"); info r_AssociateMultiUserLookup; Another method to check for API names is to query the metadata in the linking module: // // used for checking api names and the linking module (not visible via the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  8. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/component/content/article/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html?catid=74&Itemid=165

    .NET Framework 3.5 Microsoft 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  9. MySQL parameters in Excel 2007 PivotTableshttps://www.joellipman.com/articles/else/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

    interest StaffActivities...the one users recorded time gets stored in... Resources...the one with the codes and resource names... Users...the one with users names... Teams...another lookup table for just the name value... The one query to rule them...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  10. UTF8 Unicode PHP MySQL for International Charactershttps://www.joellipman.com/articles/cms/website-development/php/utf8-unicode-php-mysql-for-international-characters.html

    they weren't what we were looking for. The quick solution was to make the script run a MySQL command at the start: SET NAMES 'utf8' Now I need to run this command from within a Joomla! extension using the mysql Joomla! classes, here's how I've used in...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  11. AutoHotkey: App GUI Listview to Rename Fileshttps://www.joellipman.com/component/content/article/autohotkey-app-gui-listview-to-rename-files.html?catid=48&Itemid=165

    Lastly, a listview that 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  12. Licence GNU/GPLhttps://www.joellipman.com/component/content/article/licence-gnugpl.html?catid=50&Itemid=165

    be marked in reasonable ways as different from the original version; or d) Limiting the use for publicity purposes of names of licensors or authors of the material; or e) Declining to grant rights under trademark law for use of some trade names,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  13. Quadcopter App with Flight Restrictions (JQA)https://www.joellipman.com/component/content/article/quadcopter-app.html?catid=53&Itemid=165

    level - Map: display gallery of screenshots (+offline mode) - Map: populate nearest cities for lat/lng to more accurate city names - Map: use map touch listeners - Map: timeout requests on idle - News: localized on map (use API) - News: cache for map...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  14. Zoho Deluge: Duplicate/Clone a Recordhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-duplicate-clone-a-record.html

    p_InvoiceID (CRM ID of the invoice) Returns: Nothing Author: Joel Lipman Date Created: 2020-03-17 */ // get all field names for the Invoices module via API l_FieldApiNames = List(); r_Fields = invokeurl [ url...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  15. Zoho People: Get Performance Records over APIhttps://www.joellipman.com/articles/crm/zoho/zoho-people/zoho-people-get-performance-records-over-api.html

    "Goals" and some records with data. Create the Zoho Analytics table Create a blank Excel file / spreadsheet / csv Copy the names of fields you want to store (I'm taking all of it), and paste them into the header of the spreadsheet with each one...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho People
    • Language: *
  16. Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttps://www.joellipman.com/articles/crm/zoho/zoho-analytics/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

    mechanism so you would have to refer to the output without this column before modifying the query to include the page names of your survey. GENERAL was the first page asking for lead/contact name when I have this prepopulated from a ZohoCRM integration....

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

    I'm rewriting their instructions here so that I can I do this on other websites: Important Note: On Linux (Apache), all file names and folder names are case-sensitive, so phpbb3 is NOT the same as phpBB3. Bear this in mind during the installation...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  18. Returning Oracle Stored Procedure Resultset in SSRShttps://www.joellipman.com/component/content/article/returning-oracle-stored-procedure-resultset-in-ssrs.html?catid=75&Itemid=165

    Example: My stored procedure will do the following: Get a student ID number based on the student username Get a student's names and date-of-birth based on the student ID number Agenda Outline Note: As simple as this sounds, this is not a five-minute...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  19. Copy a table with structure and data into a temporary tablehttps://www.joellipman.com/articles/else/database/t-sql/copy-a-table-with-structure-and-data-into-a-temporary-table.html

    to match given table SET @TableDeclaration='ALTER TABLE #myScrambledTable ADD ' + STUFF( ( -- Code to concatenate column names and data types into one string SELECT CASE WHEN CHARACTER_MAXIMUM_LENGTH IS NULL THEN ',' + COLUMN_NAME + ' ' + DATA_TYPE ELSE...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  20. Convert to Proper Case in T-SQLhttps://www.joellipman.com/articles/else/database/t-sql/convert-to-proper-case-in-t-sql.html

    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 version despite having successfully built a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
Results 1 - 20 of 57