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

  1. ZohoCRM & Xero: Function to pull most recent invoiceshttp://mail.joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-invoices.html

    l_SearchContacts = zoho.crm.searchRecords("Contacts",v_SearchContactsCriteria); if(b_Debug) { info "Searching Contacts (" + v_SearchContactsCriteria + "): " + l_SearchContacts; } for each m_SearchContact in l_SearchContacts {...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  2. Database Error: Unable to connect to the database: Could not connect to MySQLhttp://mail.joellipman.com/articles/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

    just 1 person (me!) on the site so they just refuse the connnection after a while. Obviously something is not right. I am searching the forums for an answer and if I don't find one I'll repost. I just thought I'd share this with you in case this your...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  3. Add Image Mouseover effect in AutoHotkey GUIhttp://mail.joellipman.com/articles/automation/autohotkey/add-image-mouseover-effect-in-autohotkey-gui.html

    ) } ; ================================================================================== ; GUI FUNCTIONS Search: MsgBox, Searching... Return GuiClose: Exitapp The images I used in the search GUI above are: and . These have to be saved in the same folder...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  4. Formatting a date in an MDX queryhttp://mail.joellipman.com/articles/database/t-sql/formatting-a-date-in-an-mdx-query.html

    if you are using US dates and want the report to use a specific European date format and you spend as long as I did searching the web for a solution, then ignore all the above. Another built-in function is the text-formatter...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  5. SQL Calendar in Business Intelligence Development Studiohttp://mail.joellipman.com/articles/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

    I find myself searching the web for a way of producing an outlook-style calendar within Business Intelligence Development Studio (BIDS). Weekdays along the top and then dates inside. Additionally we would like this linked to events in a database. I'm...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  6. Room Availability Calendar in Business Intelligence Development Studiohttp://mail.joellipman.com/articles/microsoft/ssrs/room-availability-calendar-in-business-intelligence-development-studio.html

    I tried and I spent a few hours searching the net for a solution which displays the hours in the top columns, and undefined number of rooms in the rows. No all I was looking for was a calendar showing 1 day with the hours on the top. Working hours only...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  7. SSRS Hide results table if emptyhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-hide-results-table-if-empty.html

    then following the below will also let you do this (requirements: common sense or the IQ of a duck). It's what I've been searching for for the past hour and although you may think I'm just adding to the cyberspace pile of useless info, at least I'm not...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  8. SSRS Querying on either of 2 Parametershttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-querying-on-either-of-2-parameters.html

    = capd_table2.studentID AND ( table1.studentID = :StudentReference OR table2.studentUsername = :StudentADAccount ) Now searching on the ID parameter ("@StudentReference") still works but when I type a Username ("@StudentADAccount"), it populates only...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  9. Quickly update all content in mySQL database replacing a stringhttp://mail.joellipman.com/articles/database/mysql/quickly-update-all-content-replacing-a-string.html

    a third-party plugin that would replace my HTML tags with . Not I want to switch these back. How? For demo purposes, I'm searching a column called introtext in a database table called MYTABLE_content. First let me find all the articles that need this...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  10. Android: Replace return key with done, go, send...http://mail.joellipman.com/articles/google/androidos/android-replace-return-key-with-done-go-send.html

    the previous field. IME_ACTION_SEARCH // the action key performs a "search" operation, taking the user to the results of searching for the text they have typed (in whatever context is appropriate). IME_ACTION_SEND // the action key performs a "send"...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  11. Excel: convert degrees minutes seconds to decimalhttp://mail.joellipman.com/articles/microsoft/excel/excel-convert-degrees-minutes-seconds-to-decimal.html

    which has strange apostrophes and double-quotes. You can change this but remember to put two double-quotes if you are searching on it, eg: FIND(""",B1) // will NOT work! FIND("""",B1) // will work FIND("″",B1) // will work You could merge all the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  12. Zoho Creator: Retrieve record with case-insensitive queryhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-retrieve-record-with-case-insensitive.html

    above, the count to see if "Myproduct1" exists counts as zero (0). It doesn't think the product exists because it is searching with case-sensitivity enabled. It tries to insert into the product table, but returns the error "Result: Error on Execution" >...

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

    how to do this. I also couldn't find any search result via Google or DuckDuckGo (can't say for 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  14. AutoHotkey: App GUI Listview to Rename Fileshttp://mail.joellipman.com/articles/automation/autohotkey/autohotkey-app-gui-listview-to-rename-files.html

    exists. ; ; Date (v1.0): 8 July 2020 ; - Initial Release ; Date (v1.1): 10 August 2020 ; - Checks for duplicates done by searching its own column. ; - Also checks for duplicates if file exists. ; - Leaves original file as is. ; ;...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  15. Joel's Reference to MidJourney v4 Promptshttp://mail.joellipman.com/graphic-design/joel-s-guide-to-midjourney-prompts.html

    Sgraffito Synesthesia Tenebrism Ukiyo-e Unsplash Vaporwave Voronoi Wabi-sabi Warli And a few more These were found from searching the web for other art styles: {module title="Joel Lipman's List of MidJourney More"} Anamorphic Aquatint Avant-Garde Batik...

    • Type: Article
    • Author: Joel Lipman
    • Category: Graphic Design
    • Language: *
  16. ZohoCRM & Xero: Function to pull most recent quoteshttp://mail.joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-quotes.html

    l_SearchProducts = zoho.crm.searchRecords("Products",v_SearchCriteria,1,2,{"approved":"both"}); if(b_Debug) { info "Searching CRM Products: " + v_SearchCriteria + " RESULT(S): " + l_SearchProducts; } for each m_SearchProduct in l_SearchProducts {...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  17. Add default to a picture buttonhttp://mail.joellipman.com/articles/automation/autohotkey/add-default-to-a-picture-button.html

    y70 w90 h90 +Default +gSearch +Hide, Search The function to receive the data can be: Search: Gui, Submit, NoHide MsgBox, Searching for "%SearchTextInput%" Return

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  18. First and Last Entry on a Page using Modulus Remainderhttp://mail.joellipman.com/articles/web-development/php/first-and-last-entry-on-a-page-using-modulus-remainder.html

    I know it's quite a long title but I'm not sure what I'll be searching next time. It has taken me a lot longer than I thought it would mostly out of frustration and the inability to know exactly what I'm looking for... always difficult. After a cup of...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *
Results 1 - 18 of 18

Donate & Support

If you like my content, and would like to support this sharing site, feel free to donate using a method below:

Paypal:
Donate to Joel Lipman via PayPal

Bitcoin:
Donate to Joel Lipman with Bitcoin bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4

Ethereum:
Donate to Joel Lipman with Ethereum 0xb038962F3809b425D661EF5D22294Cf45E02FebF

Please publish modules in offcanvas position.