Next Page

1

Previous Page

Thread: field length

Created on: 07/29/09 10:54 AM

Replies: 2

mccolgan


New Member


Joined: 07/22/09

Posts: 3

field length
07/29/09 10:54 AM

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?

Link | Top | Bottom

mccolgan


New Member


Joined: 07/22/09

Posts: 3

RE: field length
07/29/09 2:13 PM

Never mind, I went to work on another task and when I got back to this it was working properly. I'm not really sure what the problem was.

Link | Top | Bottom

admin


Experienced Member


Joined: 04/08/04

Posts: 2,947

RE: field length
07/29/09 11:37 PM

Let me know if you have any more problems. Sorry for the delay - I'm on vacation this week.

Link | Top | Bottom

Next Page

1

Previous Page

New Post

Please login to post a response.