Search - Joel Lipman .Com

21. Google Drive API v3 - OAuth2 using Service Account in PHP/JWT: / Google /; ... be a full JWT: base64 encoded, URL-safe, three part string delimited by a period/dot: // Generate assertion/signature of JWT $api['jwt']['assertion'] = rtrim(strtr(base64_encode(json_encode($api['jwt']['header'])) ...; Created on 02 February 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. Accessing Apimo WebService API: / API Miscellaneous /; ... XML declaration from results $output = substr($output, stripos($output, '?>') + 2 ); // remove leading spaces, carriage returns $output = trim($output); // process if type specified was xml if($apimo_type=='xml'){ ...; Created on 29 March 2016
24. Joes Revolver Map (JRM) Downloads: / Downloads /; ... actually works... - Trimmed any spaces from posted data and html code. - Used revolvermaps.com selection of "width x height" values.- Date Uploaded: Fri, 30th Jul 2010 ...; Created on 07 September 2015
25. Convert XML UTF-16 to JSON UTF-8 with PHP cURL: / Personal Home Page /; ... the data for the POST foreach($fields as $key=>$value) rtrim($fields_string, '&'); // open connection $ch = curl_init(); // set the url, number of POST vars, POST data curl_setopt($ch,CURLOPT_URL, ...; Created on 28 March 2015
26. 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
27. T-SQL functions to convert Strings to Tables: / Transact-SQL /; ... VARCHAR(10) SET @StringInput = RTRIM(LTRIM(@StringInput)) WHILE LEN(@StringInput) > 0 BEGIN SET @StringValue = LEFT(@StringInput, ISNULL(NULLIF(CHARINDEX(' ...; Created on 20 August 2014
28. Convert to Proper Case in T-SQL: / Transact-SQL /; ... spaces SET @Ret = LTRIM(RTRIM(@Ret)); -- capitalize first character of data irrespective of previous rules SET @Ret = UPPER(SUBSTRING(@Ret,1,1)) + SUBSTRING(@Ret,2,LEN(@Ret)); ...; Created on 04 June 2014
29. Export Joomla Users script: / Joomla /; What? Somebody said I could pay to get an export list of my Joomla users. I said Joomla is a FREE OpenSource system, why? Why? I want to move a client's list of Joomla users to a new system which ...; Created on 28 February 2014
30. MS Excel: Convert a text to a number: / Excel /; ... paperclip, in other words, not worth the time or effort to try (didn't work anyway). The TRIM() function will not work for you either, nor with the VALUE() function.... The culprit was a suspicious ...; Created on 15 November 2013
31. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCase: / SQL Server Integration Services /; ... exceptionArray_that[i]); } } // trim to remove the trailing space ValueToConvert = ValueToConvert.Trim(); ...; Created on 04 October 2013
32. T-SQL Conversion failed when converting the varchar to data type int: / Transact-SQL /; ... = 'myPayrollSystem' Yes well obvious to some but then you google the above and you get half a million results. That's a lot of reading so here's the simple fix for my issue: Returning an error: LTRIM(RTRIM(rm.Name ...; Created on 14 May 2013
33. Improve Default Joomla Search: / Joomla /; ... + 1000 pts if in title x1 (eg. if word is twice then 2000pts) // + 60 pts if in introtext // + 40 pts if in fulltext $sql_keyword = strtolower(trim($db->Quote($db->escape($text, true), false))); $query->select(' (1000*((LENGTH(TRIM(a.title)) ...; Created on 07 May 2013
34. SSIS Skip Blank Rows in Flat File Source: / SQL Server Integration Services /; ... being inserted, simply extract the entire row as a column and trim it. I separate out the first column as my index/key field so I can check if this is a valid data row (the blank ones may return special ...; Created on 23 April 2013
35. SSIS Convert a string into a date: / SQL Server Integration Services /; ... (YYYYMMDD) (DT_DATE)(SUBSTRING(This_Date,6,2) + "/" + SUBSTRING(This_Date,9,2) + "/" + SUBSTRING(This_Date,1,4)) -- Assuming [This_Date]="21032012" (DDMMYYYY) (TRIM(This_Date)=="")? (DT_DBTIMESTAMP)"1901-01-01 ...; Created on 14 March 2013
36. DataScramble - Randomizing data rows: / Transact-SQL /; ... DECLARE @ColumnTypeIsDate int; DECLARE @IntOptions int; DECLARE @CharOptions varchar(max); -- Format given value (prevents CHAR datatype issue) SET @OrigVal = LTRIM(RTRIM(@OrigVal)); ...; Created on 07 December 2012
37. Stored Procedure to List Distinct Values and Counts: / Transact-SQL /; ... DISTINCT ' + LTRIM(@ColToProcess) + ' COLLATE ' + @p_UseCollation + ', ''' + LTRIM(@ColToProcess) + ''', ...; Created on 26 October 2012
38. Search a database for a string (MySQL, T-SQL): / Databases /; ... ,SQLStatement VARCHAR(MAX) ,Execstatus BIT ) DECLARE @sql VARCHAR(MAX) DECLARE @tmpTblname sysname IF LTRIM(RTRIM(@Tablenames)) IN ('' ,'%') BEGIN ...; Created on 08 October 2012
39. Data Randomization Function in Oracle PL/SQL: / Oracle PL/SQL /; ... ELSIF p_original_datatype='VARCHAR' THEN IF LENGTH(TRIM(TRANSLATE(p_original_value, 'abcdefghijklmnopqrstuvwxyz ', ' '))) IS NULL THEN -- Determined submitted ...; Created on 22 August 2012
40. Inline Labels in Form Fields using Javascript: / JavaScript /; ... is still black. Additional Note that instead of just saying if this value equals "Name:" I've added some code to trim the values. If the user types two spaces, then we want the field to understand ...; Created on 21 August 2012