Search - Joel Lipman .Com

1. Zoho Deluge: Determine your Statement Execution Limit: / Zoho /; ... statements; this is not true as the following counts 3 statements executed prior to the loop: // l_LoopInnerInner = " ".leftpad(5000); l_LoopInner = l_LoopInnerInner.replaceAll(" ", ","); l_Loop ...; Created on 31 July 2024
2. Zoho Books / Inventory: Get Item Rate from a Price Book/List: / Zoho /; ... price book rate post saving a record in Zoho Deluge would fail because it was making too many function statements. How? I have this code triggered in a workflow when the sales order is created to ...; Created on 23 May 2024
3. Zoho Books: System Values Maps: / Zoho /; ... statements, I can feed these maps a textual value and it returns the ID to use. Some of these can be found elsewhere in my site but I'm putting all of them here just for quick reference. How? Note ...; Created on 07 November 2023
4. Zoho Deluge - Counting in a Map dataType: / Zoho /; ... or account, and specifying the quantity for each. How? So depending on the number of levels, the count will be with a series if then else statements. See the results/yield section to determine ...; Created on 02 September 2019
5. Zoho Deluge - Get English Ordinal: / Zoho /; ... 2018". Why? Well there's a long a way to do it (but reliable). But being limited to the lines of code you can run (ref. "Maximum number of executable statements", anything that reduces the number ...; Created on 08 November 2018
6. SELECT COUNT(DISTINCT name) FROM table: / Joomla /; ... is an accepted answer over the web because as soon as I put a WHERE clause in the statements and check the numbers, only method 1 and 2 return the correct number. I'm still unsure as to why WHERE...GROUP ...; Created on 24 September 2015
7. Migrating from Joomla 2.5.x to 3.4.x: / Joomla /; ... MySQL statements against your database. For the purposes of this article, we will refer to the live/current/production website running Joomla v2.5 as "v25" and the new Joomla instance as "v34". Their ...; Created on 12 September 2015
8. Joes Word Cloud (JWC) Download: / Downloads /; ... Fixed bug: compilation failed for servers not supporting international characters. - Fixed bug: replaced string formatting foreach statements with legacy FOR statements.- Date Uploaded: Tue, 4th Jan 2011 ...; Created on 07 September 2015
9. Excel: convert degrees minutes seconds to decimal: / Excel /; ... You could merge all the statements into one but for simplicity's sake I'm putting each step here: In column C put the formula: =MID(B1, 1, FIND("°", B1)-1) In column D put the formula: =MID(B1,FIND("°",B1)+1, ...; Created on 06 November 2014
10. Regular Expressions in SQL: / Databases /; What? Practice makes perfect. Or in my case, any practice is a start. This article serves as a quick note on how to use regular expressions within SQL statements: How? For the following examples, ...; Created on 09 January 2014
11. A for loop within a for loop in MS-DOS: / MS-DOS /; ... the two above FOR statements: FOR /F "tokens=2,3* delims=_" %%A IN ('DIR InitializingFile*') DO FOR /F "tokens=1,2* delims=." %%I IN ('ECHO %%A') DO ECHO %%I -- yields: 123 456 So Job done. ...; Created on 03 October 2013
12. SSIS Convert a string into a date: / SQL Server Integration Services /; ... failure. -- often when processing a datasource, the function is being applied to a NULL date timestamp. Dealing with Date NULLs: Fix: Put conditional statements to account for NULLs. -- Standard TRIM(This_Date) ...; Created on 14 March 2013
13. JDatabase: using the Joomla database with examples: / Joomla /; ... quick note on how to chain, the following two statements are equivalent: -- note the semi-colons at the end of each line $query->select($db->quoteName(array('user_id', 'user_name'))); $query->from($db->quoteName('#__users')); $query->where($db->quoteName('user_id') ...; Created on 27 January 2013
14. Delete related records from multiple tables: / MySQL /; What? So this is a quick article on how to delete from multiple tables in a mySQL database where we use some JOIN statements. Why? It is never recommended to delete from multiple tables and instead ...; Created on 11 January 2013
15. Search a database for a string (MySQL, T-SQL): / Databases /; ... %X--- will give data ending with X %X%--- will give data containig X @GenerateSQLOnly -- Provide 1 if you only want to generate the SQL statements ...; Created on 08 October 2012
16. MySQL last year week month day trend periods: / MySQL /; ... since becoming an analyst, I do more at the database level now. What follows should be usable mySQL statements to get all the numbers: Yesterdays -- CURRENT: count todays SELECT COUNT(id) FROM ...; Created on 31 October 2011
17. MySQL: Find records in one table that are not in another.: / MySQL /; ... And here is the dilemma. The 3 below SELECT statements were derived from a post to the Stack Overflow website about the best way to check for rows in one table which don't exist in another. -- ...; Created on 25 February 2011
18. Connection Strings for SQL Server: / SQL Server /; ... before terminating the attempt and receive an error. Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;Connection Timeout=5; Inactivating prepared statements Use this ...; Created on 05 January 2011
19. If Then Else in Report Builder 2.0 Expressions: / SQL Server Reporting Services /; Yes, well don't laugh, I 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 ...; Created on 06 May 2010