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.


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

Use this form to add a suggested cause or solution which you think might help.

Adding content is disabled. The spammer have won.