Assuming string is required, the following 147 results were found.
-
some variables to use DECLARE @ColToProcess varchar(max), @SqlToExecute varchar(max), @myXml xml; -- Parse comma delimited string into a table SELECT @myXml = CONVERT(xml,'' + REPLACE(@p_SearchColumns,',','') + ''); DECLARE Cursor1 CURSOR FOR SELECT...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
@NewVal varchar(max); DECLARE @OrigLen int; DECLARE @CurrLen int; DECLARE @LoopCt int; DECLARE @Rand int; DECLARE @RandString varchar(max); -- for dates/times DECLARE @MinYear int; DECLARE @MaxYear int; DECLARE @RandYear int; DECLARE @RandMonth int;...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
we didn't use parentheses? Then it wouldn't be evaluated as an expression and perhaps Excel will be forced to treat it as a string: Another alternative to round brackets, square brackets! Additional: I have made this work with the parentheses but only...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
where you put your Data Sources, click on the button "New Data Source" Specify the details, especially the connection string (which the system account can use). Set "Connect Using" to "Credentials supplied by the user running the report". Browse to your...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
the Core Joomla code for ReCaptcha: 1. Open the file: /plugins/captcha/recaptcha/recaptcha.php 2. Find the following string in the OnDisplay function: return ' '; 3. and replace with: // Replace YOUR_KEY with your public key return ' window.onload =...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
WHILE (@i 0 BEGIN -- get the delimited word SET @CaseLen = CHARINDEX(',', @CaseExceptions, @i+1) - @i SET @CaseValue = SUBSTRING(@CaseExceptions, @i, @CaseLen) -- replace it in the original text SET @Ret = REPLACE(@Ret, ' '+@CaseValue+' ', '...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
below. Add a variable (preferably to the scope of the package) called "SourceExtractFile" and give it the data type "String". Set the Value to the full path and the first file including its extension (eg. "C:\Temp\SourceFiles\File00001.txt" - although I...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
// Create a criteria object to retrieve provider Criteria criteria = new Criteria(); // Get the name of the best provider String provider = locationManager.getBestProvider(criteria, true); // Get Current Location Location myLocation =...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
support). - Fixed bug: compilation failed for servers not supporting international characters. - Fixed bug: replaced string formatting foreach statements with legacy FOR statements. - Date Uploaded: Tue, 4th Jan 2011 1.4.1- Fixed compatibility with PHP...
- Type: Article
- Author: Joel Lipman
- Category: Downloads
- Language: *
-
to this app $CLIENT_ID = ''; // expecting *.apps.googleusercontent.com $CLIENT_SECRET = ''; // expecting alphanumeric string $STORE_PATH = ''; // expecting *.json - needs to be writeable by system account $SCOPES = array($GAPIS_AUTH . 'userinfo.email',...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
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
- Language: *
-
is a case-insensitive search with the first parameter being the text to search for (can be a range) and the second the string to search (in this case a single cell value). Sheet2!$A$1:$A$4 is the range of words to find from Sheet2. Note that there is a...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
Why? Here are some examples of what we want to achieve: 1 year 2 months 3 weeks 4 days 5 hours 6 minutes 7 seconds // full string 1 year 3 weeks 5 hours 7 seconds // where shown values are not zero Actually we just want the first two words of those...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
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
- 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
- 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
- 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
- Language: *
-
Category, I'm going to say Standalone Specify the Function parameters/Arguments EXACTLY as this: crmAPIRequest of data type string. IMPORTANT! It won't work if you don't include this parameter. For the code of the function this is what I did, you can...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Line:(442) How? It is written in the documentation albeit difficult to find: an integration field returns an ID as a string. If you want to assign it to an integration field, you have to convert it to a number with .toLong(). Say I have an integration...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Record Name"); } if(l_Errors.size() > 0) { alert "Please enter the following required fields:\n" + l_Errors.toString("\n"); } else { //... code to submit form/save to record here } Then save the data by adding the record or updating the existing record...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF