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

  1. Zoho CRM & Zoho Bookings Issue: Full Name appears in Last Name (first name first name last name)https://joellipman.com/articles/crm/zoho/zoho-crm-zoho-bookings-full-name-appears-in-last-name.html

    A quick article to explain why the full name might appear in the last name field in Zoho CRM. Why? We had a customer report the issue that sometimes the full name of a contact was appearing in the last name field and creating a contact called "Firstname...

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

  2. Zoho Deluge - Get Full Day Namehttps://joellipman.com/articles/crm/zoho/zoho-deluge-get-full-day-name.html

    This is a very quick note with the code to retrieve the full day name from a date (eg. "Monday"). Why? If I use the toString() function to get the day, it only returns the first 3 letters of the day (eg. "Mon"). My_Date = today; Day_Name =...

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

  3. Report Builder 2.0 - Hide Series1https://joellipman.com/articles/microsoft/ssrs/report-builder-20-hide-series1.html

    Server 2008 Report Builder 2.0 BMC Service Desk Express 9.8 DataSet1: Incident # Group Name Close Date & Time Assigned to Full Name Incident Type The objective of this article is to explain how to hide "Series1" from appearing in your SQL Server...

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

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

    that is StackOverflow: SELECT * FROM INFORMATION_SCHEMA.COLUMNS Run this command against both databases and you have their full schemas. Use a comparison tool to compare the outputs. Method #2 Enhancing the above which does a little more of the work,...

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

  5. Quadcopter App with Flight Restrictions (JQA)https://joellipman.com/component/content/article/quadcopter-app.html?catid=40

    with new legislation and developments on "drones". Tap once to see a brief description, click on the button to view the full article in your browser. Hangar New to the app I thought it would be really cool if I could change the equipment by virtual...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *

  6. Using a HTML form and PHP to upload a filehttps://joellipman.com/articles/web-development/php/using-a-html-form-and-php-to-upload-a-file.html

    want, in my case I've called it 'uploaded_file'. 2. Check that the destination directory is writable by Apache. This is the full path to the folder that you will be uploading the files to and should be 755 (ie. rwxr-xr-x). The change ownership command...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB

  7. Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

    hard because the timestamps, included in the encoding, change every second. You can get it verifying the signature successfully if you go get your public key, paste both keys into jwt.io (these don't change), then paste the encoded assertion. Anyway,...

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

  8. GDPR Privacy Policyhttps://joellipman.com/static-items/gdpr-privacy-policy.html

    to the following conditions. If you visit or shop within this website, you accept these conditions. Please read them carefully. Privacy Please review our Privacy Notice, which also governs your visit to our website, to understand our practices....

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *

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

    and customers who do not have DBAs to run this themselves. Personally I grant the user who will be executing the script full privileges or at least the same as needed to install Joomla CMS. Cross your fingers and use your DB management tool to run the...

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

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

    specifiers (format string starts with +) Specifier Description Values/Example Day %a weekday, abbreviated Mon %A weekday, full Monday %d day of the month (dd), zero padded 04 %e day of the month (dd) 4 %j day of year, zero padded 001-366 %u day of week...

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

  11. MySQL: Display Users and Duration in Matrix Timesheethttps://joellipman.com/articles/database/mysql/mysql-display-users-and-duration-in-matrix-timesheet.html

    = $the_team_id_that_i_want_to_look_at; $user_list_query=" SELECT DISTINCT u.UserID, CONCAT(u.FirstName, ' ', u.LastName) AS 'Fullname' FROM Users u WHERE u.StatusType NOT IN ('expired','guest','test account') AND u.TeamID='$t_value' ORDER BY...

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

  12. Battery Constantly Drained on iPhonehttps://joellipman.com/articles/apple/battery-constantly-drained-on-iphone.html

    1 A friend reported her phone was constantly being drained, wasn't lasting the day on a full charge and knew how to close apps running in the background (double-click "home" button and hold down app until red minus buttons appear, tap red button)... I...

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

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

    eek! Either of the two following script examples can be included in an SSIS Script Task but this article includes the full process of packaging the script into a reusable component. Example #1: As an SSIS Script Task My solution so far: The following...

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

  14. MS-DOS: Copy folders without overwriting fileshttps://joellipman.com/articles/automation/ms-dos/ms-dos-copy-folders-without-overwriting-files.html

    /V :: produce Verbose output, showing skipped files. /TS :: include source file Time Stamps in the output. /FP :: include Full Pathname of files in the output. /BYTES :: Print sizes as bytes. /NS :: No Size - don't log file sizes. /NC :: No Class -...

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

  15. SSIS: How to loop through multiple flat files as data sourceshttps://joellipman.com/articles/microsoft/ssis/ssis-how-to-loop-through-multiple-flat-files-as-data-sources.html

    (preferably to the scope of the package) called "SourceExtractFile" and give it the data type "String". Set the Value to the full path and the first file including its extension (eg. "C:\Temp\SourceFiles\File00001.txt" - although I used a network share...

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

  16. List of Font Awesomehttps://joellipman.com/articles/web-development/list-of-font-awesome.html

    and add the linked stylesheet in the head section of your webpage. I'm selective of what icons I copy over but the full directory can be found at https://github.com/FortAwesome/Font-Awesome: OR add the linked stylesheet to the head section of your...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *

  17. Zoho Deluge - Get English Ordinalhttps://joellipman.com/articles/crm/zoho/zoho-deluge-get-english-ordinal.html

    v_EnglishOrdinal = if(v_ThisDayDateLastChar 20),"st,nd,rd".toList().get(v_ThisDayDateLastChar-1),"th"); // full formal date v_ContractDateFormatted = v_NextRenewalDate.toString("EEEE, d") + v_EnglishOrdinal + " of " + v_NextRenewalDate.toString("MMMM,...

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

  18. Zoho Deluge - InvokeConnector and useful snippetshttps://joellipman.com/articles/crm/zoho/zoho-deluge-invokeconnector-and-useful-snippets.html

    { l_Users = r_Response.get("response").get("users"); for each v_User in l_Users { info v_User.get("full_name") + " :: " + v_User.get("id"); } } } Update 2020: Note this can also be achieved with the following shortcode: l_Users =...

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

  19. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://joellipman.com/articles/crm/zoho/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

    The full code with attachment to CRM and Zoho Books Note that for the example below, my Creator form is called "Quote", my subform is called "Attachments" and the file upload field within that is called "Upload_File". The respective report is called...

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

  20. Zoho Creator: Set Up Custom Domain for Customer Portalhttps://joellipman.com/articles/crm/zoho/zoho-creator-set-up-custom-domain-for-customer-portal.html

    then on the "Settings" button in the top right: Under Portal URL, select "Custom Domain" and in the field below, enter the full domain (incl. subdomain) you want to use: Then click on "Save". If you have access to the DNS manager for the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
Results 1 - 20 of 69

Joes Word Cloud

Please publish modules in offcanvas position.