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

  1. Include a carriage return in a column headinghttps://www.joellipman.com/component/content/article/include-a-carriage-return-in-a-column-heading.html?catid=78&Itemid=165

    ----------- ----------- ----------- ----------- ----------- -- 1 14-Jul-2014 15-Jul-2014 16-Jul-2014 17-Jul-2014 18-Jul-2014 After: SELECT calendar.WeekNumber AS [Academic Week], calendar.Monday, calendar.Tuesday, calendar.Wednesday, calendar.Thursday,...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server
    • Language: *
  2. DataTumble - Randomize Data Rowshttps://www.joellipman.com/articles/else/database/t-sql/datatumble-randomize-data-rows.html

    DateOfBirth --------- ------------ ----------- 1 John Smith 1988-06-24 2 Fred Bloggs 1972-11-17 3 Another User 1964-02-18 After: ID Name DateOfBirth --------- ------------ ----------- 1 Fred Bloggs 1964-02-18 2 Another User 1988-06-24 3 John Smith...

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

    This was my first attempt based on snippets around the web. This one has two sections, the first part capitalizes any letter after a non-alpha letter. The remainder of it is to deal with exceptions to the rule, words that you want in a specific case....

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  4. This file contains HTML or script code that may be erroneously interpreted by a web browserhttps://www.joellipman.com/articles/cms/website-development/html/this-file-contains-html-or-script-code-that-may-be-erroneously-interpreted-by-a-web-browser.html

    returned the above error... Secondly: Edit your /includes/specials/SpecialUpload.php file and add the following line shortly after the declaration of detectScript function: if ($extension === 'swf') return false; I put it straight after: function...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hypertext Markup Language
    • Language: en-GB
  5. Using a HTML form and PHP to upload a filehttps://www.joellipman.com/articles/cms/website-development/php/using-a-html-form-and-php-to-upload-a-file.html

    available to you. Note: The temporary file gets deleted when the script finishes. So the file shouldn't exist if you check after the script has completed. Do the following step to keep the file in a specified folder. 5. Form processing works so now test...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  6. MS Excel - Sort pivottable column headings by datehttps://www.joellipman.com/component/content/article/sort-pivottable-column-headings-by-date.html?catid=110&Itemid=165

    of the week along the top. Why? The excel report would hit a bug where it couldn't work out that 10 (Wednesday) happened after 8 (Monday). How? See the following screenshot and note the dates for Monday, Tuesday, Wednesday, and Thursday: Note how...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  7. MS Excel - Split Workbook into separate files per sheethttps://www.joellipman.com/component/content/article/ms-excel-split-workbook-into-separate-files-per-sheet.html?catid=110&Itemid=165

    1)...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  8. Checklist for the local computer repairshttps://www.joellipman.com/component/content/article/checklist-for-the-local-computer-repairs.html?catid=116&Itemid=165

    business/thesis/whatever.″ Rates: Charge nominal fee £20 /hour I bill in 20 minute increments If I have to visit, I add 30 After hours, holidays and emergencies, added 20/hour Add 20 for restore disk Questions for customers: What do you need to do? Last...

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *
  9. Amazon Kindle: Send PDFs to your Kindlehttps://www.joellipman.com/component/content/article/amazon-kindle-send-pdfs-to-your-kindle.html?catid=121&Itemid=165

    need to do. Go to the official Amazon home page that applies to your region. Sign in with your Amazon username and password. After you have logged in, look for the menu option Account and Lists which should show somewhere along the top right of the home...

    • Type: Article
    • Author: Joel Lipman
    • Category: Kindle
    • Language: *
  10. Zoho Cliq: Integrate OpenAI ChatGPT with Conversation Threadshttps://www.joellipman.com/articles/crm/zoho/zoho-other/zoho-cliq-integrate-openai-chatgpt-with-conversation-threads.html

    ChatGPT 3.5 Turbo. Why? Connecting to OpenAI ChatGPT is all very well and good, but this forgets what you were talking about after each chat. So it's good for 1 question and 1 answer. What we need is to train it a little a bit like the standard OpenAI...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Other
    • Language: *
  11. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPUhttps://www.joellipman.com/component/content/article/pc-build-2022-5-monitors-connected-to-1-pc-using-1-gpu.html?catid=45&Itemid=165

    will load up on my one monitor connected to my motherboard, but my windows login screen will appear on my central monitor (after further reboots my daisy chained 2 monitors now load the bios logo with the primary monitor displaying the windows login) >...

    • Type: Article
    • Author: Joel Lipman
    • Category: Articles
    • Language: *
  12. Client Services: Website Development Agreementhttps://www.joellipman.com/component/content/article/client-services-website-development-agreement.html?catid=50&Itemid=165

    Web Hosting: A separate agreement will need to be made if JoelLipman.Com is to host the production and development websites after release date. (see my pricing structure below). This is, of course, merely an initial draft of the agreement. Feel free to...

    • 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

    you chose when registering for username reminders, password resets, or e-mail changes. The key stored on the device expires after 30 days and requires you to login again if you have not used this app in that time. ChangeLog v1.8.x [25 Nov 2014] -...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  14. Zoho Deluge - Update Creator from CRMhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-update-creator-from-crm.html

    documentation provided, and the responses returned as successful, but the target fields did not update. This was as a result after changing the owner of the Creator app to another person and adding our previous Super Admin account as a "Developer". How?...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB
  15. Zoho Deluge - Modify the product line items in an invoice modulehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-modify-the-product-line-items-in-an-invoice-module.html

    null, "Currency": "USD", "name": "Test Product", "id": "1642130000000104087" }, "quantity": 1, "Discount": 0, "total_after_discount": 0, "net_total": 0, "book": null, "Tax": 0, "list_price": 0, "unit_price": 0, "quantity_in_stock": 0, "total": 0, "id":...

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

    Bing, I never get around to searching that). This took several hours but it is possible, I was just about to give up even after having spoken to Zoho Support... And then I started updating multiple fields at the same time. How? Through sweat and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  17. Zoho Creator: Create a Widget which uses JavaScripthttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-create-a-widget-which-uses-javascript.html

    Zoho services and programming in Zoho Deluge for a few years now, even I thought of Zoho Widgets as a daunting task. But after doing some, I realize this is actually very quick to do and much easier than first thought. The article below documents how to...

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

    */ .popupClose{position:relative !important;z-index:1000;top:28px;right:46px !important;} .fa.fa-close::before,.fa.fa-close::after{background:#999 !important;} 2. Trigger the notification There are several ways to display this as a popup, the first use...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  19. Zoho Creator: Set Up Custom Domain for Customer Portalhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-set-up-custom-domain-for-customer-portal.html

    level and equal number of steps as verifying by CNAME; or by uploading a HTML verify file which I tend to forget to delete afterwards and involves just as many steps to instruct the client. I use CNAME as I find it easier and it is a step we need for...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  20. Zoho Creator: Button on Report for Merging Multiple Selected Recordshttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-button-on-report-for-merging-multiple-selected-records.html

    v_TotalVat = v_TotalVat + v_LineItemTotalVat; v_Total = v_Total + v_LineItemTotal; } // // other actions you want to do after all quotes looped through // } Save your function and click on "Done" to ensure it's all saved in the system. Create the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
Results 41 - 60 of 130