Assuming null is required, the following 73 results were found.
-
the new table `#_categories` where `id` > 7 Add column in #_content just before note called `xreference` VARCHAR(50) allows NULL. Import Content (articles): export SQL file and amend the insert(s) into the new table `#_content` Import Users: export SQL...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
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 MSDN page for the closest solution but it still didn't work for me....
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
An article 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...
- Type: Article
- Author: Joel Lipman
- Category: XML Stylesheet Language Transformations
- Language: *
-
a more specific one. -- drop a stored procedure if it exists IF OBJECT_ID ( '[Common].[usp_MyStoredProcedure]', 'P' ) IS NOT NULL DROP PROCEDURE [Common].[usp_MyStoredProcedure]; GO -- drop a view if it exists IF OBJECT_ID ( '[Common].[uvw_MyView]', 'V'...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
view to generate random numbers on SQL Server. -- Drop the view if it already exists IF OBJECT_ID ('vwRandom', 'V') IS NOT NULL DROP VIEW vwRandom ; GO -- Used to reference RAND within a function CREATE VIEW vwRandom AS SELECT RAND() as RandomValue; GO...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
Note(s): Just a list of fields to build up a Product Line Item: "Product_Details": [ { "product": { "Product_Code": null, "Currency": "USD", "name": "Test Product", "id": "1642130000000104087" }, "quantity": 1, "Discount": 0, "total_after_discount": 0,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
for availability m_ProductCount = Map(); for each r_StockRecord in Stock_Upload[ID != 0] { if(m_ProductCount.get(v_SKU) == null) { m_ProductCount.put(v_SKU,1); } else { v_PreviousValue = m_ProductCount.get(v_SKU);...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
"success" } ] } and if using code to capture the ID: v_ResultingQuoteID = 0; if(r_CreateCrmQuote.toMap().get("data") != null) { if(r_CreateCrmQuote.toMap().get("data").get(0) != null) { if(r_CreateCrmQuote.toMap().get("data").get(0).get("details") !=...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
(moved) and the connection "zbooks" has a fullaccess scope: // // initialize v_PaymentMode = ""; v_PaymentDate = null; v_Last4Digits = ""; r_UpdateInvoice = Map(); // // evaluate v_InvoiceID = invoice.get("invoice_id"); v_CustomerID =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
headers:m_Header ]; //info r_GetProductVariants; // // parse the response if(r_GetProductVariants.get("data") != null) { if(r_GetProductVariants.get("data").get("productVariants") != null) {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
sure you can lock it down to just the scopes you need. void ZohoBooks.fn_SendZohoBooksInvoice(int p_OrderID) { v_OrderID = ifnull(input.p_OrderID,0).toLong(); /* ******************************************************************************* Function:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
order of my parameters (I will be checking "Student Username" first as "Student Reference" must be calculated and not blank/null): So I tried setting the "Available Values" as suggested by Stack Overflow to gets its value based on the first parameter...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
- Sorna Kumar IF OBJECT_ID('usp_SearchDB','P') IS NOT NULL DROP PROCEDURE usp_SearchDB GO CREATE PROCEDURE usp_SearchDB @Tablenames VARCHAR(500) ,@SearchStr NVARCHAR(60) ,@GenerateSQLOnly Bit = 0 AS /* Parameters and usage @Tablenames -- Provide a...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
date) Other If-then-else IF( expression,value_if_true,value_if_false ) IIF( expression,value_if_true,value_if_false ) If Null IFNULL(column_name,value_if_null) ISNULL(column_name,value_if_null) Rank/Rownum (@rownum:=@rownum+1) AS Rownum LIMIT...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
user/system account that will run it. -- Drop the function if it already exists IF OBJECT_ID ('ufn_DataJumble', 'FN') IS NOT NULL DROP FUNCTION ufn_DataJumble ; GO -- Create user defined function CREATE FUNCTION ufn_DataJumble ( @OrigVal varchar(max) )...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
processing the overall report. How? Browsing the web for a solution, most suggest using NVL() but this only replaces a NULL value with a string of your choice; and even if you NVL all returned fields, no rows are returned, and not a row of...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
d MMM yyyy"); } info v_RegexdDate; info "*********************"; // // pure Deluge no Regex v_DelugeDate = null; if(v_TestDate.toList("/").size()>2){ v_DelugeDate = v_TestDate.toList("/").get(2) +"-"+ v_TestDate.toList("/").get(1) +"-"+...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
a Zoho Creator page excluding the content (edited for Public display - Not the used final version): 0) { if(c_Quote.Name != null) { v_Firstname = c_Quote.Name.first_name; v_Lastname = c_Quote.Name.last_name; } if(c_Quote.Email != null) { v_Email =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
} // Log the parsed output for debugging console.log("Parsed output:", parsedOutput); // If parsedOutput is undefined or null, set a default message if(parsedOutput === undefined || parsedOutput === null) { let errorOutput = r_SubData?.message ||...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
. $credentials['expires_in'] . 'S')); if ($current_time->getTimestamp() >= $expire_date->getTimestamp()) { $credentials = null; unlink($path); } return $credentials; } // store new credentials in file function storeCredentials($path, $credentials) {...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB