Search - Joel Lipman .Com

21. 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
22. Zoho Deluge - Get Refresh/Access Token API v2: / Zoho /; What? A sorta quick article to note how I can generate refresh tokens and access tokens using Zoho Deluge code (so within Zoho Creator, CRM or Books) without XML calls. Why? I find myself using ...; Created on 17 July 2019
23. 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
24. AutoHotkey: Check Windows Folder Sizes: / AutoHotkey /; ... section of this website but I don't expect anyone to trust an executable EXE so here's the code of what it's doing which you can copy and paste to an AutoHotkey script: #NoEnv ; Recommended for performance ...; Created on 28 January 2019
25. Zoho Deluge - MD5 function: / Zoho /; What? So this is NOT an article on how to create a MD5 function for an ETag in Zoho Deluge as I expected it would be. At time of print, the Zoho documentation (and Google search results) make no mention ...; Created on 19 November 2018
26. Google Authentication - OAuth 2.0 using PHP/cURL: / Google /; ... being this script. Complete the global variables at the beginning of the code specific to your app and the rest should work... // specific to this app $CLIENT_ID = ''; // expecting *.apps.googleusercontent.com $CLIENT_SECRET ...; Created on 31 October 2018
27. MySQL Transactions in PHP: / MySQL /; ... if one of the queries fails? To mitigate the chances of misplacing our millions due to some possible error we must ensure that both queries are executed with the expected result before committing any ...; Created on 14 December 2016
28. Convert XML UTF-16 to JSON UTF-8 with PHP cURL: / Personal Home Page /; Previously titled Fix PHP cURL: parser error: Document labelled UTF-16 but has UTF-8 content What? This is an article with notes for me on how to convert some received XML encoded in UTF-16 to ...; Created on 28 March 2015
29. Submit form as a server and not the client with cURL: / API Miscellaneous /; What? A quick article on how to create a middleware script which accepts the values from a submitted HTML form and sends it to a server on another domain for processing. This applies to Linux Apache ...; Created on 20 February 2015
30. Quadcopter App with Flight Restrictions (JQA): / Product Documentation /; ... next version of this app is expected to hold a lot more. Hangar Tip: Both the free and paid version of this app are being developed to write to a mounted external SD card so they can share data ...; Created on 24 October 2014
31. SITS: Export field code and name: / Extensible Markup Language /; ... code and the lookup value in our XML to our Staging environment. Why? Let's take the country of birth of a person as an example as it is expected to be a long list and where just using the parameter ...; Created on 12 August 2014
32. Collin Consulting Ltd: / Portfolio /; Joe did a really superb job for me on this. My website crashed and I had no idea how to fix it. My hosting service were no help at all. Worse, I hadn't backed up my website for 18 months so even if Joe ...; Created on 29 June 2014
33. Generate a Timesheet in MySQL: / MySQL /; ... so do not expect it to reconcile with the requirement example. Note that we have two events on the Thursday. A few things we have to deal with still: We have lost the rows with days that have no ...; Created on 05 December 2013
34. Client Services: Website Development Agreement: / Static Items /; ... can step in when necessary but they will not necessarily match my skillset. My associates only get involved when something goes unexpectedly wrong and I do not have the extra time to allocate. They will ...; Created on 15 November 2013
35. T-SQL concatenate an incremental row number: / Transact-SQL /; ... "Joel Lipman" has a degree in Computer Science BSc and some qualification in being Superman. Specification The output expected by the customer is the following: EMP -------------------------------------------------- EmpNumber ...; Created on 24 May 2013
36. T-SQL Conversion failed when converting the varchar to data type int: / Transact-SQL /; ... values are expected to be a string. So with this in mind: SELECT r1.MapIn ( SELECT (COUNT(e2.EmpType)-1) AS MyCount ...; Created on 14 May 2013
37. Access MySQL databases using Oracle SQL Developer: / MySQL /; What? So this is a quick article on how to install the mySQL add-on for Oracle SQL Developer v3.0.04. Why? I've used various mySQL administration tools to manage mySQL databases over the years, ...; Created on 01 February 2013
38. Connect to Joomla database in standalone script: / Joomla /; ... the data later on. Further Post-Joomla 2.5 aides Validating a login was MD5(password+salt) but is expected to be (not tested) bool correctPass = CryptSharp.PhpassCrypter.CheckPassword(passwordPlain, ...; Created on 17 August 2012
39. Returning Oracle Stored Procedure Resultset in SSRS: / SQL Server Reporting Services /; ... the second query which is the one that will return my columns. Two output fields are expected to be returned: "p_STUDENT_DETAILS" and "p_STUDENT_REF". 2. Add a datasource Nothing different to ...; Created on 19 January 2012
40. SSRS Zero Padding: / SQL Server Reporting Services /; ... zeros -- "00000" because we don't expect strings to exceed 5 characters. The Oracle Error Value Returning just the 5 digits of the oracle error code without the minus/hyphen in front. =IIF( Fields!ERROR_CODE.Value="SUCCESS", ...; Created on 10 November 2011