Data Types Of Two Matching Results Are Incompatible
Created by Alan Hurt on 05/13/2004. Modified: 05/13/2004 07:34
HTTP Web Server: Lotus Notes Exception - The data types of two matching results are incompatible
The data types of two matching results are incompatible.
Suggested Causes and Solutions:
If an @DbColumn is being performed on an integer column, and there is a document in the view with a null integer field -- a blank field -- you will get this error message.
Alan Hurt on 05/13/2004 07:35
This will also occur if the @dbcolumn looks to a column where dates occur and one of the rows (or categories if looking up a categorized column) is an empty value.
You can try converting the values of the column to Text with @text as a work around. If you do, preserve the date sorting by inserting a hidden column containing the date values and have it do your sorting.
Jerry Carter on 05/25/2004 07:46
This could be a design issue.
Sunil on 02/18/2005 11:27
Hi, i'm not speak english very well, so apologies. I've had a column with number data from field "Correlativo" and this "@If(Correlativo != "";Correlativo; "")};" give me the error, the problem solve with this change "@TextToNumber(@Text(Correlativo));" Greetings
Luciano on 08/07/2008 10:07 AM
Add Your Own Solution
Use this form to add a suggested cause or solution which you think might help.
Adding content is disabled. The spammer have won.