Assuming null is required, the following 72 results were found.
-
-- 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: *
-
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: *
-
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
-
. $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
-
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
- 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
- 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
- Language: *
-
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: *
-
WHERE `name` LIKE '%.category.%' ORDER BY `lastcatid` DESC LIMIT 0,1); SET @new_jos_assets_last_inc=( SELECT IFNULL(@new_jos_assets_last_inc, 0)); SET @new_jos_assets_id_last_lft=( SELECT MAX(`lft`) FROM `my_new_database`.my_prefix_assets); SET...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
Insert the user's name between the # five time fields and the command. while read user ; do crontab -l -u "${user}" 2>/dev/null | clean_cron_lines | sed --regexp-extended "s/^((\S+ +){5})(.+)$/\1${user} \3/" >>"${temp}" done <
- Type: Article
- Author: Joel Lipman
- Category: Linux
- Language: *
-
Win32 Constantshttps://www.joellipman.com/articles/automation/autohotkey/win32-constants.html
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: *
-
means I only specify the table and then the columns. How? IF OBJECT_ID('usp_ListDistinctValuesAndCounts', 'P') IS NOT NULL DROP PROCEDURE [usp_ListDistinctValuesAndCounts]; GO CREATE PROCEDURE [usp_ListDistinctValuesAndCounts] ( @p_SearchTable...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
= preg_replace( '/@[a-z]+/i','$0', $string_original); -- METHOD #2: equivalent using preg_match_all $matches = null; preg_match_all('/(?!\b)(@\w+\b)/',$string_original,$matches); foreach ($matches as $match) { foreach ($match as $mystring) {...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
We add a conditional split task to the data flow which only passes through rows from the Excel sheet which are not blank/null. Browsing the net, I found this is sometimes also used for inserting blank rows to act as dividers. Microsoft Certified...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
LEFT JOIN [sourcedb].[dbo].[lookup_ethnicities] f ON x.student_ethnicity_code=f.lookup_ethnicity_code Note this also allows NULLs so, our sequence identifier and student reference are never blank so it is safe to to use "Lookup Match Output" as rows...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
// get the AlertDialog XML layout file final View v = getLayoutInflater().inflate(R.layout.my_custom_dialog, null); // set the hint of the EditText in the AlertDialog EditText inputText = (EditText) v.findViewById(R.id.hangar_item_menu_name_field);...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
quoted by the PHP htmlspecialchars: "As of PHP 5.4 they changed default encoding from "ISO-8859-1" to "UTF-8". So if you get null from htmlspecialchars or htmlentities..." Source: PHP Manual My fix (in some cases): $my_description =...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
= 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
- 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
- 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
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF