AHK Countdown Tooltiphttps://joellipman.com/articles/automation/autohotkey/ahk-countdown-tooltip.html

17 July 2014 UpdateMessage: ; TOTALS ThisManySeconds:=DateDiff( A_Now, FinalDate, "s" ) ThisManyMinutes:=Floor(ThisManySeconds/60) ThisManyHours:=Floor(ThisManySeconds/3600) ThisManyDays:=Floor(ThisManySeconds/86400) ThisManyWeeks:=Floor(ThisManySeconds/604800)...

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

Room Availability Calendar in Business Intelligence Development Studiohttps://joellipman.com/articles/microsoft/ssrs/room-availability-calendar-in-business-intelligence-development-studio.html

23 March 2011 @GivenDate = '23/03/2011'; --First slot of the day SET @StartTime = @GivenDate + ' 08:00:00'; --Last slot of the day (30 minutes before the end) SET @EndTime = @GivenDate + ' 17:30:00'; ; WITH Times([Time]) AS ( --Select First hour in range SELECT...

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

How to Display Report Execution Time in SSRS (milliseconds)https://joellipman.com/articles/microsoft/ssrs/how-to-display-report-execution-time-in-ssrs.html

17 November 2011 + " hour(s)" + " , " + CStr(System.DateTime.Now.Subtract(Globals!ExecutionTime).Minutes) + " minute(s)" + ", " + CStr(System.DateTime.Now.Subtract(Globals!ExecutionTime).Seconds) + " second(s)" // yields // 0 hour(s), 1 minute(s), 2 second(s) This isn't...

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

Zoho Projects: Get All Eventshttps://joellipman.com/articles/crm/zoho/zoho-projects-get-all-events.html

22 July 2024 = l_ThisDateEventParts.get(0); l_ThisTimeEventParts = l_ThisDateTimeEventParts.get(1).toList(":"); v_ThisDateEvent_Minute = l_ThisTimeEventParts.get(1); v_ThisDateEvent_Hour = l_ThisTimeEventParts.get(0); // // convert 12-hour to 24-hour...

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

Zoho Deluge: Loop through 30 Minute Slotshttps://joellipman.com/articles/crm/zoho/zoho-deluge-loop-through-list.html

30 November 2018 What? This code snippet took me a while to do and the documentation is flaky so I thought I'd make a note here just in case I need to refer to it again. Why? I want to modify a picklist and fill it with options from a certain time of the day to the...

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

Zoho Deluge - Get Refresh/Access Token API v2https://joellipman.com/articles/crm/zoho/zoho-deluge-get-refresh-access-token.html

17 July 2019 using. You need to use the latest CODE as any new one expires any previously generated ones. A code lasts between 1 to 10 minutes. {"code": "AUTHENTICATION_FAILURE","details": [],"message": "Authentication failed","status": "error"}: I have had this...

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

Peanut Butter Milkshake Recipehttps://joellipman.com/articles/_other-misc/peanut-butter-milkshake-recipe.html

05 September 2009 or mug with as much milk as you wish (I use 1 cup); pour into blender, and add the vanilla and peanut butter. Whirl for 1 minute; add 2 scoops ice cream, then whirl 1 minute more. Servings: 1 Source:...

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

Pancakeshttps://joellipman.com/articles/_other-misc/pancakes.html

07 July 2009 hits the hot pan, tip it around from side to side to get the base evenly coated with batter. It should take only half a minute or so to cook; you can lift the edge with a palette knife to see if it's tinged gold as it should be. Flip the pancake over...

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

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

07 July 2009 egg tagliatelle Method 1. Heat the olive oil in a thick-bottomed saucepan. Add two-thirds of the prosciutto and fry for one minute. 2. Add 50g/2oz of the butter to the pan and allow to melt, then add the wine and simmer for 2-3 minutes, just to combine...

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

Database Error: Unable to connect to the database: Could not connect to MySQLhttps://joellipman.com/articles/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

25 September 2009 contacted my webhost, and the problem is the number of MYSQL database queries. It goes up to about 200,000 in the first few minutes of use and then after that every page load is a few hundred to few thousand queries (per page). The webserver limits me...

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

How To Make Chocolate Chip Cookieshttps://joellipman.com/articles/_other-misc/how-to-make-chocolate-chip-cookies.html

30 September 2009 sheet. Leave about 2 inches between cookies - they'll spread out when they bake. Step 4: Bake Bake your cookies about 8-10 minutes, until they're golden brown, but still soft in the centers. Let them cool on the pan for a minute, and then move them to a...

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

This file contains HTML or script code that may be erroneously interpreted by a web browserhttps://joellipman.com/articles/web-development/html/this-file-contains-html-or-script-code-that-may-be-erroneously-interpreted-by-a-web-browser.html

08 October 2009 uploaded. You will be restricted in how big the SWF files are by your server. We changed ours to 20Mb to accommodate for 5 minute SWF videos... If the screen just goes blank when you've uploaded a file, then you'll need to debug. Put the following code...

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

Checklist for the local computer repairshttps://joellipman.com/hardware/checklist-for-the-local-computer-repairs.html

28 April 2011 I was able to “work my magic” and save their business/thesis/whatever.″ Rates: Charge nominal fee £20 /hour I bill in 20 minute increments If I have to visit, I add 30 After hours, holidays and emergencies, added 20/hour Add 20 for restore disk...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

AutoHotkey Format Date and Format Secondshttps://joellipman.com/articles/automation/autohotkey/autohotkey-format-date-and-format-seconds.html

20 September 2011 01:00:00 The next function usually accompanies the above one. It will basically convert seconds into days, hours, minutes, etc.: FormatSeconds(val) { IfInString, val, - { Month:=SubStr(val, 8, 3) Month:=Month * 1...

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

Cheat Sheet for mySQL vs t-SQLhttps://joellipman.com/articles/database/cheat-sheet-for-mysql-vs-t-sql.html

31 January 2013 CONVERT(varchar, getdate(), 103) Time to Seconds TIME_TO_SEC(now()) (DATEPART(hour, getdate()) * 3600) + (DATEPART(minute, getdate()) * 60) + (DATEPART(second, getdate())) Seconds to Time SEC_TO_TIME( seconds ) CONVERT(varchar, DATEADD(ms, seconds *...

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

Client Services: Website Development Agreementhttps://joellipman.com/static-items/client-services-website-development-agreement.html

15 November 2013 or route to take. My pricing structure: Easy, my base rate is £20/hour. I use my own timesheet system, so if you have a 5 minute job, this will only be added to subsequent tasks until these add up to 1 hour. Housing the production and 2 development...

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

SSRS: Performance Improvements: SELECT TOPhttps://joellipman.com/articles/microsoft/ssrs/ssrs-performance-improvements-select-top.html

07 March 2014 off time from 0.4 seconds; no, we're more interested in the fact that 0.4 Microsoft seconds seems to translate to about 10 minutes in the real world. Where do the extra 9 minutes come from? Not the SQL as this runs in 00:00 seconds in SQL Server...

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

Zoho CRM: Schedule a Call using Delugehttps://joellipman.com/articles/crm/zoho/zoho-crm-schedule-a-call-with-deluge.html

18 November 2021 with a reminder in Zoho CRM using Zoho Deluge. Why? Because I find a need to document anything that takes longer than 30 minutes to figure out so I don't spend so long the next time I have to do it. The use-case scenario here is that when an appointment...

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

Zoho Deluge - Get User Timezone, Country and Locationhttps://joellipman.com/articles/crm/zoho/zoho-deluge-get-user-timezone-country-and-location.html

03 June 2019 Kingdom", "stateProv": "England", "city": "Birmingham (Edgbaston)" } A more comprehensive alternative [Limit 150 per minute | not for commercial use]: v_Url = "http://ip-api.com/json/"+ zoho.ipaddress; v_Response = getUrl( v_Url ); // usage: v_TimeZone...

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