Assuming null is required, the following 73 results were found.
-
column as my index/key field so I can check if this is a valid data row (the blank ones may return special chars rather than Null). My example here is that the first column is our employee number and the second column will be the remaining data on that...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
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
-
(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
-
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
-
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: *
-
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
-
-- yields: sessionID sessionID sessionID --------- --------- --------- 148797 148797 148797 148798 148798 148798 148799 (null) 148799 148800 148800 148800 148686 148686 (null) -> The select here returns 5 rows -> A delete here would affect 13 rows....
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
{ $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
-
even I've made better DBMS tools). All SQL -- Add a column to an existing table (giving it datatype char(2) and allowing NULL) ALTER TABLE myTable ADD myColumn CHAR(2) NULL -- Delete a column ALTER TABLE myTable DROP COLUMN myColumn -- Reorder a column...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
Message Flags Const PM_NOREMOVE = 0 Const PM_REMOVE = 1 Const PM_NOYIELD = 2 ;#End Region ;#Region Windows Messages Const WM_NULL = $0000 Const WM_CREATE = $0001 Const WM_DESTROY = $0002 Const WM_MOVE = $0003 Const WM_SIZE = $0005 Const WM_ACTIVATE =...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
= zoho.creator.getRecords(v_OwnerName,v_AppLinkName,v_ViewLinkName,v_Condition,1,100,"joels_connection"); v_ResponseCode = ifnull(r_SearchResults.get("code"),500).toLong(); // // if found records if(v_ResponseCode == 3000) { v_RelatedListXML = "";...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
{"png","jpg","jpeg","gif","bmp","heic"}; c_Document = My_Form[ID == 1234567890]; // // for image field type v_PhotoFull = ifnull(c_Document.My_Photo,""); v_PhotoWithExt = v_PhotoFull.getSuffix("/image/").getPrefix("\""); v_PhotoFileExtension =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
for each r_Attachment in l_Attachments { if(r_Attachment.get("id") != null) { v_AttachmentEndpoint = "https://www.zohoapis.com/crm/v2/Contacts/" + v_CrmContactID + "/Attachments/" + r_Attachment.get("id"); r_Download = invokeurl [ url...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
most recent appointments where this field hasn't been populated l_Appointments = Appointment[Zoho_Inventory_Package_Slips == null] sort by Added_Time desc range from 0 to 100; for each c_Appt in l_Appointments { // // get package references specified in...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
quote details given a record ID r_QuoteDetails = zoho.crm.getRecordById("Quotes",p_QuoteID); // // check target email is not null/blank if(!isnull(r_QuoteDetails.get("Email"))) { v_Url = "https://zohoapis.com/crm/v2/settings/inventory_templates/" +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
is a Sunday, subtract a day, and return the week number: c_Order = Order[ID == 123456890123456890]; if(c_Order.Order_Date != null) { v_ThisDate = c_Order.Order_Date.toString("EEEE, dd-MMM-yyyy u w"); v_ThisWeek =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
from lead record r_LeadDetails = zoho.crm.getRecordById("Leads",p_LeadID); // // get created time (no need to check if null?) v_LeadCreatedTime = r_LeadDetails.get("Created_Time"); // // convert to time datatype v_TimeOffset =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
r_BooksItem = zoho.inventory.getRecordsByID("items", v_BooksOrgID, m_LineItem.get("item_id"), "zinventory"); m_BooksItem = ifnull(r_BooksItem.get("item"), m_Blank); v_BooksItemRate = ifnull(m_BooksItem.get("rate"),0.00); v_ThisQuantity =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
******************************************************************************* */ // // initialize v_LastSyncTime = null; v_LastSyncStatus = "?"; m_DataSourceInfo = Map(); // // read the TLD (eu or com or com.in) from the URL when logged into Zoho...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
up to 100k) m_Params = {"select_query":"select Product_Name, COUNT(id) 'Frequency' from Products where Product_Name is not null group by Product_Name limit " + v_PerPage + " offset " + v_Offset}; r_CoqlUniqueProducts = invokeurl [ url...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *