Assuming yields is required, the following 93 results were found.
-
v_FormattedString = v_Test.replaceAll("(\"[^\",]+)[,]([^\"]+\")","$1|mySpecialComma|$2",false); info v_FormattedString; // yields: 00011,Joel Lipman,"Flat 8|mySpecialComma| House Corner",Brummieland // split into a list (string delimited by commas)...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
+ ", " + v_Hours + " " + v_HourGrammar + ", " + v_Minutes + " " + v_MinGrammar + ", " + v_Seconds + " " + v_SecGrammar ; // yields: 0 DAYS, 23 HRS, 54 MINS, 11 SECS Convert Total Minutes to Hours:Minutes This is for other scenarios: v_TotalMinutes =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
+ v_LeadStatus + "\""); m_Output.put("status","error"); } } // // return response return m_Output; Click "Save" and Done! Yields: Additional Note(s): If the user's profile is blank, the rule will not apply to them. l_Disallowed = List();...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
"https://www.zohoapis.com/crm/v3/settings/business_hours" type: GET connection: "mycrmconnection" ]; info r_OrgDetails; Yields something like { "business_hours": { "business_days": [ "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday" ],...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
l_Loop = " ".leftpad(5000).replaceAll(" ", ",").toList(); // for each index v_Iteration in l_Loop { info v_Iteration; } // yields an incremental count from 0 to 4999 Statement Execution Limit is 10000 If the below runs successfully, then the limit is at...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
AS QualificationRef FROM Qualifications q INNER JOIN Employee e ON RIGHT('000' + CAST(e.ID AS VARCHAR), 3)=q.Employee -- yields EmployeeNo QualificationRef -------------------------------- 001 00101 001 00101 Almost useful... but the qualification...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
NOW() ) + 6 DAY ) ) AS ThisDate, DAYNAME( DATE_ADD( NOW( ) , INTERVAL 0 - WEEKDAY( NOW() ) + 6 DAY ) ) AS ThisDay -- yields -- ThisDate ThisDay -- ----------- -------------- -- 2013-12-02 Monday -- 2013-12-03 Tuesday -- 2013-12-04 Wednesday --...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
5 seconds ago // then $v_Str = "17 minutes ago" Or how about $v_Str = getTimeAgo('-1 week 2 days 4 hours 2 seconds'); // yields "1 week ago" $v_Str = getTimeAgo('last Monday'); // yields "3 days ago" (it's Thursday) $v_Str = getTimeAgo('first day of...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
format (yyyy-mm-dd) to European format (dd/mm/yyyy)? See the following: -- assuming value of DATE_OF_BIRTH is blank or null yields // -- errors How? I could correct this using SSIS but with all the data in XML, we might as well stick with the technology...
- Type: Article
- Author: Joel Lipman
- Category: XML Stylesheet Language Transformations
- Language: *
-
like which appends the functions instead and is clearer for me personally to understand: // I want 010 v_NextIndex = 10; // yields 10 v_NextIndexStr = v_NextIndex.leftpad(3); // yields " 10" v_NextIndexStr = v_NextIndex.leftpad(3).replaceAll(" ", "0");...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
= 'JOE ' + CHAR(9) + CHAR(10) + CHAR(13) -- Before SELECT COUNT(*) FROM Employees WHERE Employee.ForeName = 'JOE' -- yields 1 -- What we want (equivalent?) SELECT COUNT(*) FROM Employees WHERE Employee.ForeName = @EmployeeStr -- yields 0 -- After...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
else { v_PreviousValue = m_ProductCount.get(v_SKU); m_ProductCount.put(v_SKU,v_PreviousValue + 1); } } info m_ProductCount Yields: { "TEST001": 6, "TEST002": 1 } Counting total products per account: // // count total products per account m_Accounts =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
2, 3"); // Push to Creator: m_CrmFields = Map(); m_CrmFields.put("My_MultiPicklist": l_MyMultiPicklist.toString(",")); // Yields ERROR: Failure, Invalid column value \"Options 2, 3\" specified // i.e. Cannot match picklist option in Creator (Options 2...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
v_TestDate.toList("/").get(0); info v_DelugeDate; info v_DelugeDate.toDate(); info v_DelugeDate.toString("E, d MMM yyyy"); Yields: 07/01/1975 01-Jul-1975 Tue, 1 Jul 1975 ********************* 1975-01-07 07-Jan-1975 Tue, 7 Jan 1975 *********************...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
v_BooksCurrencyID = m_Currencies.get(ifnull(r_AccountDetails.get("Currency"),"GBP")); info v_BooksCurrencyID; Yields something like: { "EUR": "123456789012345678", "GBP": "234567890123456789", "USD": "345678901234567890", } 234567890123456789 Get Taxes...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
= l_ProductIDs.get(l_ProductIDs.size() - 1); } // // output info "[" + l_ProductIDs + "]"; info l_ProductIDs.size(); } Yields something like: [ 1234567890123, 2345678901234 ] 2 Well that produces a lot of ID numbers delimited by a comma. However, to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
dd-MMM-yy"); info v_Tomorrow.toString("EEEE dd-MMM-yy"); info v_NextDay.toString("EEEE dd-MMM-yy"); // // yields: // Saturday 30-Oct-21 // Monday 01-Nov-21 // Tuesday 02-Nov-21 Note that Sunday is day 1 of the week. Saturday is day 7 of the week. Here's...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
first subform of this record for each r_SubformRow in r_Record.mySubform2 { v_StartTime = r_SubformRow.Start_Time; } } } // yields // UnPredictable exception, Invalid statement found Line:(20) However, I'm not bad at producing errors so here's another...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
yyyy-MM-dd HH:mm"); info "End Date (Next Year): " + v_DST_EndTime.toString("EEEE, yyyy-MM-dd HH:mm"); Yields: Start Date (Current Year): Sunday, 2021-03-14 02:00 End Date (Current Year): Sunday, 2021-11-07 02:00 Start Date (Next Year): Sunday,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
"Father & Sons"; v_DecodedString = thisapp.DataCleansing.fn_DecodeHtmlEntities(v_TestString); info v_DecodedString; // yields: Father & Sons A more comprehensive list v_HtmlEntityNames =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *