Assuming zero is required, the following 32 results were found.
-
Reminder I didn't want to do this at the database level, mainly because it meant modifying the SQL query. The zero padding would need to be applicable within an MDX query. The Situation We have a database using Oracle 10g, and a SQL Server Reporting...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
you use the regular expression: a+ This expression matches all of the following: a aa aaa The expression does not match: bbb Zero or One — Question Mark The question mark matches zero or one--and only one--occurrence of the preceding character or...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
of acceptable values fractionDigits Specifies the maximum number of decimal places allowed. Must be equal to or greater than zero length Specifies the exact number of characters or list items allowed. Must be equal to or greater than zero maxExclusive...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: en-GB
-
+) Specifier Description Values/Example Day %a weekday, abbreviated Mon %A weekday, full Monday %d day of the month (dd), zero padded 04 %e day of the month (dd) 4 %j day of year, zero padded 001-366 %u day of week starting with Monday (1), i.e. mtwtfss...
- Type: Article
- Author: Joel Lipman
- Category: Linux
- Language: *
-
WHERE re.RoomId=@GivenRoom AND re.SetId=@setId This seems to have problems because when there are no matching rows (so zero results), BIDS doesn't seem to know what to do with this. We could add a row with a SELECT UNION statement but I found this can...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
this "feature" but the gist is if you want to add tax, it has to be built up in the tax options, if you want this to be zero, you need to pass the option of tax as zero and remove all other options. Take the following code for example, this will add 20%...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
l_TaxOptions.add(m_TaxOption1); } else { m_TaxOption0 = Map(); m_TaxOption0.put("percentage",0); m_TaxOption0.put("name","Zero Tax"); m_TaxOption0.put("value",0); l_TaxOptions.add(m_TaxOption0); } m_LineItem.put("Line_Tax",l_TaxOptions);...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
info r_CreateItem.get("message"); Error(s) Encountered items with opening stock cannot be deleted, set the opening stock to zero: Guess who's going to have their opening stock set to zero, save the record, then delete it. Source(s) Stack Overflow -...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Inventory
- Language: *
-
m_CrmProduct.put("Unit_Price",m_XeroLineItem.get("UnitAmount")); // // map over tax (even if it's zero) v_XeroLineItemTaxAmount = ifnull(m_XeroLineItem.get("TaxAmount"),0).toDecimal(); m_CrmProduct.put("Taxable",true); v_CrmTaxRateString =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
alphanumeric value with a trailing underscore (eg. "abc12_") Check if you have more than one asset with a parent_id equal to zero: SELECT COUNT(*) FROM #__assets WHERE parent_id=0 -- where #_ is the Database Tables Prefix value There can be only one: If...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
// I don't have a report that takes over an hour to process but in theory this should accommodate it. Problem #1 If zero rows are returned from the search, then there is no REPORTSTARTTIME. There are two options here: Create another dataset (would have...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
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 strings: 3 days ago // where event is 3 days ago or just over but less than...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
this equation? You can tell me that "10" comes before "8" and it does but just to check, let me pad the 8 with the prefixing zero: Annoyingly "10" still comes before "08" so maybe I'm barking up the wrong tree. If I padded with one more zero so that...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
v_ProductID = l_ProductDetails.ID; } What Happens: In the example above, the count to see if "Myproduct1" exists counts as zero (0). It doesn't think the product exists because it is searching with case-sensitivity enabled. It tries to insert into the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
v_TotalDeptEmployees = l_DeptEmployees.size(); // ensure total is not zero as we need to divide by it (defaulting to 2 because if 1 then it's 100%, as 2 it's 50% might have it booked off) v_TotalDeptEmployees = if(v_TotalDeptEmployees 80 &&...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
Click on "Customize Tax Rates" For our clients in the UK, we tend to specify the tax rates as "Standard Tax" @ 20% and a "Zero Vat" @ 0% Click on "Save" and you've pretty much specified the tax rates that this CRM can use; but... do the next steps for...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
in l_SearchResults { if(!isnull(r_Result.get("id"))) { v_DealID = r_Result.get("id").toLong(); } } } // // if Deal ID is not zero, then it was found! if(v_DealID != 0) { r_DealDetails =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Sign
- Language: *
-
The client does not want their operations team adding/deleting rows and instead simply specifying quantity (defaulting to zero) alongside each serviceable item. How? So at time of print, this is the only way I know: add a note field to inject some CSS...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
for a payment atempt Date Modified: 2023-02-24 (Joel Lipman) - If custom field "Amount To Be Taken" is not greater than zero, then defaults to balance due of invoice. More Information: TEST PAYMENT SCENARIOS WITH PHYSICAL TEST CARD // Send in as payment...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
Prime Meridian and when no daylight savings are in effect, the hour difference to UTC (Coordinated Universal Time) should be zero, then for checking if daylight savings is in effect in the UK, we should be able to take Greenwich Mean Time and compare to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *