I'm trying to edit the survey description length from 255 to max. We are using SQL server 08.
I edited the datatype for description in the table in SQL server from nvarchar(255) to nvarchar(MAX)
I also removed the part in surveys.cfc where it sets the maxlength=255
I also did this for the thankyoumessage.
It's only working for thankyoumessage. In the surveys.cfc it's cfsqltype is defined as CF_SQL_LONGVARCHAR, so I tried changing the description's cfsqltype to that, didn't work. I tried getting rid of the cfsqltype parameter altogether and it still doesn't work.
I get the error "The cause of this output exception was that: coldfusion.tagext.sql.QueryParamTag$InvalidDataException: Invalid data value DATA exceeds maxlength setting 255..."
But I got rid of the maxlength setting, why is it still doing this?
Any insight?
