Search - Joel Lipman .Com

21. Zoho Deluge: Duplicate/Clone a Record: / Zoho /; ... 2020-03-17 */ // get all field names for the Invoices module via API l_FieldApiNames = List(); r_Fields = invokeurl [ url :"https://www.zohoapis.eu/crm/v2/settings/fields?module=Invoices" type ...; Created on 17 March 2020
22. Zoho Deluge - Determine Quarter from Date with Fiscal Year: / Zoho /; ... = ; l_MonthNames = ; Here's the standard code you'd expect if your Fiscal year starts in January (Divide by 3 and round up): for each v_Month in l_Months { v_Quarter = (v_Month.toLong() / ...; Created on 31 January 2020
23. Autohotkey - Chrome Profiles in Alphabetical Order: / AutoHotkey /; ... FileRead, OutputContent, %PreferenceFile% NameStart := InStr(OutputContent, """name"":""")+8 NameEnd := InStr(OutputContent, """", false, NameStart+1) NameLength := NameEnd - NameStart ...; Created on 07 January 2020
24. Zoho CRM: APIv2 using PHP & cURL: / Zoho /; What? This is an article documenting how to access ZohoCRM with API v2 using PHP and cURL. The first few functions are to manage OAuth v2 and generate the refresh and access tokens. The second snippet ...; Created on 30 January 2019
25. Zoho Deluge - Get Full Day Name: / Zoho /; ... lists Day_Names = List:String(); Day_Abbreviations = List:String(); // get date field day abbreviation Day_Abbreviation = My_Date.toString("E"); // find in array and return same index from ...; Created on 08 November 2018
26. Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library): / Google /; ... function which uploads and names the file in a single request, and the third is a 'nice-to-have' upload to the specified folder. Method #1: two requests 1. Send the media file 2. Update the name ...; Created on 29 October 2018
27. Convert foreign characters to English alphabet: / MySQL /; ... working on has just gone international and started including the names of places in other countries. This is nice but its search engine doesn't work properly as it thinks "riviere" is different to "rivière". ...; Created on 13 June 2016
28. Foreign Characters create symbols in PHP and MySQL: / Personal Home Page /; ... the funny question marks in diamond symbols and how I solved it in my case. Why? My company has started using international country and region names which include foreign characters. When we ...; Created on 25 January 2016
29. TravelPort Universal API - Ping Request with PHP-cURL: / API Miscellaneous /; Applies to: TravelPort Universal API PHP 4 or 5 cURL What? An article on how to resolve errors and setup a standard ping request using the TravelPort Universal API. This is to be achieved using ...; Created on 27 April 2015
30. Excel: convert degrees minutes seconds to decimal: / Excel /; What? A quick article on how to get the value of 40°4′20″N 116°35′51″E into 40.079857, 116.603112. How? Let's pretend all the names are in column A, in Column B I have the coordinates that I want ...; Created on 06 November 2014
31. Quadcopter App with Flight Restrictions (JQA): / Product Documentation /; ... sensor level - Map: display gallery of screenshots (+offline mode) - Map: populate nearest cities for lat/lng to more accurate city names - Map: use map touch listeners - Map: timeout requests on idle - ...; Created on 24 October 2014
32. MySQL Updating a database table from another table: / MySQL /; What? A quick article on how to populate a database column from another table using a string comparison. Why? I have several database tables which replicate country names and I would rather they ...; Created on 22 October 2014
33. Add attribute xsl:nil=true on empty elements using XSLT: / XML Stylesheet Language Transformations /; ... things to do really: Add the xmlns:xsi namespace in the xsl:stylesheet tag so that "xsi:nil=true" is valid. Test for a string length of greater than 0 (not blank) and change the attribute of the element ...; Created on 18 August 2014
34. XML Schema Reference: / Extensible Markup Language /; ... Defines a group of elements to be used in complex type definitions import Adds multiple schemas with different target namespace to a document include Adds multiple schemas with the same target ...; Created on 13 August 2014
35. Include a carriage return in a column heading: / SQL Server /; Applies To: MS SQL Server 2008 R2 MS Windows 7 Enterprise (Client) MS Excel 2010 What? A really quick note on how to insert a carriage return or new line into the column name/alias (the header). ...; Created on 07 July 2014
36. Convert to Proper Case in T-SQL: / Transact-SQL /; ... will be applied to names and addresses as well as job titles and departments. Why? We wanted a T-SQL version despite having successfully built a custom script component for SSIS. How? You ...; Created on 04 June 2014
37. SSIS: Add Reference Microsoft.SqlServer.TxScript: / SQL Server Integration Services /; What? This article is so that I don't spend so long in googling what the TxScript referenced assembly is when creating an SSIS custom component. How? This is simply the "Script Component" under ...; Created on 03 June 2014
38. PHP: First name and Initial of Surname: / Personal Home Page /; What? A note for myself on some code to convert a string of two names into a string made up of the first name and then using the initial of the second name. -- What I have John Smith Fred.Bloggs -- ...; Created on 27 March 2014
39. T-SQL: Parse an XML value: / Transact-SQL /; ... FROM [dbo].[XML_EVENTS] -- to return unknown nodes from XML column - Event_XML SELECT Event_XML.query('//* ') FROM [dbo].[XML_EVENTS] Parent/Child Node Names -- to get name of parent ...; Created on 27 March 2014
40. SSRS: Performance Improvements: SELECT TOP: / SQL Server Reporting Services /; ... solutions dotted about the web but the biggest improvement was the "SELECT TOP 100" brain wave: -- DataSet1: SELECT TOP 100 Reference, Forenames, Surname, DOB FROM PersonsTable WHERE (Reference ...; Created on 07 March 2014