Quadcopter App with Flight Restrictions (JQA)https://www.joellipman.com/component/content/article/quadcopter-app.html?catid=40

24 October 2014 (preferably "iso-3166-1 alpha-2") to the name if the location of the same name exists in multiple countries of the world. Zones (circles on map): Static Zones are created based on a listed airport, airfield, military, private or listed building. Dynamic...

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

Unix Date Format Specifiershttps://www.joellipman.com/articles/linux/unix-date-format-specifiers.html

05 July 2011 %X locale's time representation (%H:%M:%S) Date and Time %c locale's date and time Sat Nov 04 12:02:33 EST 1989 Time zone %z -zzzz RFC-822 style numeric timezone -0500 %Z time zone (e.g., EDT) nothing if no time zone is determinable EST

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

Zoho Creator: Set Up Custom Domain for Customer Portalhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-set-up-custom-domain-for-customer-portal.html

17 November 2020 is complete. Find the DNS Manager in your control panel, it might be called something like "Advanced DNS Editor", "Advanced Zone Editor" or "DNS Zone Editor": If the subdomain has a CNAME record, modify it as per the below (not the "Name" just the...

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

T-SQL Conversion failed when converting the varchar to data type inthttps://www.joellipman.com/articles/database/t-sql/t-sql-conversion-failed-when-converting-the-varchar-to-data-type-int.html

14 May 2013 results. That's a lot of reading so here's the simple fix for my issue: Returning an error: LTRIM(RTRIM(rm.Name + ', ' + rm.[Zone] + ', ' + rm.[Capacity] + ', ' + rm.[Type] + ', ' + rm.[DeptId])) AS RoomDetails // yields Conversion failed when...

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

Could not instantiate mail functionhttps://www.joellipman.com/articles/cms/joomla/could-not-instantiate-mail-function.html

09 May 2011 *not* be in the /etc/virtual/domainowners file. 4) The hostname must resolve. If not, add the required A records to the dns zone such that it does. 5) The directory /etc/virtual/hostname must exist.. (eg: /etc/virtual/server.domain.com). It must not...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• 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 This is an article to remind me how to calculate various times for an appointment booking system based on the timezones of each party. Why? The use-case scenario is that our Creator server uses the US datacenter but has it's server timezone set to...

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

Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng)https://www.joellipman.com/articles/crm/zoho/zoho-crm-deluge-get-timezone-based-on-geocoded-address-lat-lng.html

15 December 2021 address from a Lead record to geocode into latitude and longitude coordinates to feed a third-party API which returns a timezone. Why? Our use-case is that we have a field called "Customer's Time Zone" on the lead record in ZohoCRM. It should be...

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