Assuming values is required, the following 98 results were found.
-
only be TEXT (~64Kb) rather than LONGTEXT (~4Gb). Data Type Column Type Range or Description Storage Numeric TinyInt Signed values from -128 to 127 1 byte Unsigned values from 0 to 255 Numeric SmallInt Signed values from -32768 to 32767 2 bytes Unsigned...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
away in a forum: Quick Count =INT(SUMPRODUCT((A3:A1000"")/COUNTIF(A3:A1000,A3:A1000&""))) This returns the number of unique values in the range A3 to A1000 and excludes the blank/empty cells. Display all Unique Found this note on one of Microsoft Help...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
with an "End Date" specified (blank or not). console.log("Joel Lipman - 20221018 -------------------------"); // get some values from the current record var v_CurrencyCode = ZDK.Page.getField('Currency').getValue(); var v_ConsultantLocation =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
This article demonstrates how to return a list of unique values in a particular field in a CRM module. Why? My use-case is a data-migration where the records exist in a staging module in CRM but I want to transform/translate one of the column values...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
each string value in the space separated string ** Assumptions : None ** Inputs : @StringInput = the space separated string values ** Outputs : Single table ** Output Rows : One row per space separated string value ** Return Values : None...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
but using this stored procedure means I only specify the table and then the columns. How? IF OBJECT_ID('usp_ListDistinctValuesAndCounts', 'P') IS NOT NULL DROP PROCEDURE [usp_ListDistinctValuesAndCounts]; GO CREATE PROCEDURE...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
A quick note on how to compare two columns for values that are not found in another. I have a column with old values, and now that I have a new list, I want a quick way to see what values are in the old column and which ones are new... Why? Consider the...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: *
-
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 not an...
- Type: Article
- Author: Joel Lipman
- Category: JavaScript
- Language: *
-
will equal the retrieved value of "email" Single Row Result - loadRow() This type of query is for when you want any of the values from one resulting row. You will need to know the column order the results are returned in. $db = JFactory::getDbo();...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
XML Schema Referencehttps://joellipman.com/articles/web-development/xml/xml-schema-reference.html
or element value correspond to those of the specified key or unique element list Defines a simple type element as a list of values notation Describes the format of non-XML data within an XML document redefine Redefines simple and complex types, groups,...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: en-GB
-
my_csv_rows_array.forEach( function (row_content, row_index) { // clear and declare the array var column_values = []; // regex to ignore commas between double-quotes var column_values = row_content.split(/,(?=(?:(?:[^"]*"){2})*[^"]*$)/); // prevents JS...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
the word "TimeStamp". Right-click on the left grey margin of this and select "Insert Row" then "Below". Repeat with all values you want to compare. For each Data cell, Set the background fill expression as per the MDX expression below. The MDX...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
This is an article to remind me how to search a column in an Excel file for values found in another column (in this example, on another worksheet in the same workbook). How? So for demonstration purposes, I'm using a new Excel file with two worksheets...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
A collection of code snippets I seem to be regularly using to generate a dynamic map of system values held in a ZohoBooks instance. Why? Rather than hard-coding and having a ton of if..then statements, I can feed these maps a textual value and it...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Data Consistency. I was tasked with finding variations of our default values. End-users were complaining that some default values get listed twice because their system was case-sensitive despite the collation of the SQL Server being case-insensitive....
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
all Parameters: » General - Untick "allow blank value" and "allow null value" (so these checkboxes are empty). » Available Values - "Get values from a query" = Select the dataset of the dropdown options. » Default Values - "Get values from a query" =...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
"Student Username" first as "Student Reference" must be calculated and not blank/null): So I tried setting the "Available Values" as suggested by Stack Overflow to gets its value based on the first parameter but ended up with an error going on about...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
What? A quick article on how to trim in MySQL along with getting rid of any leading or trailing tab characters. Why? I use MS Excel for organizing data and then converting to MySQL commands. Unfortunately, the MS Excel software adds tab characters to...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
on the report (only a few to keep it simple silly). When you click on the filter, a dropdown appears with all available values listed. The Problem The values are listed in alphabetical order at first. If any new values come along then they get added to...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
based on case-sensitivity. Why? We have a database with data in it. For a particular column we have setup default values, let's use the example "Data Not Yet Available". Unfortunately the end-user reported these default values sometimes list twice,...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB