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

  1. SQL Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/else/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

    this project "Reinventing the Wheel" because the request was a report that was similar to an MS Outlook calendar which will display any room bookings for that month. This is "Reinventing" because we used to use MS Outlook to store these kind of things...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  2. T-SQL Record Separatorhttps://www.joellipman.com/articles/else/database/t-sql/t-sql-record-separator.html

    following: SET RECSEP WRAPPED SET RECSEPCHAR "-" Stage #1: Duplicate the table and create a separator marker Granted this will slow the query down a touch and only adds a check column which marks rows (identifying when a separator is needed) but this...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  3. The Mermaidhttps://www.joellipman.com/component/content/article/the-mermaid.html?catid=96&Itemid=165

    Captain Of our gallant ship, And a fine old man was he. "I have married a wife in fair London town, But tonight she a widow will be, Will be, will be. But tonight she a widow will be." While the raging seas do roar, And the stormy winds do blow, And we...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hobbies
    • Language: *
  4. AutoHotkey: App GUI Listview to Rename Fileshttps://www.joellipman.com/component/content/article/autohotkey-app-gui-listview-to-rename-files.html?catid=48&Itemid=165

    Windows 7 Professional - Service Pack 1 AutoHotkey v1.1.33.02 What? So this is the documentation for a snippet of code that will list files of a directory using an AutoHotkey GUI and display what it will name them. The app needs to rename files but...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  5. Prefix Line Numbers in a Text Filehttps://www.joellipman.com/component/content/article/prefix-line-numbers-to-a-text-file.html?catid=51&Itemid=165

    file (Type "ECHO > TEMP.TXT") Type "FC /N /LB 300 c:\original_file.txt c:\temp.txt > c:\results_file.txt" The resulting file will be "c:\results_file.txt", open it in your favorite text editor... ta-daa... Explanation: FC is a file comparison tool in...

    • Type: Article
    • Author: Joel Lipman
    • Category: MS-DOS
    • Language: *
  6. MS-DOS: Copy folders without overwriting fileshttps://www.joellipman.com/component/content/article/ms-dos-copy-folders-without-overwriting-files.html?catid=51&Itemid=165

    -- since January 1st 2010 XCOPY /E /D:01-01-2010 c:\Sourcepath\*.* c:\Destpath\*.* // D: is in mm-dd-yyyy format This will copy any files modified since January 1st 2010. If the destination file does not exist, it will copy the original over. The...

    • Type: Article
    • Author: Joel Lipman
    • Category: MS-DOS
    • Language: en-GB
  7. Quadcopter App with Flight Restrictions (JQA)https://www.joellipman.com/component/content/article/quadcopter-app.html?catid=53&Itemid=165

    in this area at all. Red: Prohibited Area: Do NOT fly in this zone at all! Blue: Location Marker: Represents the area you will be flying in. Green: Model Aircraft Club (the only places you're supposed to be flying). Black: Earthquakes & Extreme Weather:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  8. Zoho Creator: Set Up Custom Domain for Customer Portalhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-set-up-custom-domain-for-customer-portal.html

    on a remote assist who has access to do this, click on the red "Verify Now" link. The sidebar for "Domain Verification" will poup on the right. Note the small code and prefix it to your parent domain (eg. abcd12.joellipman.com) and note the CNAME which...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  9. ZohoCRM & Xero Real-Time Invoices: Receive Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-xero-real-time-invoices-receive-webhook.html

    CRM function to receive the webhook. Setup a webhook in Xero. [Optional for Method #2] Setup a PHP script on a server that will validate the Xero webhook. You're going to need to respond to Xero with valid and invalid HTTP statuses as their webhook...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  10. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL)https://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-shopify-api-integration-oauth-2-0-update-2022.html

    the previous version was limited by our ability to search by product SKU. The new version, taking advantage of GraphQL, will be able to search by SKU and retrieve the correct product ID, variant ID, and inventory ID from Shopify. How? The below details...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  11. Zoho Creator: Radio group into Calendar Carouselhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-radio-group-into-calendar-carousel.html

    || type Date) Selected Date (link name: Selected_Date || type Date) The CSS So first of all the value of each radio item will be populated using deluge and what's important to note here is that each picklist/dropdown option includes some HTML,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  12. Zoho CRM & Creator: Download attachment and upload to Creator file fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-creator-download-attachment-and-upload-to-creator-file-field.html

    from CRM and upload to a "file upload" field in Creator. Why? My use case here is that we are creating a Creator app that will show the attachments on a CRM contact record (and be clickable). The complication here is that the user can use the Creator...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  13. Zoho CRM: Manage a subform using Client Scripthttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-manage-a-subform-using-client-script.html

    in to detail on how to add a client script, this article is just to show the snippet of code used in the client script which will manage a subform. The module we are applying this client script to is a custom module called "Deployments". The field which...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  14. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRMhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-zohowriter-generate-rich-email-signatures-in-crm.html

    function to upload generic images (such as facebook, instagram, icons, and partner logos). This function is for images that will be on all signatures and don't have anything identifying per user. So this function uploads the image to the client's...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  15. ZCRM Client Script: Correct Decimal Fields OnLoadhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zcrm-client-script-correct-decimal-fields-onload.html

    limit in ZohoCRM. Why? So we have a customer that has some decimal fields on the products module that are calculated and will sometimes return numbers with more than 6 decimal places. As this is more than specified on the ZohoCRM field properties, as...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  16. ZohoCreator: Using .toFile and Uploading to a Creator fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zohocreator-using-tofile-and-uploading-to-a-creator-field.html

    Zoho Creator. Why? The use-case here is that we want a file to be hosted within Zoho Creator for use by a JS widget that will download the CSV (in this case a Text *.txt) file for use by a dynamic auto-suggester dropdown; one of those fancy ones that...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  17. Installing phpBB3 for Joomla with a RocketTheme templatehttps://www.joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

    installs similarly to Joomla CMS. As a personal preference, I set up a new database and a new mysql database user which will be used to store the phpBB3 system. For installation purposes, this mysql user has been granted all privileges (change this...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  18. Search a database for a string (MySQL, T-SQL)https://www.joellipman.com/articles/else/database/search-a-database-for-a-string-mysql-t-sql.html

    and usage @Tablenames -- Provide a single table name or multiple table name with comma seperated. If left blank , it will check for all the tables in the database @SearchStr -- Provide the search string. Use the '%' to coin the search. EX : X%--- will...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  19. MySQL parameters in Excel 2007 PivotTableshttps://www.joellipman.com/articles/else/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

    doesn't put you off but after much Googling and Bing-ing, I still couldn't figure out how to do this. Hopefully this article will help you more than my search engine skills do. My Setup Windows XP Workstation...needs to open... Excel 2007 SP2...with...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  20. Display a thumbnail of a Google Drive videohttps://www.joellipman.com/component/content/article/display-a-thumbnail-of-a-google-drive-video.html?catid=61&Itemid=165

    file. How? The hardest part of this is to get the Google Drive File ID (which you need for the below). The image link (src) will be as below but then this is a redirect to the actual thumbnail stored by Google Drive:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
Results 41 - 60 of 358