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

  1. Search a database with SOUNDEXhttps://joellipman.com/articles/else/database/search-a-database-with-soundex.html

    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. What? End-users said...

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

    for this to work: HDMI to DVI: Graphics Card to one of the Acer monitors DisplayPort to DVI (had to purchase this cable - twice as 2nd was dual-link and worked, first single-link didn't) to the 2nd Acer monitor. DisplayPort to Mini-DisplayPort: from the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Articles
    • Language: *
  3. AHK Countdown Tooltiphttps://joellipman.com/component/content/article/ahk-countdown-tooltip.html?catid=48&Itemid=165

    personal standards and then consistently fails to achieve them." Joke3:="If he were any more stupid, he'd have to be watered twice a week." Joke4:="He has two brain cells, one is lost the other is out looking for it." Joke5:="If you gave him a penny for...

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

    Pros/Cons - Advantages/Disadvantages On-Demand: Run this program in the morning, in the afternoon, once, twice, however and whenever YOU want. Unlimited: You are only limited by the resources of your environment setup, in terms of processing and disk...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  5. Quadcopter App with Flight Restrictions (JQA)https://joellipman.com/component/content/article/quadcopter-app.html?catid=53&Itemid=165

    - [0.2] News: feed from Google.com - [0.1] Map: camera animation and tilt - [0.1] Map: location search - [0.1] Map: tap twice to zoom in - [0.1] Map: wind and weather data v??? In Development: - Map: specify weather forecasts for a day - Map: current...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  6. Zoho Creator: Expecting ZC_SUBFORM_250 expression found COLLECTIONhttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-expecting-zc-subform-250-expression-found-collection.html

    error is because I am trying to assign the collection or list to the subform when I need to use "INSERT" method twice and not the equals sign: once to add the row to the collection, and the second time to add the collection to the subform. Syntax for...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  7. ZohoCRM: Process all records of a modulehttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-process-all-records-of-a-module.html

    through all the records of a module and processing these with the ability auto-resume without processing the same record twice. Why? Whether you have a few hundred records, or a few hundred thousand records, we sometimes want to write a function that...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  8. Zoho Creator / Shopify: Get all Active Productshttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-shopify-get-all-active-products.html

    sorted in order of ID ascending (starting with ID=0) retrieving 250 per call and using since_id to not list the same one twice. It then outputs a JSON list as a response and the total record count: void API.fn_ShopifyQuery_GetActiveProducts() { m_Header...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  9. Zoho CRM: Schedule a Call using Delugehttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-schedule-a-call-with-deluge.html

    data","status":"error"} correct Call_Start_Time to CRM format of yyyy-MM-ddTHH:mm:ss-05:00 or have you mapped the field twice? {"code":"MANDATORY_NOT_FOUND","details":{"api_name":"Call_Type","json_path":"$.data[0].Call_Type"},"message":"Empty Call...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  10. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openingshttps://joellipman.com/articles/crm/zoho/zoho-recruit/zohorecruit-create-linking-table-for-candidates-and-associated-job-openings.html

    This article is just in case it comes up again (has twice now) where a client wants a report on candidates and associated job openings in Zoho Recruit. Why? We're creating a custom module where our client wants to query Zoho Recruit via the API but...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Recruit
    • Language: *
  11. Zoho Deluge: Determine if Daylight Savings are in effecthttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-determine-if-daylight-savings-are-in-effect.html

    If you're lucky enough to build an application for a client based in a country that changes its clocks twice a year, then I'm opening this article without a 100% certain solution as I need to wait about 4 months until I can confirm this works. Why? I've...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  12. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Reporthttps://joellipman.com/component/content/article/zohodesk-zohoanalytics-display-ticket-attachments-in-analytics-report.html?catid=129&Itemid=165

    well (16x16 is a tad small). Caveat(s): A bit work needs to be done to the code above to prevent attachments from going in twice. You would need to record the attachment ID and only push it to Analytics if Analytics doesn't have that attachment ID in...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Desk
    • Language: *
  13. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Signhttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-zoho-sign-send-crm-merged-template-for-zoho-sign.html

    info. Please try again with proper signer info. Solution: Recipients list was incorrect and I'd assigned the recipient twice. Scope(s): ZohoSign.documents.ALL, ZohoSign.account.ALL, ZohoSign.templates.ALL, ZohoWriter.documentEditor.ALL,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  14. Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttps://joellipman.com/articles/crm/zoho/zoho-analytics/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

    to only return the latest responses that a respondent has completed; this means that if they have completed the same survey twice, this only returns the latest one they completed. SELECT i."Attempt ID" AS "Survey Response", max(i."Survey") AS "Survey",...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  15. Improve Default Joomla Search https://joellipman.com/articles/cms/joomla/improve-default-joomla-search-heuristics.html

    part of the query $query->from('#__content AS a'); // Add "Relevance" column // + 1000 pts if in title x1 (eg. if word is twice then 2000pts) // + 60 pts if in introtext // + 40 pts if in fulltext $sql_keyword =...

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

    were not resetting to blank after the report was run. End-Users were putting different values in both fields and getting twice as many rows back. I modified the report leaving only one open parameter, the OR clause just compares against the same...

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

    instead of summing the remaining columns? Correction, sum will only give me the total time but what if a report has been run twice more often then another, then is it slower? Not necessarily. Like all measures in bytes, I would like a thousand...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  18. T-SQL example of Case-Sensitive Soundexhttps://joellipman.com/articles/else/database/t-sql/t-sql-example-of-case-sensitive-soundex.html

    let's use the example "Data Not Yet Available". Unfortunately the end-user reported these default values sometimes list twice, especially when the case is different, eg. "Data not yet available". The final system (qlikview) was case-sensitive despite...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  19. Inserting incremental weeks in MySQLhttps://joellipman.com/articles/else/database/mysql/inserting-incremental-weeks-in-mysql.html

    year. Shame he also forgot the academic year ends halfway in a normal people's calendar, so you actually have to adjust this twice a year. Complicated Facility works like this, ask it what date it is on Tuesday in Week 52 of the Academic year...

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

    to only last during one academic year, and the system itself only just about understood academic years (required tweaking twice a year). Then there were the error logs... some 20000 errors per use of a feature over 4 seconds. Do some developers never...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
Results 1 - 20 of 22