Assuming results is required, the following 70 results were found.
-
AND ref.[RefSystem] = '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 + ', ' + rm.[Zone]...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
ECHO Done. Deployment Method #?: As a setup.exe Package the visual studio project by adding a "setup wizard" project. This results in a setup.exe and msi file which can be installed on Windows Servers run by accounts which do not have access or which do...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
character list are returned as a match. For example, to exclude the characters 'a', 'b', and 'c' from your search results, use the following regular expression: [^abc] This expression matches characters 'd' and 'g' in the following strings: abcdef ghi...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
source directory. -- /XO excludes existing files older than the copy in the source directory. There's a nice output of the results if you run this in a command prompt. The Manual:...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: en-GB
-
it as ".htaccess" (or modify the existing one) Add the code as per below. Save the change. Different ways for different results, let's pretend I'm redirecting from myolddomain.com to mynewdomain.com: RewriteEngine On RewriteRule ^(.*)$...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
Lipman M 726 5826 000 39 0000000002 0987654 MAJ Big Bird M 771 771 771 15 The one lookup task: Changing the lookup to "use results of an SQL query": Which would code with the joined tables as follows (note that in our case we needed the lookups on the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
for moving to the previous field. IME_ACTION_SEARCH // the action key performs a "search" operation, taking the user to the results of searching for the text they have typed (in whatever context is appropriate). IME_ACTION_SEND // the action key...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
are: categories contacts newsfeeds weblinks To determine yours, do a standard search on your website and check the search results page. There should be several additional options to your search that will be displayed under the "Search Only:" heading and...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
between double-quotes var column_values = row_content.split(/,(?=(?:(?:[^"]*"){2})*[^"]*$)/); // prevents JS error where results unmatched column_values = column_values || []; // ignore row if first item is blank (allows for blank excel lines)...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
'&company='.$company_id_1. '&brand='.$company_id_1_brand_id ); // remove XML declaration from results $output = substr($output, stripos($output, '?>') + 2 ); // remove leading spaces, carriage returns $output = trim($output); // process if type...
- Type: Article
- Author: Joel Lipman
- Category: API Miscellaneous
- Language: *
-
it thinks "riviere" is different to "rivière". We need to ensure that a search for any of these kind of words will return results of similarly typed/sounding words. How? Here's just a splurge of SQL but I use this often enough: UPDATE `myTable` t SET...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
Where: SumProduct( is a function to multiply two ranges together (must be the same size) and return the total of these results. -- is a double hyphen/dash which converts a boolean true to 1 and boolean false to 0. IsNumber( is a function returning a...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
for each. How? So depending on the number of levels, the count will be with a series if then else statements. See the results/yield section to determine which best fits your scenario: Counting total products: // // count total products for availability...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
:"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 = ifnull(r_Coql.get("info").get("count"),0); }...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
+ r_CreatorFile.File_Download; } } else { v_CrmEndpointUrl = v_ZohoApisDC + "/crm/v2/Results/"+v_CrmResultID+"/Attachments/" + v_ThisFileAttachmentID; // // using a Zoho Oauth connection with scope (ZohoCRM.modules.ALL) r_DownloadFile = invokeurl [ url...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
how an idiot like myself can misread the documentation. This particular article shows you how to customize the search results or response from using zoho.creator.getRecordById(). Why? My use case scenario is that I was trying to build a related list in...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
the $converted system field is different. Checking the Zoho documentation for an example showing how you can get all results irrespective of whether they are converted or approved: response = zoho.crm.searchRecords("Quotes",...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
are different. Having spoken to Zoho and raised with the Zoho Deluge team... Well, they realised they would get the same results, and then suggested looping through all records and creating a distinct list variable... But what if there are 20000+...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
m_Sku_IDs; info m_Sku_IDs.size(); } Yields something like: { "TEST001": 1234567890123, "TEST002": 2345678901234 } 2 Which results in a map that I can give a Product SKU to and it will return the Shopify Product ID to me. You may have noted also the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
// // fetch all payments against this customer in order of payment reference (oldest to most recent) r_SearchResults = zoho.books.getRecords("customerpayments",v_BooksOrgID,m_SearchCriteria,"zbooks"); if(!isnull(r_SearchResults.get("customerpayments")))...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF