Search - Joel Lipman .Com

21. Zoho Deluge - Get Refresh/Access Token API v2: / Zoho /; ... = "aaaabbbbccccddddeeeeffff111122223333444455"; v_RedirectUri = "https://www.zoho.com/books"; // // enter the code received in the previous step v_Code = "1000.00001111222233334444555566667777888899990000aaaabbbbccccddddeeeef"; v_EndPoint ...; Created on 17 July 2019
22. 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
23. Batch Process to rename multiple files using Windows DOS: / MS-DOS /; ... What I have Image00001 (Copy).jpg Image00002 (Copy).jpg -- What I want Image00001.jpg Image00002.jpg How? Before I continue, the undo may work in MS Windows (Control key + Z) but don't count ...; Created on 09 August 2014
24. SSIS Multiple Lookups in one: / SQL Server Integration Services /; ... ----------------------- ----------------------- ----------------------- ------------------------------- ------------------------------- ------------------------------- -------------------------- 0000000001 ...; Created on 05 August 2014
25. SSIS: How to loop through multiple flat files as data sources: / SQL Server Integration Services /; ... its extension (eg. "C:\Temp\SourceFiles\File00001.txt" - although I used a network share without any issues) Add a Connection Manager Right-click in "Connection Managers" Select "New Flat File Connection..." ...; Created on 13 June 2014
26. No rows returned in Oracle causes SP to fail: / Oracle PL/SQL /; ... still an error it would seem. -- Error I was getting ORA-20001: 1234567:$:ORA-01403: no data found ORA-06512: at "BASETABLEOWNER.MY_STUPID_PROCEDURE", line 56 ORA-01403: no data found ORA-06512: ...; Created on 24 January 2012
27. Returning Oracle Stored Procedure Resultset in SSRS: / SQL Server Reporting Services /; ... -- ending that second begin I had after my variable declaration END; EXCEPTION WHEN OTHERS THEN RAISE_APPLICATION_ERROR (-20001, p_STUDENT_ADNAME || ':$:' || SQLERRM, ...; Created on 19 January 2012
28. Basic Oracle Function Structure: / Oracle PL/SQL /; ... open c1; fetch c1 into student_no; if c1%notfound then student_no := 0; end if; close c1; RETURN student_no; EXCEPTION WHEN OTHERS THEN raise_application_error(-20001,'An ...; Created on 15 January 2012
29. Win32 Constants: / AutoHotkey /; ... = $0001 Const WM_DESTROY = $0002 Const WM_MOVE = $0003 Const WM_SIZE = $0005 Const WM_ACTIVATE = $0006 Const WM_SETFOCUS ...; Created on 05 July 2011
30. Counting the occurence of a word within a string: Benchmark: / Personal Home Page /; ... took : 0.25045800209045 Seconds Count By Array Functions took : 1.1077101230621 Seconds Count By preg_split+Count took : 0.30741000175476 Seconds Count By substr_count took : 0.21060705184937 ...; Created on 06 September 2009
31. Form Builder: Created on 30 November -0001