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

  1. The Mermaidhttps://www.joellipman.com/component/content/article/the-mermaid.html?catid=96&Itemid=165

    With a comb and a glass in her hand. While the raging seas do roar, And the stormy winds do blow, And we jolly sailor boys were skipping up aloft, And the land lubbers lying down below, below, below, And the land lubbers lying down below. Then up spoke...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hobbies
    • Language: *
  2. Forum Ruleshttps://www.joellipman.com/component/content/article/forum-rules.html?catid=50&Itemid=165

    announcement is made that mentions your name and that you have broken a rule. I will determine whether you knew what you were doing was wrong or whether a warning is necessary to explain it to you. If I do not give a warning, I will skip ahead to the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  3. Mediawiki Extension for Camtasia Studio SWF videoshttps://www.joellipman.com/articles/cms/mediawiki/mediawiki-extension-for-camtasia-studio-swf-videos.html

    Studio SWF files in it's articles. Why Camtasia when there are other free options? We tried lots of FLV players that were usually branded or not free. These were awkward to configure a full screen button on the controls and do basic customization. Our...

    • Type: Article
    • Author: Joel Lipman
    • Category: MediaWiki
    • Language: en-GB
  4. SSRS Parameters in Oracle Stored Procedurehttps://www.joellipman.com/component/content/article/ssrs-parameters-in-oracle-stored-procedure.html?catid=75&Itemid=165

    MyStoredProcedure(param1,param2,param3) -> param1=@param1, param2=@param2, param3=@param3): Local Variables Note that we were trying to execute our stored procedure with the parameters specified just after the name of the procedure. The trick is not to...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  5. Prices get rounded up in Virtuemarthttps://www.joellipman.com/articles/else/e-commerce/virtuemart/prices-get-rounded-up-in-virtuemart.html

    happened to a m8s website in VirtueMart 1.1.3. The issue here was that although all the prices lost their float/decimal and were rounded up to the nearest integer... At first we thought this was due to installing a Virtuemart UK Credit Card Payment...

    • Type: Article
    • Author: Joel Lipman
    • Category: Virtuemart
    • Language: *
  6. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

    not appear to be included in any sync... This method would be enough if the action was instantaneous and the attachments were also attached to the Sales Order in Books... but it isn't and doesn't. It only attaches the file(s) to the CRM record. See my...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  7. Zoho People: Reject an Application for Leave in Deluge based on Criteriahttps://www.joellipman.com/articles/crm/zoho/zoho-people/zoho-people-reject-an-application-for-leave-in-deluge.html

    c_Ok.insert("response":c_Response); return c_Ok; } Additional: We asked Zoho for a solution that might work and were given the following snippet of code (not tested yet!). It looks like we have to fill in the blanks and it's on the same path as we were....

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho People
    • Language: *
  8. Zoho CRM: Update a custom field in line items / product details using REST API v2.1https://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-update-a-custom-field-in-line-items-product-details.html

    2.1 JSON The following is a snippet when querying a CRM module (invoices) from a CRM function. The important fields I wanted were some custom fields within the line items subform. Here I'm adding the parameters to ensure we get CRM records that are also...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  9. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines)https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-handle-commas-between-quotes-in-a-csv.html

    This is an article to demonstrate how to handle commas in a CSV file that were enclosed between two double-quotes. I've added to this the handling of new lines or carriage returns in between a pair of double-quotes. Why? Our use case is that we were...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  10. Zoho Deluge: Today, Tomorrow, Day After but Skip Sundayhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-today,-tomorrow,-day-after-but-skip-sunday.html

    Jul 26 00:00:00 PDT 2022,Wed Jul 27 00:00:00 PDT 2022,Thu Jul 28 00:00:00 PDT 2022,Fri Jul 29 00:00:00 PDT 2022 But if I were to maintain the idea above and skip a selected day, I would write something like the following: // // initialize list to hold...

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

    attached to their respective records in CRM. This took me a while as our own documentation is scatty and the online forums weren't too helpful either. How? In the example below, we are going to document how to import files associated to CRM Contact...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  12. Zoho Deluge: Shopify API: Get all active products with GraphQL and Paginationhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-shopify-api-get-all-active-products-with-graphql-and-pagination.html

    that had been updated on " + zoho.currenttime.subDay(1).toString("EEEE, dd-MMM-yyyy") + " "; v_Message = v_Message + "There were " + v_CountUpdated + " record(s) updated. Kind Regards, The Team"; sendmail [ from :zoho.loginuserid to:"Joel Lipman "...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  13. 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

    lost the Joomla CMS and you'll need to restore them from a backup. NOTE: Only restore the files! The images and database were unaffected in our case and could be left as they were. Our last file backup was over a year old but we only needed the core...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  14. SSRS Hide results table if emptyhttps://www.joellipman.com/component/content/article/ssrs-hide-results-table-if-empty.html?catid=75&Itemid=165

    August 2011 So I don't know how many people were just saying why don't you do the following: Bring up the "Tablix Properties" of the dataset Look for the section "No Rows" Put in a value for "NoRowsMessage". This solution hides the entire Tablix which...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  15. SSRS Querying on either of 2 Parametershttps://www.joellipman.com/component/content/article/ssrs-querying-on-either-of-2-parameters.html?catid=75&Itemid=165

    "allow blank" option in the parameter properties unchecked SSRS Report Revisted: Had an issue where SSRS report parameters were not resetting to blank after the report was run. End-Users were putting different values in both fields and getting twice as...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  16. How to Display Report Execution Time in SSRS (milliseconds)https://www.joellipman.com/component/content/article/how-to-display-report-execution-time-in-ssrs.html?catid=75&Itemid=165

    is not my concern as this is not the solution to our problem. This is the solution that I initially used but my end-users were asking why is it always 0 seconds. This was because we were using the following MDX statement which had seconds as its...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  17. Search a database with SOUNDEXhttps://www.joellipman.com/articles/else/database/search-a-database-with-soundex.html

    Data Consistency. I was tasked with finding variations of our default values. End-users were complaining that some default values get listed twice because their system was case-sensitive despite the collation of the SQL Server being case-insensitive....

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  18. Developer's Checklist: Taking over a projecthttps://www.joellipman.com/articles/cms/website-development/developers-checklist-taking-over-a-project.html

    The website was held on a virtual host running PHP and MySQL. There was no documentation, logs, notes, and any code comments were in Hungarian (later found out it was slang or a dialect not understood by most Hungarians). Fellow students and system...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  19. What's the problem? Amusing computer issueshttps://www.joellipman.com/articles/cms/website-development/whats-the-problem-amusing-computer-reports.html

    article in case you're easily offended. It's just an amusing stab at customers computer issues. Note that most of the below were remote support jobs so we weren't there in person and could only see the users screen. Three Webdevelopers phone in to say...

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

    fine with international characters A Module Extension I wrote for Joomla! displayed funny characters. The Joomla! articles were displaying the correct characters for that language set. I needed to make my extension read data from a MySQL database and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
Results 1 - 20 of 106