Assuming null is required, the following 72 results were found.
-
"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
- 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
- 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
-
Drop If Object Existshttps://www.joellipman.com/articles/database/t-sql/drop-if-object-exists.html
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: *
-
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
-
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
-
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: *
-
- 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
-
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
- 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
- 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
- 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
- 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
- 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
- Language: *
-
Service (SSRS) report. I am guessing that Series1 is the data series from an outer join where the joining index value is null. The chart below has 3 series or data fields: Count the total number of incidents logged (Y-axis - data fields) Invidividual...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
get a row from my custom audit table SELECT ApprovalID, ArticleID, DateSigned FROM Audit_Publishing WHERE ArticleID IS NOT NULL -- yields: let's call it MyTable2: Query time: 0.016s. 4367 rows returned. ApprovalID ArticleID DateSigned ----------------...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
{ $row["Score"] = 0; foreach($terms_rx as $term_rx){ $row["Score"] += preg_match_all("/$term_rx/i", $row["PageTitle"], $null)*10; $row["Score"] += preg_match_all("/$term_rx/i", $row["PageContent"], $null); } $results_rows[] = $row; } }...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
(our confirmation page) / With 2 parameters provided in the main report (note: main report runs with incident number as NULL, the user can then add an incident number afterwards or when the initial report was run). The confirmation page just checks with...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
is what I've come up with: -- Drop Stored Procedure if already exists IF OBJECT_ID ( 'dbo.usp_MakeTableTemp', 'P' ) IS NOT NULL DROP PROCEDURE dbo.usp_MakeTableTemp; GO -- Create Stored Procedure CREATE PROCEDURE dbo.usp_MakeTableTemp @SchemaTableName...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
to create a stored procedure and saving it on a database): IF OBJECT_ID('usp_CountRecordsPerTablePerColumn', 'P') IS NOT NULL DROP PROCEDURE [usp_CountRecordsPerTablePerColumn]; GO CREATE PROCEDURE [usp_CountRecordsPerTablePerColumn] ( @p_Value int,...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF