Assuming else is required, the following 112 results were found.
-
blank cursor { VarSetCapacity( AndMask, 32*4, 0xFF ), VarSetCapacity( XorMask, 32*4, 0 ) BlankCursor = 1 ; flag for later } Else If SubStr( Cursor,1,4 ) = "IDC_" ; load system cursor { Loop, Parse, SystemCursors, `, { CursorName := SubStr( A_Loopfield,...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
form, I'm calling mine Note_CSS, then I have added a radio group called Tabs [NB: If you rename it from "Tabs" to something else, all CSS references need to be changed as well to the new name and follow the syntax .zc-NewName-group{}]. What I have...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Value of TEST is a BLANK String"; v_Test = ""; if(isBlank(v_Test)) { info "isBlank Preceding is TRUE"; } else { info "isBlank Preceding is FALSE"; } if(v_Test.isBlank()) { info "isBlank Succeeding is TRUE"; } else { info "isBlank Succeeding is FALSE"; }...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
T-SQL Record Separatorhttps://joellipman.com/articles/database/t-sql/t-sql-record-separator.html
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
-
if(v_NextMonthMonday.getDayOfWeek()==2) { break; } } input.Next_Switch_Date = v_NextMonthMonday.toDate(); } } else if(input.Switch_Over_Day=="Last Tuesday of Month") { v_NextMonthDate = zoho.currentdate.addMonth(1); v_NextMonthDateLast =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
(COUNT(b.menutype) + 1) FROM `my_new_database`.my_prefix_menu_types b WHERE b.menutype LIKE CONCAT(a.menutype, '%') ) ) ELSE a.menutype END AS menutype, CASE WHEN a.title IN ( SELECT DISTINCT b.title FROM `my_new_database`.my_prefix_menu_types b) THEN...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
could not find this on the WWW so I was obviously not using Google properly. Anyway here's just a quick note on how to do if else statements in Report Builder 2.0 I'm looking at the following if statement: If (MyFieldName = 0) Then Return 1 Else Return...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
THEN t2.TABLE_NAME + ' (new)' WHEN t1.TABLE_NAME IS NOT NULL AND t2.TABLE_NAME IS NULL THEN t1.TABLE_NAME + ' (removed)' ELSE t1.TABLE_NAME END AS [Table_Name], CASE WHEN t1.COLUMN_NAME IS NULL AND t2.COLUMN_NAME IS NOT NULL THEN t2.COLUMN_NAME + '...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
THIS FIELD CONTAINS A DATE VALUE SET @DateMatch = CASE WHEN CAST(CAST(@OrigVal AS date) AS VARCHAR(10))'1900-01-01' THEN 1 ELSE 0 END; -- DETERMINE IF THIS FIELD CONTAINS A TIME VALUE SET @TimeMatch = CASE WHEN CAST(CAST(@OrigVal AS time) AS...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
THIS FIELD CONTAINS A DATE VALUE SET @DateMatch = CASE WHEN CAST(CAST(@OrigVal AS date) AS VARCHAR(10))'1900-01-01' THEN 1 ELSE 0 END; -- DETERMINE IF THIS FIELD CONTAINS A TIME VALUE SET @TimeMatch = CASE WHEN CAST(CAST(@OrigVal AS time) AS...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
subform of this record for each r_SubformRow in r_Record.mySubform1 { v_StartTime = r_SubformRow.Start_Time; } } // set an else if condition else if(r_Record.Type == "Subform2") { // loop through the first subform of this record for each r_SubformRow in...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
== "+") { input.GMT_Date_Time_Start = v_CustomersRequestedTime.subHour(v_CustomerHours).subMinutes(v_CustomerMinutes); } else { input.GMT_Date_Time_Start = v_CustomersRequestedTime.addHour(v_CustomerHours).addMinutes(v_CustomerMinutes); }...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
version needs updating... I'm writing this in case I ever have to upgrade other people's Joomla CMS and if it helps anyone else out there. How? There aren't too many steps but this is what I went through and I might amend this if I see any new issues:...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
if (file_exists("" . $_FILES["uploaded_file"]["name"])) { echo "".$_FILES["uploaded_file"]["name"] . " already exists. "; } else { move_uploaded_file($_FILES["uploaded_file"]["tmp_name"], "" .$_FILES["uploaded_file"]["name"]); echo "Stored in: " . ""....
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
IF p_original_range_1 IS NULL THEN v_rand_param1 := POWER(10, (LENGTH(p_original_value)-1)); -- should yield eg. 100000 ELSE v_rand_param1 := p_original_range_1; END IF; IF p_original_range_2 IS NULL THEN v_rand_param2 := POWER(10,...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
// // add the answer text to the response map m_Response.put("text",m_Choice.get("message").get("content")); break; } } } } else { // store in response text m_Response.put("text","I don't know. Consider doing a Google search."); } } // // output return...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
{ continue; } String name = parser.getName(); if (name.equals("title")) { title = readTitle(parser); } else if (name.equals("link")) { link = readLink(parser); } else if (name.equals("pubDate")) { date = readDate(parser); } else if...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
); // execute cURL request $response=curl_exec($ch1); if($response === false){ $output = 'ERROR: '.curl_error($ch1); } else{ $output = $response; } // close first request handler curl_close($ch1); // now let's get the ID of the file we just created //...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
FileSelectFolder, vSelectedFolder, 3, , Select a folder if vSelectedFolder = MsgBox, You didn't select a folder. else { vSelectedFolder := RegExReplace(vSelectedFolder, "\\$") ; Removes the trailing backslash, if present. GuiControl, , MyBaseDir,...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
$diff = $expiry_time - time(); $api['jwt']['token']['minutes'] = floor($diff/60); } 6a. Use existing Access Token This if else statement simply says if the token still has at least 5 minutes left, then use the one found at the file location specified...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB