Assuming null is required, the following 73 results were found.
-
of this query for order by) ) AS t1 ) -- Query that will display extracted data SELECT t2.*, CASE WHEN t2.Day=t3.Day THEN NULL ELSE 'Separator Marker' END as 'Marker' FROM tblDifference t2 Left Outer Join tblDifference t3 On t2.RowNumber=t3.RowNumber-1...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
= 0, 1, poi."Quantity") AS "PO Item Tax", poi."Quantity" AS "PO Qty", poi."FCY Tax Amount" AS "PO Line Tax", if_null(pshipping."PO Delivery", 0) AS "PO Total Shipping", if_null(pdiscrepancy."PO Discrepancy Total", 0) AS "PO Total Discrepancy",...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
t1 FULL OUTER JOIN [myDB2].[INFORMATION_SCHEMA].[COLUMNS] t2 ON t1.COLUMN_NAME=t2.COLUMN_NAME WHERE t2.COLUMN_NAME IS NULL ORDER BY t1.COLUMN_NAME -- columns in new database but not in old SELECT t2.* FROM [myDB1].[INFORMATION_SCHEMA].[COLUMNS] t1 FULL...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- 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: *
-
of documentation as to what this database is and how it populates its data. View: ExecutionLog InstanceName nvarchar(38) NOT NULL Name of the report server instance that handled the request. Usually YOURSERVERNAME\MSSQLSERVER ReportID uniqueidentifier...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
List readFeed(XmlPullParser parser) throws XmlPullParserException, IOException { parser.require(XmlPullParser.START_TAG, null, "rss"); String title = null; String link = null; String date = null; String desc = null; List items = new ArrayList(); while...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
UFN_DATASCRAMBLE ( p_original_value IN VARCHAR2, p_original_datatype IN VARCHAR2, p_original_range_1 IN VARCHAR2 DEFAULT NULL, -- no effect on strings p_original_range_2 IN VARCHAR2 DEFAULT NULL -- no effect on strings ) RETURN VARCHAR2 IS v_char_at...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
Days --------------- ------- ------- ------- ------- ------- ------- ------- ------- ----- Me 06:30 08:00 07:30 06:30 07:30 NULL NULL 36:00 4.86 Myself NULL 07:30 07:30 07:30 07:30 NULL NULL 30:00 4.05 I NULL NULL 08:00 08:00 08:00 NULL NULL 24:00 3.24
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
this route if a quote is specified (they were on the quote and clicked on the plus next to 'invoice') if (o_InvoicedQuote != null) { // check on the quote associated to this invoice var o_QuoteDetails = ZDK.Apps.CRM.Quotes.fetchById(o_InvoicedQuote.id);...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
= 0; public void chooseOrTakePhoto(View view) { final View v = getLayoutInflater().inflate(R.layout.dialog_edititem_photo, null); AlertDialog.Builder b = new AlertDialog.Builder(this); LayoutInflater inflater = this.getLayoutInflater(); b.setView(v);...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
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 null) and in format...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
it had before the move so I guess this has to be included: ALTER TABLE table_name MODIFY COLUMN misplaced_column BIT(1) NOT NULL DEFAULT b'0' AFTER other_column; -- OR A MORE COMPLETE EXAMPLE -- ALTER TABLE table_name MODIFY COLUMN misplaced_column...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
" + v_StripeCustomerKey); // // default to balance due on this Invoice v_AmountToPay = ifnull(invoice.get("balance"),0); // // Get custom Amount to Pay from Invoice l_CustomFields = invoice.get("custom_fields"); if(l_CustomFields.size() > 0) { for each...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
// // build the hash based on the payload body v_Data = ifnull(m_Payload.get("body"),""); v_VerifyHash = zoho.encryption.hmacsha256(v_ClientSecret,v_Data,"base64"); // // retrieve Shopify's Hmac SHA256 from the header v_ShopifyHash = "";...
- Type: Article
- Author: Joel Lipman
- Category: Shopify
- Language: *
-
string[] exceptionArray_that; // get the value we want to transform string ValueToConvert = p.GetValue(Row, null).ToString(); // PRIMARY transformation: Applies to all words // (lowercases and capitalizes first letter taking into account punctuation...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
PROCEDURE [Common].[usp_ScrambleMultivalue] ( @TableName VARCHAR(MAX), @ColumnName VARCHAR(MAX), @WhereClause VARCHAR(MAX) = NULL ) AS /***************************************************************************************************************** **...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
if(r_PackageSlip.get("package") != null) { if(r_PackageSlip.get("package").get("salesorder_id") != null) { v_SalesOrderID = r_PackageSlip.get("package").get("salesorder_id"); } if(r_PackageSlip.get("package").get("shipment_order") != null) {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Inventory
- Language: *
-
json_Arg.Start_Date = v_StartDateFormatted; // check if end date is specified and if it is then add to this row v_EndDate = null; v_EndDateValue = ZDK.Page.getField('Actual_Finish_Date').getValue(); if (v_EndDateValue !== null) { var v_LocalEndDate =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
"business_timing": [ "7:00", "18:00" ] }, { "days": "Saturday", "business_timing": [ "09:00", "15:00" ] } ], "daily_timing": null, "week_starts_on": "Monday", "same_as_everyday": false, "id": "123456789000000123456789", "type": "custom" } } Tidied Up...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
says to use remove() to remove a key from a map. In this case, the ID key and value pair. It would then tell me the list was null when I thought I was adding the map with the ID removed back into a list. The map itself was null. How? We are using an API...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *