Search - Joel Lipman .Com

1. 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
2. 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
3. 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
4. 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
5. 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
6. 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
7. 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
8. 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
9. 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
10. 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
11. 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
12. 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
13. 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
14. 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
15. 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
16. Display Feeds to major Social Networks: / Web-Development /; ... tools but this may be for the write-back version). My Facebook Page Twitter Replace https://twitter.com/MyTwitterAccount ...; Created on 16 May 2016
17. Accessing Apimo WebService API: / API Miscellaneous /; ... ID $company_id_1_agency_id = ''; $company_id_1_brand_id = ''; // specify target url and version $apimo_url = 'https://api.apimo.com/api/call'; $apimo_version = 2; // specify data output $apimo_method ...; Created on 29 March 2016
18. Foreign Characters create symbols in PHP and MySQL: / Personal Home Page /; ... in this article. How? The fix is a PHP one and has to do with versions of PHP and MySQL. As quoted by the PHP htmlspecialchars: "As of PHP 5.4 they changed default encoding from "ISO-8859-1" to ...; Created on 25 January 2016
19. Protecting your Joomla Administrator Section: / Joomla /; What? This is a quick article to remind me how to move a Joomla administration section and to lock it down to a specific IP address. The below does not involve installing any third-party extensions ...; Created on 23 October 2015
20. Sort an associative array by values in Javascript: / JavaScript /; What? An article on how to quickly adapt an array code and sort by its values. Surprising how many examples are on the web and everyone saying you're doing it wrong... Which is true but quite unhelpful. ...; Created on 29 September 2015