Pure JS - Display Time Elapsed & Remaininghttps://www.joellipman.com/articles/web-development/js/pure-js-display-time-elapsed-remaining.html

30 October 2018 This is an example of Javascript code to update and display the elapsed/remaining hours minutes and seconds in real-time. Why? I know there are a lot of articles out there that write about the same, but this is an example that I was coding and found to...

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

Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://www.joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

02 February 2019 $response = curl_exec($ch); curl_close($ch); $output = json_decode($response, true); return $output; } 5. Get Minutes Remaining on cached token So usually an access token will last for 60 minutes, in this example, we are going to store the token value...

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

Migrate Joomla! 1.5.x to 2.5.x+https://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 components. If asked: "how long will it take", do not say 5 minutes. This script runs on average in 15 seconds. The remaining hours, days, weeks will be spent on bringing your website up to standard with all issues addressed and sporting the latest...

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

SSRS Querying on either of 2 Parametershttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-querying-on-either-of-2-parameters.html

19 July 2011 the student's ID (2 report parameters: @StudentADAccount [varchar] and @StudentReference [int] respectively). Most of the remaining datasets use the resulting @StudentReference number in their "where" clause. A student always has a "Student Reference"...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

A quick run through of setting up an export process in SITShttps://www.joellipman.com/articles/web-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

21 August 2014 is ticked. Store/save your XET Setting up the Stu-Talk Message Group (SMG) This should be done before continuing as the remaining screens will refer to this and allow you to specify the related SMG Run SMG from the menu system Enter a CODE (in our demo...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

SSRS Expand specific drilldown by defaulthttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-expand-specific-drilldown-by-default.html

23 February 2011 parameter. What we want The user will select a date. We want the report to open with the specified day expanded and the remaining days that week to be collapsed (hidden). The first time I did this, I couldn't expand the remaining days so don't forget to...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

GDPR Privacy Policyhttps://www.joellipman.com/static-items/gdpr-privacy-policy.html

14 February 2019 reason unenforceable, that condition shall be deemed severable and shall not affect the validity and enforceability of any remaining condition. Website Privacy Policy Template This privacy policy sets out how JoelLipman.com uses and protects any...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Tagliatelle alla Carbonarahttps://www.joellipman.com/articles/_other-misc/tagliatelle-alla-carbonara.html

07 July 2009 the heat of the pasta will cook the egg. 6. Add the reserved cooking water if the sauce seems too thick, then stir in the remaining prosciutto and reserved butter. 7. To serve, spoon into warmed bowls and sprinkle with a little extra parmesan.

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

Installing phpBB3 for Joomla with a RocketTheme templatehttps://www.joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

28 September 2009 forum (eg. /phpBB3) Click on the "Save" icon. Click on the install button in the same row as phpBB Forum. Click on the remaining "install" buttons Test Now go to the front-end of your main website, login as a Joomla user and click on the link to your...

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

Alternate row background colour in Reporting Serviceshttps://www.joellipman.com/articles/microsoft/ssrs/alternate-row-background-colour-in-reporting-services.html

04 February 2011 scroll down to the "Fill > BackgroundColor" row and copy the value to your clipboard or notepad, etc. Then select all the remaining cells in the row and paste your expression in the "Fill > BackgroundColor" properties row... Done! Borders: I'm putting...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

The ReportServer Databasehttps://www.joellipman.com/articles/database/the-reportserver-database.html

08 August 2011 don't these match? Using in an aggregate, how do I get the milliseconds between start and end times instead of summing the remaining columns? Correction, sum will only give me the total time but what if a report has been run twice more often then...

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

SSRS Dropdown parameter cannot be blank!https://www.joellipman.com/articles/microsoft/ssrs/ssrs-dropdown-to-allow-blank-values.html

14 December 2011 have any options matching the ID above ("000000-0000-..."), this worked perfectly for me as my report didn't compare the 2 remaining dummy reports it couldn't find. It doesn't even mention them anywhere in the resulting report. One Issue The report will...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

T-SQL example of Case-Sensitive Soundexhttps://www.joellipman.com/articles/database/t-sql/t-sql-example-of-case-sensitive-soundex.html

10 October 2012 ----------------- Data Not Yet Available Which isn't at all what we set out to achieve other than it identified the remaining values as having the same SOUNDEX value. Adding the COLLATE option straight after the column that needs to be case-sensitive...

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

Parse a HTML Table into a ListViewhttps://www.joellipman.com/articles/web-development/html/parse-a-html-table-into-a-listview.html

30 March 2013 StringReplace,ReturnedHTMLTableColString,ReturnedHTMLTableColString,`r,,A ; strip any remaining html ReturnedHTMLTableColString := RegExReplace( ReturnedHTMLTableColString, "" , "") ReturnedHTMLTableColString=%ReturnedHTMLTableColString% ; split into an...

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

SSIS Skip Blank Rows in Flat File Sourcehttps://www.joellipman.com/articles/microsoft/ssis/ssis-skip-blank-rows-in-flat-file-source.html

23 April 2013 chars rather than Null). My example here is that the first column is our employee number and the second column will be the remaining data on that row. So I setup my connection manager as follows (note the "Ragged Right" and delimiter as "{CR}{LF}" - my...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

Zoho Deluge: Calculate Days, Hours, Minutes, Seconds between two Timestampshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-calculate-days,-hours,-minutes,-seconds-between-two-timestamps.html

21 September 2021 / 1000 / 60); info v_Minutes; v_UnixSeconds = v_UnixSeconds - (v_Minutes * 1000 * 60); // // determine seconds remaining v_Seconds = floor(v_UnixSeconds / 1000); info v_Seconds; // v_DayGrammar = if(v_Days == 1, "DAY", "DAYS"); v_HourGrammar =...

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

Zoho Creator: Copy Subform to other Subformshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-copy-subform-to-other-subforms.html

17 November 2021 and I want the user to be able to set entries in a subform called "Mondays" then to click a button which copies it to the remaining working days. How? So I have a form with 6 subforms which list staff/employee shifts from Monday to Saturday. The form I...

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