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

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

    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 mixture of mostly lowercase and...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  2. Regular Expression Basic Usage Exampleshttps://www.joellipman.com/articles/web-development/regular-expression-basic-usage-examples.html

    expression could be used to search for characters equivalent to 'n' in a Spanish locale: [[=n=]] This expression matches both 'N' and 'ñ' in the following string: El Niño Source(s): Using Regular Expressions With Oracle Database

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  3. Call to a member function mark() on a non-object in Joomla CMShttps://www.joellipman.com/articles/cms/joomla/call-to-a-member-function-mark-on-a-non-object.html

    to update Akeeba (a 3rd party component to do backups) simultaneously or prior to updating the core Joomla CMS. Ticking both options and then updating re-created the error. I restored the files (using a backup to overwrite the existing PHP files),...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  4. ReCaptcha disappears from Joomla 2.5 Registrationhttps://www.joellipman.com/articles/cms/joomla/recaptcha-disappears-from-joomla-2-5-registration.html

    recaptcha simply stopped displaying. Public Key and Private Key have been setup in the Joomla Core Plugin. Set to display in both User Registration and Global Configuration. K2 is NOT installed.

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  5. Transferring Apps (purchases) from iPhone 4s to 5s on a Windows PChttps://www.joellipman.com/articles/apple/ios/transferring-apps-purchases-from-iphone-4s-to-5s-on-a-windows-pc.html

    Settings > General > Software > Update option) Right-click on your iTunes shortcut and select "Run as Administrator". Plug both phones into the computer. In iTunes, right-click on the old phone and select "Transfer Purchases". (you will need to know...

    • Type: Article
    • Author: Joel Lipman
    • Category: iOS
    • Language: *
  6. Quadcopter App with Flight Restrictions (JQA)https://www.joellipman.com/component/content/article/quadcopter-app.html?catid=40

    FC40) Currently you can only have 1 aircraft; but the next version of this app is expected to hold a lot more. Hangar Tip: Both the free and paid version of this app are being developed to write to a mounted external SD card so they can share data but...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  7. Android: Function to let user take photo or choose existinghttps://www.joellipman.com/articles/google/androidos/android-function-to-let-user-take-photo-or-choose-existing.html

    allow the user to take a photo using their built-in camera or to choose an existing photo from their gallery. Why? I wanted both options to be available to the user and for it to replace a displayed image in an ImageView. How? More as a reference for...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  8. Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://www.joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

    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, this is how you generate the JWT header //...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  9. Excel - Check a column for values found in another columnhttps://www.joellipman.com/articles/microsoft/excel/excel-check-a-column-for-values-found-in-another-column.html

    a single cell value). Sheet2!$A$1:$A$4 is the range of words to find from Sheet2. Note that there is a dollar in front of both column name (eg. "A") and the row number (eg. "1") so that these don't automatically change when you copy the formula to other...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  10. Zoho Templates - Font size is inexplicably tinyhttps://www.joellipman.com/articles/crm/zoho/zoho-templates-font-size-is-inexplicably-tiny.html

    won't display on the first/cover page if I wrap the code in a DIV with ID = container and have an image which covers them both... Which is an unintended but desired effect. Class .page: I actually like using this class because it's pretty descriptive....

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: en-GB
  11. Minimal Privileges for MySQL Database Backup Cron Jobhttps://www.joellipman.com/articles/linux/cpanel/minimal-privileges-for-mysql-database-backup-cron-job.html

    another to copy the contents to a copy of the database accessible only by root and and this database "backuper" user. For both methods, I grant the following to the user doing the backup on the database I want a backup of: GRANT SELECT, LOCK TABLES,...

    • Type: Article
    • Author: Joel Lipman
    • Category: cPanel
    • Language: *
  12. Zoho Deluge: Adding / Removing Total Tax from a Quote Recordhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-adding-removing-total-tax-from-a-quote-record.html

    would apply the standard update function and although the response would say it modified the record, the tax wouldn't apply both visually and programmatically. How? A little undocumented this "feature" but the gist is if you want to add tax, it has to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  13. Zoho Creator: Retrieve record with case-insensitive queryhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-retrieve-record-with-case-insensitive.html

    product exists is case-sensitive, but when trying to insert the product, it is case-insensitive. How? Attempt 1 to lowercase both sides of the operation in the record retrieval also fails:... l_ProductDetails = Product[Product_Name.toLowerCase() =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  14. Zoho CRM/Creator - Common Errors & Gotchashttps://www.joellipman.com/articles/crm/zoho/zoho-crm-creator-common-errors-gotchas.html

    Solution: The redirect URI in your app does not match the redirect used in the authorization request. They need to match in both irrespective of the value. Consider trying to get authorized and checking the Redirect URI passed in the URL and then...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  15. Zoho Deluge: Associate/Link an Invoice to a Sales Orderhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-associate-link-an-invoice-to-a-sales-order.html

    And then I started updating multiple fields at the same time. How? Through sweat and perseverance. The trick is to update both the sales order id and to update the invoice line items with their respective sales order item id value. For our client's...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  16. Zoho Deluge: Push Multi-Select Picklist containing Commas from CRM to Creatorhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-push-multi-select-picklist-containing-commas-from-crm-to-creator.html

    // Yields: SUCCESS: Note the "," will display as a comma in both Creator and CRM.

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  17. Zoho Creator: info/alert/modal/popup notification for any userhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

    opens in the parent window: This only happens on certain machines and I couldn't narrow down the cause. I have tested on both Mac and PC but I had a client using a Mac with admin privileges which would open the same popup link in the parent window. The...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  18. Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments)https://www.joellipman.com/articles/crm/zoho/zoho-creator-download-file-from-zohocrm-field-type-file-upload-not-attachments.html

    to download just by clicking it. Additional: Why not set a scheduled task on the expiry date/time to delete this entry for both house-keeping and security? with the following deluge if(!isnull(input.ID)) { delete from Download_File[ID == input.ID]; }

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

    module. A module called "Opportunities_X_Products" is likely to be a linking module which has a multi-select lookup on both the deal/opportunity and products module. A multi-user lookup will tend to have something like "ModuleName_X_Users". Find records...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  20. Zoho Creator: Two submit buttons on a non-stateless form with 2 different redirectshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-two-submit-buttons-on-a-non-stateless-form.html

    This is an article to document how to have two submit buttons on a non-stateless form which both submit the form but one leaves the current record open while the other redirects to the reports view. Why? A client wanted a "Save" button on their form as...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
Results 61 - 80 of 105

Donate & Support

If you like my content, and would like to support this sharing site, feel free to donate using a method below:

Paypal:
Donate to Joel Lipman via PayPal

Bitcoin:
Donate to Joel Lipman with Bitcoin bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4

Ethereum:
Donate to Joel Lipman with Ethereum 0xb038962F3809b425D661EF5D22294Cf45E02FebF

Please publish modules in offcanvas position.