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

  1. htaccess Rewrites SEF URL and submits to PHPhttps://www.joellipman.com/articles/cms/website-development/php/htaccess-rewrites-sef-url-and-submits-to-php.html

    403 /error/?v=403 ErrorDocument 404 /error/?v=404 ErrorDocument 500 /error/?v=500 Additional Notes If you do apply the above to your site, bear in mind the following is also true: http://www.mysite.com/blog/pretty_much_anything_i_want_to_type_here.html...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  2. PHP Issue: simplexml_load_string parser error : Input is not proper UTF-8, indicate encoding !https://www.joellipman.com/articles/cms/website-development/php/php-issue-simplexml-load-string-parser-error-input-is-not-proper-utf-8-indicate-encoding.html

    an XML feed to our servers, and then loading the downloaded file into memory with simplexml_load_string(). I get the above error when it is attempting to load an XML feed which is mostly in Spanish and breaks at the following XML node: 2 -> yields...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *
  3. SITS: Export field code and namehttps://www.joellipman.com/articles/cms/website-development/xml/sits-export-field-code-and-name.html

    England -- What I want: export format to get multiple values -- &G[COD.SRS:•|•] 5826|England How? You can see it in the code above but I'll give the run through using the country of domicile with the pipe delimiter as the example: &G[entity.dictionary:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Extensible Markup Language
    • Language: *
  4. Excel PivotTable Filter List Orderinghttps://www.joellipman.com/component/content/article/excel-pivottable-filter-list-ordering.html?catid=110&Itemid=165

    Move this added field to the Report Filter section (click on it and select "Move to Report Filter") Advanced Sorting So the above works which is great but what if you have a list of month names? January comes before February but not alphabetically, so...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  5. 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

    for the number of rows per sheet (eg. 3000). In my example, this will produce an extra 12 worksheets in this file. Using the above module, overwrite the code you previously pasted with the below (note the file format for Excel 97-2003): Sub Splitbook()...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  6. GoDaddy Apache cPanel: Install SSL Certificatehttps://www.joellipman.com/component/content/article/godaddy-apache-cpanel-install-ssl-certificate.html?catid=111&Itemid=165

    2 days to take effect. Not sure what was supposed to happen but 2 days later it still wasn't working. I followed the process above and it took immediate effect... Update 2024 So I've run into the issue that when downloading the certificate from GoDaddy...

    • Type: Article
    • Author: Joel Lipman
    • Category: cPanel
    • Language: *
  7. Joel's Reference to MidJourney v4 Promptshttps://www.joellipman.com/component/content/article/joel-s-guide-to-midjourney-prompts.html?catid=115&Itemid=165

    Volumetric Lighting Famous Artist Styles I've tried to list artists here who have styles that I could not generate using the above keywords/tokens. Usage:...in the style of... Note that some of these may verge on Copyright Infringement so be careful if...

    • Type: Article
    • Author: Joel Lipman
    • Category: Graphic Design
    • Language: *
  8. 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

    intend to send the PDF files to your Kindle. Sending PDF files to your Kindle After you have done all that has been stated above, you are now ready to send PDF files to your Kindle device. Also, the above steps are a one-time process and won’t need to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Kindle
    • Language: *
  9. Convert Decimal (Person Days) to Time in Excelhttps://www.joellipman.com/component/content/article/convert-decimal-person-days-to-time-in-excel.html?catid=110&Itemid=165

    to time is equal to 24 hours; 0.5 would be 12 hours and so forth. My formula: -- Given Cell B5 = 0.14 person days from above example. -- 1 person day = 26640 seconds and 1440 minutes = 24 hours. -- 0.07 person days = 30 minutes or 0.14 person days = 1...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  10. On Gui Resize Eventhttps://www.joellipman.com/component/content/article/on-gui-resize-event.html?catid=48&Itemid=165

    MoveDraw, MainRedBackground, w%A_GuiWidth% h%A_GuiHeight% Return If I just used GuiControl, Move,... then this would be as above but if you are using images, then you will get problems with the image repeating... so use moveDraw which redraws the app....

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  11. AutoHotkey Format Date and Format Secondshttps://www.joellipman.com/component/content/article/autohotkey-format-date-and-format-seconds.html?catid=48&Itemid=165

    ddd dd-MMM-yyyy HH:mm:ss Return val } // returns format Sat 01-Jan-2011 01:00:00 The next function usually accompanies the above one. It will basically convert seconds into days, hours, minutes, etc.: FormatSeconds(val) { IfInString, val, - {...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  12. Privacy Policyhttps://www.joellipman.com/component/content/article/privacy-policy.html?catid=50&Itemid=165

    any information we are holding on you is incorrect or incomplete, please write to or email us as soon as possible, at the above address. We will promptly correct any information found to be incorrect.

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: en-GB
  13. Joes DNS Correction (JDC)https://www.joellipman.com/component/content/article/joes-dns-correction2.html?catid=53&Itemid=165

    been restored. As I love automation and reducing processes to single-click fixes, I made this teeny tiny program to run the above commands and check the error levels. Installation: 1) Decompress to a folder of your choosing 2) Run the EXE (there is no...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  14. Zoho Deluge - Generate 5 Letter Booking Retrieval Codehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-generate-5-letter-booking-retrieval-code.html

    which blocks out swear words and the such. Experimental - DO NOT USE: string generateRetrievalCode() { //... refer to above functions } string generateKidSafeRetrievalCode() { // init v_Output = ""; l_BadWords = {"My","Bad","Words"}; l_TimesTried =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  15. Zoho Deluge - Get Refresh/Access Token API v2https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-refresh-access-token.html

    $a_Header[1] = "Content-Type: application/x-www-form-urlencoded;charset=UTF-8"; If you are using the SDK and still get the above error, try setting the currentUserEmail to the email address of the super admin of your system just to check, then set a...

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

    } else { // DON'T insert into Product table v_ProductID = l_ProductDetails.ID; } What Happens: In the example above, the count to see if "Myproduct1" exists counts as zero (0). It doesn't think the product exists because it is searching with...

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

    r_Update = zoho.books.updateRecord("Invoices",v_BooksOrgID,v_InvoiceID,m_UpdateInvoice); info r_Update; Update 2023 If the above doesn't work, consider making an API call to the following endpoint: m_Params = Map(); m_Params.put("invoice_ids", );...

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

    deprecated. Invoice_Ref_ID is excluded from being copied as it was an autonumber in our example. zohoapis.eu is used in the above example for a client on the EU datacenters. If your datacenter is in the US then this should be zohoapis.com. Additional...

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

    as a response. Failing this you should check your security and privacy and ensure that you have permission to install the above, then re-install. Install the Zoho Extension Toolkit (ZET) via command line interface (CLI) In the terminal, type: npm...

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

    properly exist in the system yet and the delay causes errors further down the line. Just add these parameters as per my above instructions for a more robust solution. [See below for full code] Enter the code to determine total number of employees in...

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