Assuming blank is required, the following 75 results were found.
-
This is a quick article to remind me on how to skip blank rows when using a Flat file as a data source. I would receive another Microsoft error as clear as mud: Error: The conditional operation failed. Error: SSIS Error Code...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
for the below as it was copied from http://hosteddocs.ittoolbox.com/ST030504.pdf. A "Crystal Decisions" documentation. Blank columns appear when exporting to Excel. There are four main causes for extra blank columns to appear in a worksheet. Cause 1:...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: *
-
OPTIONAL. When I leave the 3rd and 4th parameter untouched (=""), the report complains saying "Report #3 parameter cannot be blank!". Before you ask, I have ticked both "Allow Blank" and "Allow NULL". How? This is the tough part. I was reading up on the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
A really quick article to test when to use isNull and isBlank. Why? So I've noticed that looking at people's Zoho Deluge code, there will often be a check on a null before or after the variable: if(v_Test.isBlank()) {... } VS if(isBlank(v_Test)) {......
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
So following the above, I end up with: Then I want the ID parameter ("@StudentReference") to populate itself if it is left blank when the report is executed. So my first dataset has to include the Username check as well (…WHERE...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
for cast specification". Exceptions for text file where I needed two derived column tasks, the first checks if the Date was blank and puts a NULL string. The second takes this string and converts it to a date: -- Assuming EndDate is optional (can be...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
you want to do that?". Anyway, I was looking for something like the record separator in Oracle SQL*Plus where a row of data (blank or made of symbols) separates two sets of data from within the same select query based on a column that's different. So...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
on how to declare an XML element as NULL using the attribute "xsi:nil". I'm going to use a very short example by providing a blank date of birth value: -- What I have: // -- What I want: Why? Outputting from SITS:Vision to our staging environment, the...
- Type: Article
- Author: Joel Lipman
- Category: XML Stylesheet Language Transformations
- Language: *
-
What? So I thought I'd write an article to help me resolve the particular issue where the organization details and the header of the product line items table would display on the first page, the product line items would then print on the second page,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Inventory
- Language: *
-
Thought I'd put a note about this as I spent ages rewriting an entire system. The HTTP_REFERER environment variable can be changed by the user anyway but I was using it as an additional validation check. The only solution is to not use it for...
- Type: Article
- Author: Joel Lipman
- Category: Microsoft
- Language: en-GB
-
Applies to: Microsoft SQL Server Reporting Services 2012 Microsoft Visual Studio 2012 Premium Microsoft Windows 7 Enterprise What? So I have a column in an SSRS report which displays a date. Being rather pernickety, I would like a question mark to...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
; FUNCTION TO HANDLE BOTH TOOLTIP AND MOUSEOVER EVENT WM_MOUSEMOVE() { static CurrControl, PrevControl, _TT ; _TT is kept blank for use by the ToolTip command below. CurrControl := A_GuiControl SearchButton_Over:=A_ScriptDir...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
view event details ******************************************************************************* */ // // initialize m_Blank = Map(); m_Response = Map(); v_BooksOrgID = organization.get("organization_id"); // // Stripe API Key (add your own here)...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
on the start date (first field in the subform) match in which case it should re-add the row with an "End Date" specified (blank or not). console.log("Joel Lipman - 20221018 -------------------------"); // get some values from the current record var...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
m_QuoteRecord.put("Name.last_name",v_SellerName_Lastname); m_QuoteRecord.put("Email",v_SellerEmail); // // other params m_Blank = Map(); // // send the request r_Create = zoho.creator.createRecord(zoho.adminuser, zoho.appname, "Quote", m_QuoteRecord,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
*/ // // need to respond in less than 1 second m_Payload = crmAPIRequest.toMap(); m_Blank = Map(); // // you created an app that generated a client ID and a client secret and resulted in an access token // the client secret used when generating the...
- Type: Article
- Author: Joel Lipman
- Category: Shopify
- Language: *
-
onLoad Purpose: Loads in a "TBC" so that the the naming of the invoice can happen on save Maps other fields to fill in the blanks Inputs: - Outputs: - Date Created: 2025-10-07 (Joel Lipman) - Initial release Date Modified: ??? - ??? More Information:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
This returns the number of unique values in the range A3 to A1000 and excludes the blank/empty cells. Display all Unique Found this note on one of Microsoft Help sites: Office 2010: Select the data range to do this to. Click on the "Data" tab. Click on...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
response beforehand. 1. Set up the Creator form Log-in to your Zoho Creator app Click on Plus sign to add a new form > blank Name the form, I'm going to call mine Shopify Webhook Payloads Drag some fields onto the form, this is what I did: Event Type...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
daily 24 hours after until end date ******************************************************************************* */ // // blank map to use m_Blank = Map(); // // set timezone of this user (this CRM is set to GMT-07:00 with daylight savings in effect)...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *