Search - Joel Lipman .Com

1. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attach: / Zoho /; ... syntax, add these to a list, and then submit as the subform name, like in the following example (note I have applied a regex to use US/UK numbering format with 2 decimals and thousandth separator, eg. ...; Created on 21 October 2021
2. ZohoCRM: Process all records of a module: / Zoho /; ... you have a few hundred records, or a few hundred thousand records, we sometimes want to write a function that will check each record and mark it so that the process doesn't repeat on records that have already ...; Created on 24 August 2021
3. Zoho CRM & Zoho Books: Custom Related Lists Deluge: / Zoho /; ... / v_ExchangeRate).toDecimal().round(2); // // format currency with commas (thousand separator) and 2 decimals v_QuoteTotalStr = v_QuoteTotal.toDecimal().round(2).toString().replaceAll("(?" ...; Created on 30 July 2021
4. SSIS Convert a string into a date: / SQL Server Integration Services /; ... ? (DT_NUMERIC,12,4)0 : (DT_NUMERIC,12,4)TRIM(ContributionValue) -- it's a number (DT_NUMERIC,12,4)TRIM(ContributionValue) -- a thousandth separator in the data (eg. 2,534.0000)? ISNULL(ContributionValue) ...; Created on 14 March 2013
5. The ReportServer Database: / Databases /; ... is it slower? Not necessarily. Like all measures in bytes, I would like a thousand separator, and lose the decimal ".00". I need the size of the report but the value has to be returned as part of the ...; Created on 08 August 2011
6. SSRS Use T-SQL Like with a Parameter: / SQL Server Reporting Services /; ... range. The problem is that there are a few thousand users and Microsoft's SQL Server Reporting Services interface isn't the most fun to scroll endlessly down. Advanced users can type the name really fast ...; Created on 04 April 2011
7. Database Error: Unable to connect to the database: Could not connect to MySQL: / MySQL /; ... my webhost, and the problem is the number of MYSQL database queries. It goes up to about 200,000 in the first few minutes of use and then after that every page load is a few hundred to few thousand queries ...; Created on 25 September 2009
8. Pricing Table: Created on 17 April 2015