Zoho Deluge: Determine your Statement Execution Limithttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-determine-your-statement-execution-limit.html

31 July 2024 Method Chaining: Contrary to my previously held belief, method-chaining still counted as separate statements; this is not true as the following counts 3 statements executed prior to the loop: // l_LoopInnerInner = " ".leftpad(5000); l_LoopInner =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Signhttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-zoho-sign-send-crm-merged-template-for-zoho-sign.html

06 August 2024 m_Templates.put("notes",""); m_Parameters.put("data",m_Data); m_Parameters.put("is_quicksend",true); // // Send the Zoho Sign Template with the pre-filled fields to the desired recipient/ recipients r_SignResponse =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

MacOs: Transcribe Training Video using OpenAI Whisperhttp://mail.joellipman.com/articles/apple/macos-transcribe-training-video-using-openai-whisper.html

23 June 2025 rec = KaldiRecognizer(model, wf.getframerate()) transcript = [] while True: data = wf.readframes(4000) if len(data) == 0: break if rec.AcceptWaveform(data): result = json.loads(rec.Result()) transcript.append(result.get("text", "")) # Get final result...

• Type: Article
• Author: Joel Lipman
• Category: Apple
• Language: *

Joomla Development: Possible XML Filtershttp://mail.joellipman.com/articles/cms/joomla/joomla-development-possible-xml-filters.html

17 October 2013 to be an absolute number (-4.2 becomes 4.2) FLOAT Forces the value to be a floating point value BOOL Forces the value to be true or false WORD Strips anything that is not letters (including numbers) ALNUM Forces the value to be alphanumeric (Letters and...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: en-GB

Joomla WHERE clause with ORhttp://mail.joellipman.com/articles/cms/joomla/joomla-where-clause-with-or.html

16 July 2014 I use the old form where I can include the whole SQL statement: $db->query('SELECT * FROM #__myTable WHERE condition1=true or condition2=true') Method #1 - chain: $query ->where($db->quoteName('condition1') . ' = '. $db->quote('true'),'OR')...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: en-GB

Zoho Deluge: Check Time Booking Slotshttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-check-time-booking-slots.html

05 December 2018 if(v_StartDate = thisRecord_StartTime)||(v_StartDate = thisRecord_EndTime) { doubleBooked=true; } }

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: en-GB

Zoho Deluge: Convert Map to URL Parametershttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-convert-map-to-url-parameters.html

09 March 2020 of converting a URL into a map, I'm using the following: v_ReturnedUrl = "https://api.joellipman.com/myapi?isAuthSuccessful=true&code=my_own_code&expires_in=299"; l_ReturnedUrlParts = v_ReturnedUrl.subString(v_ReturnedUrl.indexOf("?")+1).toList("&");...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: en-GB