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

  1. Zoho Deluge: Sort a Map by a specific fieldhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-sort-a-map-by-a-specific-field.html

    46498 Joel 1977-11-14T12:30:00+00:00 8949 Anonymouse 1923-10-16T15:00:00+00:00 335448 Amazing 1997-07-05T23:15:00+00:00 What I want: id name date --------------------------------------------- 335448 Amazing 1997-07-05T23:15:00+00:00 46498 Joel...

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

    // yields 123 The following is used in searches to escape special characters with a backslash: v_MyString = "Joe's \"Amazing\" Skill & Sidekick (1)"; v_FormattedString = v_MyString.replaceAll(("([&'\"\%()])"),"\\$1",true); // yields Joe\'s \"Amazing\"...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  3. Error 1065: Query was Emptyhttps://joellipman.com/articles/else/database/mysql/error-1065-query-was-empty.html

    in SQL to escape apostrophes is to change these to paired apostrophes, so: INSERT INTO myTable VALUES ('1', 'It\'s amazing!'); -- equally valid INSERT INTO myTable VALUES ('1', 'It''s amazing!'); Bear this in mind when you're implementing anti-injection...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  4. GDPR Privacy Policyhttps://joellipman.com/component/content/article/gdpr-privacy-policy.html?catid=50&Itemid=165

    • Type: Article
    • Category: Static Items
    • Language: *
  5. Joes FREE Website Thumbnailer (JWT)https://joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=53&Itemid=165

    General Public License v3 (www.opensource.org/licenses/GPL-3.0). FREE / Gratis Did I not mention this already? Support Not amazing when my support team consists of me, myself and I. Saying this I'm in discussion with commercial solutions that still...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  6. Joes Network Transmission Detector (JTD)https://joellipman.com/component/content/article/joes-network-transmission-detector-jtd.html?catid=53&Itemid=165

    have any malicious code and that it does what I want and looks like I want it to look, was to make my own. What does it do? Amazing. It detects transmissions over a network. Basically on a computer that isn't on a network (ie. not connected to the...

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

    it's all registered in the system. Then click on "Create" to add your button to the report action "For Multiple Records". Amazing! You're all done! Go test it by going to the report, hover the mouse over each row and a tickbox will appear, tick a few...

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

    // sample code when creating a record in a module that contains a lookup m_Create = Map(); m_Create.put("Name","Joels Amazing Test"); r_Create = zoho.crm.createRecord("Tests", m_Create); // now take the ID that was created and use the following code to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  9. Zoho CRM: Permission Denied for Quote Conversion Mappinghttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-permission-denied-for-quote-conversion-mapping.html

    the "Invoices" module. Test converting a quote to a sales order and check the fields mapped correctly. Source(s): the amazing Zoho Support team

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  10. Zoho CRM: Get Unique Values of a Text Fieldhttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-get-unique-values-of-a-field.html

    }, { "Currency": "USD", "id": "123456789000000005" } ], "info": { "count": 3, "more_records": false } } Amazing! Let's go one further for a lookup field, in this case the account name field on the quotes record: // // build up COQL query v_CoqlQuery =...

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

    correction I had here is to specify the date/time format: On the Review screen it tells you how many fields were mapped. Amazing but not as useful as it is interesting: Then you're into the penultimate step of the migration where you watch another but...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  12. Anti-Spam override for all submitted datahttps://joellipman.com/articles/cms/joomla/anti-spam-override-for-all-submitted-data.html

    don't. If you find all your forms need extra plugins and captchas (such as JezRecaptcha), then the website security isn't amazing. I used to have Captcha on my K2 by Joomlaworks but if you did the sound version, it didn't work properly. I found that...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  13. Joomla article modal with clear buttonhttps://joellipman.com/articles/cms/joomla/joomla-article-modal-with-clear-button.html

    is a 3.24Kb file. Step #1 of 1: Create and include the following PHP file, I've named this file "article.php" (thanks to my amazing imagination). The contents of which are as follows:

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  14. List all cron jobs for all usershttps://joellipman.com/component/content/article/list-all-cron-jobs-for-all-users.html?catid=63&Itemid=165

    Amazing little script I found on Stack Overflow. Wasn't really my solution as after 2 hours, realised that the customer had been looking at the wrong server. But this script showed me where the cron job we intended was located. #!/bin/bash # System-wide...

    • Type: Article
    • Author: Joel Lipman
    • Category: Linux
    • Language: *
  15. How to Display Report Execution Time in SSRS (milliseconds)https://joellipman.com/component/content/article/how-to-display-report-execution-time-in-ssrs.html?catid=75&Itemid=165

    + e.TimeRendering AS TotalTime FROM [ExecutionLog] e INNER JOIN [Catalog] c ON c.ItemID=e.ReportID WHERE c.Name='My Amazing Report' -- just change the value here to the name of your report ORDER BY e.TimeStart DESC Deploy the report to the SSRS Run the...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  16. The ReportServer Databasehttps://joellipman.com/articles/else/database/the-reportserver-database.html

    Amazing, I have just spent all morning on Microsoft websites to determine what number is the TimeDataRetrieval column displaying. Thank you I know it's an INT. There is just a serious lack of documentation as to what this database is and how it...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  17. Restoring your WYSIWYG editor after upgrading Joomlahttps://joellipman.com/articles/cms/joomla/restoring-your-wysiwyg-editor-after-upgrading-joomla.html

    The Fix Just installed JoomlaFCK WYSIWYG Editor, an editor I use with my day job's MediaWiki software and it's pretty amazing. Incredibly cross-browser compatible with some MS Office 2007 styling and fortunately maintains it's previous button layout....

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  18. Mississippi Blueshttps://joellipman.com/component/content/article/mississippi-blues.html?catid=96&Itemid=165

    Showing how you don't need the thinnest fingers to play some amazing blues. {youtube}TTXah51r55g{/youtube}

    • Type: Article
    • Author: Joel Lipman
    • Category: Hobbies
    • Language: *
  19. Leap Motion and AR Dronehttps://joellipman.com/component/content/article/leap-motion-and-ar-drone.html?catid=113&Itemid=165

    here's a screenshot, read more if you want the videos: So Leap in Motion AR Drone: {youtube}ZOdxlrQj_ZU{/youtube} Just as amazing but old news: {youtube}L75ESD9PBO{/youtube} Swarm of Nano Quadrotors: {youtube}6lCUGPixEnk{/youtube} DigitalTrend's video...

    • Type: Article
    • Author: Joel Lipman
    • Category: Quadcopters
    • Language: *
Results 1 - 19 of 19