Assuming isnull is required, the following 77 results were found.
-
for each m_ContactResult in l_SearchContacts { // // if found then simply update the contact if(!isNull(m_ContactResult.get("id"))) { v_CrmContactID = m_ContactResult.get("id"); m_UpdateContact = Map();...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
DELETE FROM @SQLTbl WHERE WHEREClause IS NULL WHILE EXISTS (SELECT 1 FROM @SQLTbl WHERE ISNULL(Execstatus ,0) = 0) BEGIN SELECT TOP 1 @tmpTblname = Tablename , @sql = SQLStatement FROM @SQLTbl WHERE ISNULL(Execstatus ,0) = 0 IF @GenerateSQLOnly = 0...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
field to allow Image as "Link" not just "Local Computer" or "Camera"): for each r_Image in m_Product.get("images") { if(!isnull(r_Image.get("src"))) { if(isnull(v_MainPhoto)) { v_MainPhoto = "
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
= Download_File[Owner_Email == v_ResultEmail && File_Ref == v_ThisFileCrmID]; if(r_CreatorFile.count()>0) { if(!isnull(r_CreatorFile.File_Download)) { v_LinkToDownload = v_CreatorBaseUrl + "/file" + zoho.appuri + "Download_File_Report/" +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
mandatory fields have been entered) for example: // // check mandatory fields have been entered l_Errors = List(); if(isnull(input.Record_Name)) { l_Errors.add("- Record Name"); } if(l_Errors.size() > 0) { alert "Please enter the following required...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
= List(); v_QuoteRefID = "0"; v_CrmOppID = "0"; v_OwnerName = ; v_AppLinkName = ; v_FormLinkName = ; v_ViewLinkName = ; if(!isnull(salesorder.get("salesorder_id"))) { v_CreatorSoID = salesorder.get("salesorder_id"); } v_SearchCriteria =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
= invokeurl [ url :v_TokenEndpoint type :POST parameters:m_Params headers:m_Headers ]; //info r_eBayResponse; if(!isnull(r_eBayResponse.get("access_token"))) { // info "New Token Generated"; r_Api.Access_Token=r_eBayResponse.get("access_token");...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
invokeurl [ url :v_Endpoint type :GET headers:m_Header ]; for each r_ShopifyProduct in r_GetProducts.get("products") { if(!isnull(r_ShopifyProduct.get("id"))) { l_ProductIDs.add(r_ShopifyProduct.get("id")); } } l_ProductIDs.sort(); v_LastID =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
"pdf", r_ContactRecord.get("Email"), m_MergedData, "joels_connector"); if(!isNull(r_SendResponse.get("records"))) { v_Grammar = if(r_SendResponse.get("records").size()==1,"","s"); v_OutputMessage = v_OutputMessage + "Generated and sent " +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Tab_Section_2; hide Tab_Section_3; hide Tab_Section_4; hide Tab_Section_5; hide Tab_Section_6; hide Tab_Section_7; // if(isNull(input.Tabs) || input.Tabs == "Quote") { show Tab_Section_1; } else if(input.Tabs == "Product Details") { show Tab_Section_2;...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
to most recent) r_SearchResults = zoho.books.getRecords("customerpayments",v_BooksOrgID,m_SearchCriteria,"zbooks"); if(!isnull(r_SearchResults.get("customerpayments"))) { l_SearchResults = r_SearchResults.get("customerpayments"); for each r_Result in...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
+ "\""; } v_Shopify_Created = v_ProductCreated.getPrefix("Z").replaceAll("T"," "); v_Shopify_PublishedStr = if(!isNull(v_ProductPublished),v_ProductPublished,v_Shopify_Created); v_Shopify_Published =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
url :"https://books.zoho.eu/api/v3/settings/taxes?organization_id=" + v_BooksOrgID type :GET connection:"joel_books" ]; if(!isnull(r_Taxes.get("taxes"))) { for each r_Tax in r_Taxes.get("taxes") {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
= 0; v_TotalCategories = r_Categories.toJSONList().size(); for each m_Category in r_Categories.toJSONList() { if(!isNull(m_Category.get("count"))) { v_TotalProducts = v_TotalProducts + m_Category.get("count"); } } info v_TotalProducts + " in " +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
+ ";}"; v_CssStyle = v_CssStyle + ""; input.Note_ColorPicker_Css = v_CssStyle; Code for On User Input of Color Picker: if(!isNull(input.Color_Picker) && !input.Color_Picker.contains("button")) { v_HeximalRef =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
:GET connection:"zcrm" ]; l_DealData = ifnull(r_RecordDetails.get("data"),List()); for each m_DealData in l_DealData { if(!isNull(m_DealData.get("id"))) { r_DealDetails = m_DealData; if(!isNull(r_DealDetails.get("Pipeline"))) { v_Pipeline =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
values from 'arguments' passed in the javascript code m_Arguments = ifnull(m_RequestParams.get("arguments"), Map()); // if(!isNull(m_Arguments.get("p_AccountID"))) { v_AccountID = m_Arguments.get("p_AccountID").toString(); v_Output = "Info: Recognized...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
) 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 from_index, number_of_rows ROW_NUMBER() OVER(ORDER BY column_name ASC) AS...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
value doesn't exceed the column size p.SetValue(Row, ValueToConvert, null); } } catch (Exception e) { // Only handle ColumnIsNull and NullReference Exceptions if (e.GetBaseException() is Microsoft.SqlServer.Dts.Pipeline.ColumnIsNullException ||...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
v_OldKey = v_OldInvoiceItemID + "|" + v_OldInvoiceLineItemQuantity + "|" + v_OldInvoiceItemRate; if(!isnull(m_NewLineItems.get(v_OldKey))) { m_LineItem.put("salesorder_item_id",m_NewLineItems.get(v_OldKey)); } l_UpdateLineItems.add(m_LineItem); } // //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF