Server Side Processing, ColumnControl, searchDateTime, manually input invalid date format -> error

kschl

Hi,

I have this scenario:
* Server Side Processing (SSP)
* .NET Server Side library 2.5.2
* ColumnControl

ColumnControl option:
* searchDateTime

This error message appears, when I manually input date with invalid format:

Conversion failed when converting date and/or time from character string

Probably due to bad SQL date format. Without SSP: no error message.

As workaround, is it possible to set the input field to readonly?
Is there a way to intercept and validate input before it reaches the server or handle it on the server side?

Thank you very much for your help.

allan

You could use DOM methods (or jQuery) to add readonly as an attribute to the input - there isn't currently a way to do that with the options for ColumnControl I'm afraid. I will look into how that might be done.

Allan