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

  1. Joomla article modal with clear buttonhttps://www.joellipman.com/articles/cms/joomla/joomla-article-modal-with-clear-button.html

    the Joomla Admin Panel (at time of print version 2.5.6) of your component including the all important clear button. What I found was that no one posted this solution which I found is compatible with almost any site and with all my components without...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  2. Windows OS: Alt Codes / Symbols / Special Charactershttps://www.joellipman.com/component/content/article/windows-os-alt-codes-symbols-special-characters.html?catid=80&Itemid=165

    What? This is a simple article to demonstrate how to type special characters not found on your keyboard or on a Qwerty UK/US keyboard layout. Why? Being able to type international characters from other alphabets is necessary when dealing with languages...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  3. Stored Procedure to List Distinct Values and Countshttps://www.joellipman.com/articles/else/database/t-sql/stored-procedure-to-list-distinct-values-and-counts.html

    ** Return Values : Table of three columns: ** ** - myValue: the distinct values ** ** - myColumn: the column this value was found in. ** ** - myCount: the number of times this value was found in this column. ** ** ** ** Link to other SQL Server...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  4. Merge the content of two similar tables in MySQLhttps://www.joellipman.com/articles/else/database/mysql/merge-the-content-of-two-similar-tables-in-mysql.html

    a CROSS JOIN, (BTW these are not instructions to create some table I'll never use again unlike the rest of the solutions I found on the web). In MySQL, I only know how to do this with a UNION ALL clause. Scenario: I have a Joomla module which should...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  5. mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connecthttps://www.joellipman.com/articles/else/database/mysql/mysqldump-got-error-2049-connection-using-old-pre-4-1-1-authentication-protocol-refused-client-option-secure-auth-enabled-when-trying-to-connect.html

    one used by the scripts to access the database-driven website. How? I'm first going to highlight 2 methods which I found on the web and can be applied if you work somewhere that doesn't care about testing, about changing a production environment and...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  6. List of Font Awesomehttps://www.joellipman.com/articles/cms/website-development/list-of-font-awesome.html

    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 webpage You then...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  7. Parse a HTML Table into a ListViewhttps://www.joellipman.com/articles/cms/website-development/html/parse-a-html-table-into-a-listview.html

    ; split into an array StringSplit,ReturnedHTMLTableCols,ReturnedHTMLTableColString,| ; add to last found listview LV_Add("", RowIndex, ReturnedHTMLTableCols1, ReturnedHTMLTableCols2, ReturnedHTMLTableCols3, ReturnedHTMLTableCols4,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hypertext Markup Language
    • Language: en-GB
  8. Crystal Reports: Exporting to Excel omits column headershttps://www.joellipman.com/component/content/article/crystal-reports-exporting-to-excel-omits-column-headers.html?catid=110&Itemid=165

    you're exporting a report to Excel, and only some of the column headers appear, then try this: I googled this for ages and found different suggestions here and there but none of them produced consistent results. One solution was to untick "Simplify page...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  9. Select unique values in Microsoft Excel columnhttps://www.joellipman.com/component/content/article/select-distinct-values-in-microsoft-excel-column.html?catid=110&Itemid=165

    I'd put a quick note here, I tried a fair few solutions that didn't work and then found this hidden away in a forum: Quick Count =INT(SUMPRODUCT((A3:A1000"")/COUNTIF(A3:A1000,A3:A1000&""))) This returns the number of unique values in the range A3 to...

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

    • Type: Article
    • Category: Static Items
    • Language: *
  11. Write a Calendar in Autohotkeyhttps://www.joellipman.com/component/content/article/write-a-calendar-in-autohotkey.html?catid=48&Itemid=165

    " S " htmlText:=htmlText " S " htmlText:=htmlText " " htmlText:=htmlText "" ; GET NUMBER OF DAYS THIS MONTH ; Haven't found anyone who calculates how many days there are in a month so this is a crude solution ; This checks if this year is a leap year...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  12. AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktopshttps://www.joellipman.com/component/content/article/autohotkey-ms-windows-10-open-apps-on-multiple-monitors-and-desktops.html?catid=48&Itemid=165

    it to the maximum width/height of the screen. Windows 10 Mail Lastly: Want to start a built-in app in Windows 10 (not found in your program files etc) like Windows Mail? Open a run command and type: shell:appsfolder This will open your applications in...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  13. Terms & Conditionshttps://www.joellipman.com/component/content/article/terms-conditions.html?catid=50&Itemid=165

    or guarantee as to the accuracy, timeliness, performance, completeness or suitability of the information and materials found or offered on this website for any particular purpose. You acknowledge that such information and materials may contain...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  14. Privacy Policyhttps://www.joellipman.com/component/content/article/privacy-policy.html?catid=50&Itemid=165

    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
  15. Joe's CSV Chart Generator (JCG)https://www.joellipman.com/component/content/article/joellipmans-csv-chart-generator.html?catid=53&Itemid=165

    column + Generate interactive flash charts The program was intended to chart EventViewer "Security" logs but I quickly found that I could make it group and chart any Comma Separated Value file. CHANGELOG: Version 1.0 + This is version 1.0 unless people...

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

    I am working with a Visual Studio 2008 IDE (Business Intelligence Development Studio - BIDS) along with Microsoft's Team Foundation Server (TFS). Sometimes I'll check out an item from TFS and before I get to update it, my connection will drop and my...

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

    l_TimesTried = {1,2,3,4,5}; // loop through times you will chance it for each v_TimeTried in l_TimesTried { // init b_BadWordFound = false; // get attempt v_Output = thisapp.generateRetrievalCode(); // see if can use contains but check for word for...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  18. Zoho Deluge - Some Useful Regular Expressionshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-some-useful-regular-expressions.html

    = v_MyString.replaceAll(v_MyRegEx,"$1",false); // yields my_real_textual_data Additional Since writing this article I found a Zoho page with some other pretty useful regular expressions at...

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

    "Expression is not allowed in left side of a Criteria". There used to be an old solution for doing this and can still be found in the community forums from a 7 year old post; but now you can apply a containsIgnoreCase function to search the records:......

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  20. Zoho Deluge: Search Records with Special Characters (COQL)https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-search-records-with-special-characters-coql.html

    O'Reilly How? Well I've tried various replace methods with regular expressions but the only method reliable enough I have found to work each time is using the CRM Object Query Language or Zoho's COQL. Similar to SQL but subject to similar issues of...

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