Zoho Deluge: Determine if Daylight Savings are in effecthttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-determine-if-daylight-savings-are-in-effect.html

03 July 2023 to manage this data. I can't do this for every client, so here's a quick snippet to just check if Daylight Savings are in effect for the United Kingdom. How? Based on the fact that the United Kingdom is on the Prime Meridian and when no daylight savings...

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

Add Image Mouseover effect in AutoHotkey GUIhttps://www.joellipman.com/articles/automation/autohotkey/add-image-mouseover-effect-in-autohotkey-gui.html

25 January 2010 an image over it. The code above is only really a solution to if you have one image that you are applying this mouseover effect to. With a bit more time, you could tidy up the code to do multiple images. Note: I've updated the above code so that even if...

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

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

17 November 2021 = Collection(); c_Saturday = Collection(); // // loop through Monday subform for each r_Row in input.Mondays { if(r_Row.In_Effect) { // get Monday entries/rows v_EventType = r_Row.Event_Type; v_EventStart = r_Row.Start_Time; v_EventEnd = r_Row.End_Time;...

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

Joes Quicklist Weblinks (JQW)https://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw.html?catid=40

03 July 2011 file). Save it to the images folder which keeps all your other thumbnails for this module. No Semi-Transparency Effect? Not obvious but to switch this off, the parameter "Semi-Transparent Effect" has to equal 1. If you put a fraction of 1, eg. 0.5, this...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Zoho Creator/Deluge: Calculating with Timezone Offsethttps://www.joellipman.com/articles/crm/zoho/zoho-creator-deluge-calculating-with-timezone-offset.html

07 December 2021 with the timezone names, their offset and their DST offset as well as a boolean to say whether Daylight Savings Time is in effect for this timezone or not. So let's pretend we have a creator form wth the following fields: TZ Database Name (single-line)...

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

Windows 7 Aero Featureshttps://www.joellipman.com/articles/microsoft/windows-os/windows-7-aero-features.html

27 April 2010 aware that these existed in Windows Vista (and originally from Linux variants). Sometimes you may only have partial Aero effects. This can be because Windows may not think your machine is powerful enough to run these effects without affecting...

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

Data Randomization Function in Oracle PL/SQLhttps://www.joellipman.com/articles/database/pl-sql/data-randomization-function-in-oracle-plsql.html

22 August 2012 ( p_original_value IN VARCHAR2, p_original_datatype IN VARCHAR2, p_original_range_1 IN VARCHAR2 DEFAULT NULL, -- no effect on strings p_original_range_2 IN VARCHAR2 DEFAULT NULL -- no effect on strings ) RETURN VARCHAR2 IS v_char_at NUMBER := 0; --...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

GoDaddy Apache cPanel: Install SSL Certificatehttps://www.joellipman.com/articles/linux/cpanel/godaddy-apache-cpanel-install-ssl-certificate.html

07 April 2022 on "Ok"). Initially I got a support agent from GoDaddy to do this who said it would take about 6 hours to 2 days to take effect. Not sure what was supposed to happen but 2 days later it still wasn't working. I followed the process above and it took...

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

Joel's Reference to MidJourney v4 Promptshttps://www.joellipman.com/graphic-design/joel-s-guide-to-midjourney-prompts.html

11 February 2023 simply append 2 hyphens/dashes and the name of your custom parameter, for example: /imagine a beautiful face --portrait Effects So I can now build a prompt combining any of the following in a table (this is not an exhaustive / limited list). Do note...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *

The Sandpithttps://www.joellipman.com/graphic-design/the-sandpit.html

26 September 2010 I saw this on BBC News Click and was really impressed. It's an effect called "time-lapse tilt shift photography" where everything is made to look smaller than it actually is. As an update Mar 2011, I just watched Gulliver's Travels (2010) and it looks...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *

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

14 February 2019 Data Protection Regulation (GDPR) On May 25, 2018, the European Union's General Data Protection Regulation (GDPR) went into effect across all European Union markets. We believe this presents a new opportunity for marketers to strengthen their brand...

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

UTF8 Unicode PHP MySQL for International Charactershttps://www.joellipman.com/articles/web-development/php/utf8-unicode-php-mysql-for-international-characters.html

22 October 2010 caracters as intended with UTF8. I tried enough extensions and forum solutions, and although these changes would have an effect on the module (such as take away accents and convert to ASCII), they weren't what we were looking for. The quick solution was...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Connection Strings for SQL Serverhttps://www.joellipman.com/articles/microsoft/sql-server/connection-strings-for-sql-server.html

05 January 2011 This option is available from Connector/NET version 5.0.3. In earlier versions, this option has no effect. Using encryption, alternative Some reported problems with the above one. Try replacing the key "Encryption" with "Encrypt" instead....

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

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

23 March 2011 did earlier: Preview I have since made the vertical lines white and the top borders a lighter shade to make a sort of bevel effect.

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

CSS keeping the footer at the bottomhttps://www.joellipman.com/articles/web-development/css/css-keeping-the-footer-at-the-bottom.html

25 April 2011 clears both (even though i had clear:both on the css for my #right div layer). For some reason, it has a more forceful effect in its own separate layer. In a joomla CMS template though, I wanted the "left" div to take over the whole page if there were...

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

Licence GNU/GPLhttps://www.joellipman.com/static-items/licence-gnugpl.html

03 April 2009 computers, but in those that do, we wish to avoid the special danger that patents applied to a free program could make it effectively proprietary. To prevent this, the GPL assures that patents cannot be used to render the program non-free. The precise...

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

Joes Syntax Styler (JSS)https://www.joellipman.com/component/content/article/joes-syntax-styler-jss.html?catid=40

06 April 2013 overall look. This is still in development! Currently this plugin is mostly hard-coded and most of the parameters have no effect. It was initially built for someone as a quick syntax highlighter that recognizes SQL; but I am working on getting it to...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

DJI Phantom FC40 Paint-Job and AerialFreaks Cyclops FC40 Gimbal Upgradehttps://www.joellipman.com/articles/_other-misc/quadcopters/dji-phantom-fc40-paint-job-and-aerialfreaks-cyclops-fc40-gimbal-upgrade.html

04 September 2014 due to the new propellers I was trying (9" nylons) which I replaced with the stock propellers (8" plastic) and the jello effect went away. I have now equipped it with 9" carbon fibre but notice some jello instances so will spend time balancing the...

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

Joes Google Map (JGM) Downloadshttps://www.joellipman.com/component/content/article/joes-google-map-jgm-downloads.html?catid=92

07 September 2015 Longitude - Added parameters: Marker 1: HTML to display, Replace Marker Image - Added parameters: Control Options not in effect - Added parameters: Style for Google Maps API v3 - ALL - Added parameters: Style for Google Maps API v3 - road.arterial -...

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

Zoho Templates - Font size is inexplicably tinyhttps://www.joellipman.com/articles/crm/zoho/zoho-templates-font-size-is-inexplicably-tiny.html

22 February 2019 I wrap the code in a DIV with ID = container and have an image which covers them both... Which is an unintended but desired effect. Class .page: I actually like using this class because it's pretty descriptive. Unfortunately setting the width/height in...

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