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

  1. SSRS Dropdown parameter cannot be blank!https://www.joellipman.com/component/content/article/ssrs-dropdown-to-allow-blank-values.html?catid=75&Itemid=165

    Modifications: For all Parameters: » General - Untick "allow blank value" and "allow null value" (so these checkboxes are empty). » Available Values - "Get values from a query" = Select the dataset of the dropdown options. » Default Values - "Get values...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  2. Border settings not saving in SSRShttps://www.joellipman.com/component/content/article/border-settings-not-saving-in-ssrs.html?catid=75&Itemid=165

    time googling and still didn't find an answer. My situation is that I wanted to put an expression to format the border (empty cells have a border and non-empty don't). This was so that a grid would show for empty spaces. I wasn't getting very far...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  3. Joes FREE Website Thumbnailer (JWT)https://www.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=53&Itemid=165

    "screenshots" exists in the folder this program is run from. If it doesn't see one, it tries to create one. I personally empty that folder after a batch process but no, the program doesn't care. Question How can this be 100% FREE? Answer: I'm being...

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

    in Zoho Deluge. We match a pattern and replace everything out that conforms to the criteria so a true response will be an empty string: v_MyRegEx = "^[A-Za-z0-9._-]+@[A-Za-z0-9._-]+\.[A-Za-z]{2,}$"; v_MyString = "somewhere@beyondthesea.com";...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  5. 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

    } Note that for the above, if there are no matching records, r_Coql will simply return an empty string. Hence the check for isNull on the keys info and data. And yes, the part that took me about 8 hours and the key point above is to replace the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  6. Zoho CRM REST API: Stop Workflow from Triggeringhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-rest-api-stop-workflow-from-triggering.html

    options below but one that worked was initially guessed as "none" but then later found in the documentation could also be an empty list []. So there are a few trigger options but I'm listing the one(s) to stop workflows below to see if this helps...

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

    field twice? {"code":"MANDATORY_NOT_FOUND","details":{"api_name":"Call_Type","json_path":"$.data[0].Call_Type"},"message":"Empty Call Type","status":"error"} ok specify a call_type...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  8. Zoho Deluge: a HTML Entity Decoderhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-a-html-entity-decoder.html

    ...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  9. ZohoBooks: Stripe Terminal Integrationhttps://www.joellipman.com/articles/crm/zoho/zoho-books/zohobooks-stripe-terminal-integration.html

    of code as per best practices - Correct error: Check and update the code in line 74 as there is a Exception : Value is empty and 'get' function cannot be applied More Information: Navigate to payments, then find pending webhook response event,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  10. ZohoCRM: Get Organization Business Hours using Deluge/APIhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-get-organization-business-hours-via-deluge-api.html

    } c_Employee.Usual_Shift.insert(c_UsualShift); info "-------------"; } Yields something like: Error(s) Encountered Value is empty and '1234567000001234567' function cannot be applied: Possibly due to me trying to create and declare the subform before...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  11. Zoho Deluge: Using Remove Key on a Map and Copying Record Tagshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-using-remove-key-on-a-map.html

    ]; info r_AddTags; } } Fix to historical records This snippet uses COQL to find me all the deals where the tag is empty but the contact record wasn't. There is an additional/repeat action to add tags; the first attempts to copy over the color on a new...

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

    other link returned an error something along the lines of "template tpl load file styles prosilver login body does not exist empty". I backed up my local copy of the prosilver folder as well as my local copy of the Affinity for phpBB3 template. I...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  13. Migrate Joomla Users to WordPresshttps://www.joellipman.com/articles/cms/wordpress/migrate-joomla-users-to-wordpress.html

    Joomla or Wordpress that you have a PHP enabled server available. Here's code to top off the user migration, save it to an empty PHP file and upload/run it on your server: please test before using!

    • Type: Article
    • Author: Joel Lipman
    • Category: Wordpress
    • Language: en-GB
  14. Battery Constantly Drained on iPhonehttps://www.joellipman.com/component/content/article/battery-constantly-drained-on-iphone.html?catid=60&Itemid=165

    I think this is a brilliant example where trying to fix the problem is the very cause of the problem in the first place: The empty arrow next to the battery indicator tells you that location services is enabled but it is attached to a reminder that...

    • Type: Article
    • Author: Joel Lipman
    • Category: Apple
    • Language: *
  15. Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://www.joellipman.com/component/content/article/google-drive-oauth-using-service-account-in-php.html?catid=61&Itemid=165

    = '/access_token.dat'; 2b. Specify the impersonator Now for testing purposes you should leave this next variable as an empty string. If you leave this blank, the script will run through and connect to Google Drive using the Service Account. The script...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  16. Administrator Program Shortcut without Prompthttps://www.joellipman.com/component/content/article/administrator-program-shortcut-without-prompt.html?catid=80&Itemid=165

    I leave this blank but you could specify a working directory. OK the dialogs and close the Task Scheduler Right-click on an empty space on the desktop and select New > Shortcut Type in the task with the format schtasks /run /tn "task-name" schtasks /run...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  17. Hide a Drive per User in Windows 7https://www.joellipman.com/component/content/article/hide-a-drive-per-user-in-windows-7.html?catid=80&Itemid=165

    In the right pane of Explorer, right click on a empty area, click on New > DWORD (32-bit) Value > type NoDrives > Enter. Right click on the DWORD you just created and click on Modify. Type in the drive option hex or decimal number from the list below...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  18. Windows Live Mail Error ID: 0x8DE00005https://www.joellipman.com/component/content/article/windows-live-mail-error-id-0x8de00005.html?catid=80&Itemid=165

    (changing the log-on username to your own): The downloading of all your folders will take a while so don't panic if you find empty folders. Doing a 'send/receive' will bring up the dialog showing its progress. Source: Windows Live Mail and Outlook Mail...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
  19. T-SQL: Parse an XML valuehttps://www.joellipman.com/articles/else/database/t-sql/t-sql-parse-an-xml-value.html

    FROM [dbo].[XML_EVENTS] Issues: XQuery [value()]: 'value()' requires a singleton (or empty sequence), found operand of type 'xdt:untypedAtomic *' This is because more than one record was returned so you need to surround with brackets and append a [1] as...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  20. Accessing a MySQL Database with Business Intelligence Development Studiohttps://www.joellipman.com/articles/else/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

    New Report" Select the "Shared Data Source" you just created > Next Click on the "Query Builder" button Right-click on any empty space in the first frame > Select "Add Table..." Add and specify the query as you would with any SQL query. (to create the...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
Results 21 - 40 of 50