Search - Joel Lipman .Com

1. Zoho Deluge: Calculate Days, Hours, Minutes, Seconds between two Timestamps: / Zoho /; What? A very quick article to calculate the time between two timestamps and break it down into days, hours, minutes and seconds. Why? I've done this in lots of other systems but here's one in Zoho ...; Created on 21 September 2021
2. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines): / Zoho /; What? This is an article to demonstrate how to handle commas in a CSV file that were enclosed between two double-quotes. I've added to this the handling of new lines or carriage returns in between a ...; Created on 26 August 2021
3. Zoho Deluge - Get distance between two coordinates: / Zoho /; What? A quick article to document how to calculate the distance "as the crow files" between two coordinates given the latitude and longitude of each. Why? Well, you can pay for a good Google solution ...; Created on 11 June 2019
4. Preg_Replace all strings between two tags: / Personal Home Page /; ... = preg_replace ( '/`([^`]+)`/', '$0', $string_original ); Replace contents between two tags () Convert: my outside string is now inside » my outside string is now inside $string_formatted ...; Created on 07 February 2013
5. Mootools - How to contain a menu sidebar between header and footer: / MooTools Framework /; Why? This has taken me too long to figure out and I hope I don't lose this note again. The only website that was titled similarly kept slowing down my computer too much so I decided to work out my own. ...; Created on 10 August 2012
6. Difference between two dates - the midnight hour: / Web-Development /; I might already have something similar to this but this deserves its own article. Why? Well try to search the web for a PHP/MySQL solution which suggests on how to count the hours between two times on ...; Created on 06 April 2011
7. Zoho Creator: Set Up Custom Domain for Customer Portal: / Zoho /; ... will take between 24-48 hours but I have often found that after a few hours, the effects have been propagated. A test I like to do is open the command-line in MS-Windows or the terminal on MacOS, and ...; Created on 17 November 2020
8. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; ... to in widget.html and secondly, the way you retrieve records in the Zoho JavaScript. If you do not include Zoho queries, then I have found the app can be ported between either Creator or CRM (as in pure ...; Created on 24 October 2020
9. Zoho Creator Page: Toggle On/Off Switch: Hide/Display a Div: / Zoho /; What? So this is an article documenting how to create an on/off toggle switch that hides and displays between 2 div layers in a Zoho Creator Page (so not a form or report but a page). Why? This ...; Created on 22 October 2020
10. Zoho Deluge - Get Refresh/Access Token API v2: / Zoho /; ... lasts between 1 to 10 minutes. : I have had this error with API v2 when I'm using PHP/cURL and not deluge to get a list of contact records. As I'm listing errors encountered, I'm adding it to this list. ...; Created on 17 July 2019
11. CSS Add Text to Breadcrumb Link with a Transition: / Cascading Stylesheets /; What? This is an article I hope to refine one day where given a set of breadcrumb hyperlinks, when I hover the mouse over the links, the text changes and the transition between the two is controlled ...; Created on 18 May 2019
12. GDPR Privacy Policy: / Static Items /; ... that the laws of the state of DEFINE_STATE, DEFINE_COUNTRY, without regard to principles of conflict of laws, will govern these Conditions of Use and any dispute of any sort that might arise between you ...; Created on 14 February 2019
13. Zoho Deluge - MD5 function: / Zoho /; ... of using MD5 in an encryption task. Why? I'm trying to create an ETag for a synchronization process between Zoho Creator and Zoho CRM. Combining all the fields to compare into a single field can' ...; Created on 19 November 2018
14. Foreign Characters create symbols in PHP and MySQL: / Personal Home Page /; Applies to: PHP 5.4 MySQL 5.1.4 Databases initially setup with collation 'latin1_swedish_ci' What Another article trying to help people display foreign characters on their website without ...; Created on 25 January 2016
15. Import Excel CSV file as JavaScript array: / Excel /; ... // clear and declare the array var column_values = []; // regex to ignore commas between double-quotes var column_values = ...; Created on 05 October 2015
16. Joes Word Cloud (JWC) Download: / Downloads /; ... Note: this version is also backwards compatible with Joomla v2.5.28- Date Uploaded: Thu, 12th Mar 2015 Download 3.2.3 Wolfgang - Fixed Bug: Forced spaces between links ...; Created on 07 September 2015
17. Excel: convert degrees minutes seconds to decimal: / Excel /; ... the formula: =MID(B1, FIND(F1, B1)+1, FIND("°", B1, FIND(F1,B1)) - FIND(F1,B1) - 1) // if there is a space between the two =MID(B1, FIND(F1, B1)+2, FIND("°", B1, FIND(F1,B1)) - FIND(F1,B1) - 2) In ...; Created on 06 November 2014
18. DJI Phantom FC40 - Fun at the races: / Quadcopters /; ... angles and routes I could have taken (NTS: Take picture of whole track beforehand and plan a route). Strong Winds: Fighting the wind to keep up with the cars. Keep as much space as possible between ...; Created on 17 September 2014
19. Include a carriage return in a column heading: / SQL Server /; ... This has to be a label to the name of the column enclosed between square brackets or double-quotes: Before: SELECT calendar.WeekNumber AS [Academic Week], calendar.Monday, calendar.Tuesday, calendar.Wednesday, calendar.Thursday, calendar.Friday FROM calendar -- ...; Created on 07 July 2014
20. ReCaptcha alternative: Integrate PlayThru in JComments 3.0 for Joomla 3.2: / Joomla /; Applies to: Joomla CMS v3.2.3 (Joomla.org) jComments v3.0.0 (JoomlaTune.com) PlayThru v1.1.8 (AreYouAHuman.com) What? This article is a follow on from my article JComments 2.3 with PlayThru ...; Created on 27 April 2014