Assuming numbers is required, the following 43 results were found.
-
So we have a customer that has some decimal fields on the products module that are calculated and will sometimes return numbers with more than 6 decimal places. As this is more than specified on the ZohoCRM field properties, as soon as the staff user...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
the ID in double-quotes in case I open it in MS Excel or another system that likes rounding 64-bit signed integers (long numbers): // // Generate a CSV of a Report in ZohoCreator l_CsvLines = List(); l_ApplicableProducts =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
validation challenge code. In the Verification token field, enter a unique 32–80 character token containing only letters, numbers, underscores (_), or hyphens (-), which eBay uses to verify ownership of your endpoint. After entering your Notification...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
the feed means that duplicates will be created. You will need to delete the ones manually imported in order for the numbers to be brought in line. Notes and findings: Integration locks: The “Accounts associated with Integration cannot be marked...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
to Joomla! CMS v3.5.x What? This is a short article on how to remove the ID numbers from your Joomla website addresses for search engine friendly URLs. // What I have...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
} return handled; } }); Other Noteworthy Actions android:inputType In some cases, this will change the keyboard layout (eg. Numbers) text // Normal text textNoSuggestions // No suggestions/autocorrect textEmailAddress // valid email address...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
they see the error they programmed in. Apparently this problem also happens when you have a Data File of varying column numbers. My solution below will also fix this. How? My data file had some empty rows amongst the data. The easy fix is by dealing...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
I'm looking in the wrong place. Using Aggregate Functions? What follows is the T-SQL Query I finally went with. Lots of numbers but I think this pretty much answered my question: SELECT Catalog.Name AS ReportName , MIN(ExecutionLogStorage.TimeStart) AS...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
5) -- "Right()" to say extract text from the right -- ".ToString" because it's likely you're doing this to a number and numbers just get rounded up without the prefixing zeros -- "00000" because we don't expect strings to exceed 5 characters. The Oracle...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
need the size of the report but the value has to be returned as part of the aggregate query. I want the SQL to return just numbers and let the MDX query add the thousand separator. My answer for everything: CAST((TimeEnd - TimeStart) AS TIME)...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
CURRENT_TIMESTAMP, 131) 14/11/1432 06:00:00:000AM I originally got a list from databases.aspfaq.com but the convert numbers didn't correspond to the output formats. This is my list created within my environment and setup (see above).
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
1968-05-05 4 otentre AhYe Usr 1964-08-08 Precursor You will need to be able to create the following view to generate random numbers on SQL Server. -- Used to reference RAND with in a function CREATE VIEW dbo.vwRandom AS SELECT RAND() as RandomValue; GO...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
END GO -- Usage: -- EXECUTE dbo.usp_MakeTableTemp 'mySchema.myTable'; Post-Notes Added a dummy index to track row numbers. Copies structure (column_name, data_type, character_maximum_length) Copies data (should be exact copy)
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
4 RJDsFMaeNcLrcMWw 1964-08-08 How? Precursor You will need to be able to create the following view to generate random numbers on SQL Server. -- Drop the view if it already exists IF OBJECT_ID ('vwRandom', 'V') IS NOT NULL DROP VIEW vwRandom ; GO -- Used...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
becoming an analyst, I do more at the database level now. What follows should be usable mySQL statements to get all the numbers: Yesterdays -- CURRENT: count todays SELECT COUNT(id) FROM Table1 WHERE DATE(registerDate)=DATE(NOW()); -- BEFORE: count...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
I have a mySQL database table of room assets that has a field containing the ID numbers of images relevant to this room. The Problem? When I select specifying the statement "WHERE IN (c.RoomImages)", this is interpreted as a string and when converted to...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
I have an unordered list of values (*, 1, 2, 3...) and for styling reasons I want the asterisk to be the same size as the numbers but not overlap any list item beneath it. By increasing the size of the asterisk, this often increases the line-height and...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: *
-
What? An article on how to quickly adapt an array code and sort by its values. Surprising how many examples are on the web and everyone saying you're doing it wrong... Which is true but quite unhelpful. The original code is not my own either but that's...
- Type: Article
- Author: Joel Lipman
- Category: JavaScript
- 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
-
Air Base 39°48′40″N 116°42′30″E 39 48 40 N 116 42 30 E 39.81111111 116.708333333 39.81111111 116.7083333 Note that negative numbers should be supported. I tend to use Excel to reduce the decimal point to only 7 decimal places (for importing to a...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB