Search - Joel Lipman .Com

1. Zoho CRM: Permission Denied for Quote Conversion Mapping: / Zoho /; What? A really quick article for anyone experiencing the same issue: As a super admin in CRM, I am denied permission to access the Quote Conversion Mapping page... Why? I wanted to map a billing ...; Created on 02 September 2021
2. T-SQL Conversion failed when converting the varchar to data type int: / Transact-SQL /; What? A very quick note in case I forget this one. If you are trying to join two tables and receiving the error "Conversion failed when converting the varchar value 'B110' to data type int" then read ...; Created on 14 May 2013
3. Transact-SQL Date Format Conversions: / Transact-SQL /; Source: http://www.kodyaz.com/articles/sql-format-date-format-datetime-t-sql-convert-function.aspx; Created on 19 November 2010
4. Can't play music after Firmware Update Version 3.: / IT Support /; Well we're all happy that the iPlayer from the BBC has come to PS3 in Europe but I'm less impressed about the multi-audio output. My setup is that the sound goes from the Playstation to the Sound System ...; Created on 21 September 2009
5. Zoho Deluge: Generate List of TimeZones: / Zoho /; ... HTML tags: l_TimeZones = List(); for each v_TimeZoneOption in l_TimeZoneOptions { v_TimeZone = v_TimeZoneOption.replaceAll("",""); // replace any commas in the value (for list conversion later ...; Created on 19 October 2021
6. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... the client wants: iPhone res). I then found that Shopify does accept a Base64Encoded version of the image and the below is how I achieved this. How? First-off, let me list the various formats that ...; Created on 17 October 2021
7. Zoho Creator / eBay: Get all Active Products: / Zoho /; ... = thisapp.API.fn_eBayConnect_AccessToken(); v_TradingAPIVersion = r_Api.API_Version; v_Endpoint = "https://api.ebay.com/ws/api.dll"; // // build header m_Headers = Map(); m_Headers.put("X-EBAY-API-SITEID",3); m_Headers.put("X-EBAY-API-COMPATIBILITY-LEVEL",v_TradingAPIVersion); v_ApiCall ...; Created on 13 October 2021
8. Zoho Creator / Shopify: Get all Active Products: / Zoho /; ... your shopify details v_ClientID = ""; v_ClientSecret = ""; v_ShopID = "example.myshopify.com"; v_ShopifyURL = "https://" + v_ClientID + ":" + v_ClientSecret + "@" + v_ShopID; v_ShopifyApiVersion ...; Created on 12 October 2021
9. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; ... quick to do and much easier than first thought. The article below documents how to create your first widget in a MacOS environment. I aim to create a WindowsPC version of this document at some point ...; Created on 24 October 2020
10. Zoho Creator Page: Toggle On/Off Switch: Hide/Display a Div: / Zoho /; ... own version of Bootstrap and jQuery. This is the first example I have where you would want dynamic content in a Zoho Creator page without the use of JavaScript or 'Widgets JS'. How? Here are some ...; Created on 22 October 2020
11. Zoho Deluge: Get Image Uploaded in Creator Form: / Zoho /; ... accessible version that you want. Now you can use that value in your HTML. Method #2: Using Deluge Assuming that I have a form called "MyImages" and an image upload field that has the field link ...; Created on 14 July 2020
12. AutoHotkey: App GUI Listview to Rename Files: / AutoHotkey /; ... name exists." Version := "1.1" Width := 600 Height := 600 BgColor := "EEEEEE" FgColor := "34495E" Options := "+Caption +Border +OwnDialogs" DefltDir:= A_ScriptDir ; -------------------------------------------------------------------------------------- ; ...; Created on 08 July 2020
13. JComments errors in PHP 7: plgContentJComments and JCommentsACL: / Joomla /; What? During a site upgrade, the commenting extension for Joomla called JComments would return errors when using PHP version 7. This is a quick article to document what needed doing to fix the errors. ...; Created on 13 March 2020
14. Autohotkey - Chrome Profiles in Alphabetical Order: / AutoHotkey /; ... Chrome profiles available from your login." Version := "1.0" Width := 400 Height := 800 BgColor := "FFFFFF" MarginX := 2 MarginY := 2 Options := "+Caption +Border +OwnDialogs" TempDir := "C:\Windows\Temp" ; ...; Created on 07 January 2020
15. AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktops: / AutoHotkey /; ... another screen of app icons. The same can be done to the desktop versions with open applications instead of just their icons. Why? MS Windows 10 has made a major step but when you close down your ...; Created on 18 July 2019
16. Zoho Deluge - Get distance between two coordinates: / Zoho /; ... Version 2019 string fn_getMilesBetweenCoords(float p_Lat1, float p_Lng1, float p_Lat2, float p_Lng2) { v_MathPi = 3.1415926535897932384626433832795028841971693993751; if ((p_Lat1 == p_Lat2) ...; Created on 11 June 2019
17. CSS Add Text to Breadcrumb Link with a Transition: / Cascading Stylesheets /; ... See my JsFiddle jsfiddle.net/Jlipman/4kj96rL0/1 Submitted by Ike This version submitted as an update is a little smoother as it adds a font-size transition: ul li{ display: inline-block; ...; Created on 18 May 2019
18. Zoho CRM: APIv2 using PHP & cURL: / Zoho /; ... of code below is using the functions to read data from Zoho CRM and to write data back to the system. Why? I've rewritten this code a few times and want to store the finalized version (following ...; Created on 30 January 2019
19. Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library): / Google /; ... two requests (albeit in one function) especially with imposed limit requests. I can halve this so let's upgrade! Method #2: Mulitipart single request This is my recommended version. In this function, ...; Created on 29 October 2018
20. MySQL Transactions in PHP: / MySQL /; ... requires PHP 5.6 and above. For lower versions you can issue the MySQL commands directly like: mysqli->query("START TRANSACTION") mysqli->query("COMMIT") mysqli->query("ROLLBACK") Important note: ...; Created on 14 December 2016