Assuming string is required, the following 148 results were found.
-
curl_setopt($ch2, CURLOPT_POSTFIELDS, json_encode($post_fields)); // return response as a string curl_setopt($ch2, CURLOPT_RETURNTRANSFER, true); // set authorization header curl_setopt($ch2, CURLOPT_HTTPHEADER, array('Content-Type: application/json',...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
== RESULT_LOAD_IMAGE && resultCode == RESULT_OK && null != data && TAKE_OR_PICK == 2) { Uri selectedImage = data.getData(); String[] filePathColumn = { MediaStore.Images.Media.DATA }; Cursor cursor =...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
is not null and data column is not blank. Derived Column Task: Format keycolumn as per your requirements and use substring on trimmed DataColumn to retrieve each data column. Additional The TRIM in SSIS does not appear to get rid of new line and...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
Aviable". How? Mine's a bit of a copout as it is a two-step process. I wanted a query that searched every column containing strings in the database and we are somewhat limited in Sql Server 2008 R2 by 4000 characters in a variable (so I couldn't store...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
@TableDeclaration nvarchar(4000); DECLARE @SqlToExecute nvarchar(4000); -- Set variable default values SET @TableName = SUBSTRING(@SchemaTableName, CHARINDEX('.', @SchemaTableName)+1, LEN(@SchemaTableName)); SET @SqlToExecute = ''; -- Declare temporary...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
the PHP $p_Name here is the title of your article or product that will be changed into a string of only letters, numbers and underscores. Note that the PHP doesn't need a database connection here: function getUrlAlias($p_Name){ // lowercase and trim...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
environment, the application would only output blank values using single tags so we had to find a place to introduce it. On strings this has little worth, but on dates which could be NULL, this was necessary (unless we interpreted dates as strings which...
- Type: Article
- Author: Joel Lipman
- Category: XML Stylesheet Language Transformations
- Language: *
-
} ]; What I want again: Read a CSV file already uploaded with JavaScript Populate a JS array with each row Account for strings containing double-quotes (and commas to ignore) Sort the resulting object array How? The function with comments: - Uses...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
the code you previously pasted with the below (note the file format for Excel 97-2003): Sub Splitbook() Dim xPath As String xPath = Application.ActiveWorkbook.Path Application.ScreenUpdating = False Application.DisplayAlerts = False For Each xWs In...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
on it's side) /prefer option set This will create custom parameters/argument suffixes you can add which represent a whole string of words that you may use often but don't feel like typing every time. (follow these to the letter or it will simply reset...
- Type: Article
- Author: Joel Lipman
- Category: Graphic Design
- Language: *
-
later to common things I need to do in Zoho Deluge. How? So going through the forums you may find the following example: string padWithLeadingZeros(int finalStringLength, int startingNumber) { return leftpad(toString(input.startingNumber),...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
The report being subscribed to is hidden in tile view. Cases where this would NOT work Reports where the connection string to the data source is held in the parameters (though, with more time, we could have tried changing the "connection string"...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
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 -- What I want John S. Fred B. How? So different ways, the first...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
on this new key and add a key to this one called "command" Under the "command" key, double-click the "(Default)" string in the right-pane and type the following c:\windows\system32\cmd.exe /c "ECHO > c:\temp.txt | FC /N /LB 1000 %L c:\temp.txt >...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: *
-
This is how I was doing it previously. // get the date (eg. 1, 2, 3,... 29, 30, 31) This_Day_Date = My_Date_Field.toString("d"); // determine English ordinal English_Ordinal = "th "; if(This_Day_Date == "1" || This_Day_Date == "21" || This_Day_Date ==...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
function in Creator: = zoho.map.distanceBetween(, , ); // where unit can be "MILE", "KILOMETRE" or "NAUTICAL" Version 2019 string fn_getMilesBetweenCoords(float p_Lat1, float p_Lng1, float p_Lat2, float p_Lng2) { v_MathPi =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
CRM Users (ActiveUsers) from Creator or other Zoho App Note the use of .toMap() required for other apps to read this JSON string response: l_Users= List(); m_UserType = Map(); m_UserType.put("type","ActiveUsers"); r_Response =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
// // invokeurl r_Coql = invokeurl [ url :"https://www.zohoapis.eu/crm/v2/coql" type :POST parameters:m_Params.toString() connection:"crm_api_v2" ]; // // retrieve results if(!isNull(r_Coql.get("info"))) { v_MatchedCount =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
A very quick article on converting a Map string into a HTML table without using a for each loop. Why? I have quite a big response from our CRM that hits a statement execution limit if I use a for loop. I have a map with 3 columns: first_name, last_name,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
How? Let's assume that my custom fields have as identifiers UDF_CHAR8 (which is a Zoho ID) and UDF_CHAR7 (which is a text/string name field). Note that in the below snippet, I've put m_Params into separate lines for display purposes but actually it...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Projects
- Language: *