September 10, 2009 at 12:00 pm
Here the repro from our tester:
When editing a Budget/CAR for a proposal project, the comments textarea for Web app is blank. It allows you to enter a value and save the changes. The changes are updated on the database. They are not reflected in the textarea box.
Textarea HTML notes box utilizing classic ASP is not compatible with the datatype of varchar(max). This column (in the table ProjectChangeID) is set to varchar(max). When changing it to a column that has a value set for varchar the textarea populates.
Any workarounds, comments or fixes to share?
Thnks in advance
Takauma
September 10, 2009 at 12:31 pm
Haven't bumped into this issue for a few years (although nvarchar(max) is much newer), but I'll try some old NText solutions we used to use:
1. Update your MDAC libraries to most recent version
2. MOve your NVARCHAR(MAX) columns to the last position in your select, as in:
Select int, date, varchar(32) columns..., NVARCHAR(MAX) colum
from... WHERE....
This usually did the trick
September 10, 2009 at 11:16 pm
It's not entirely clear from your description, but it seems the application is not MAX data type aware.
Two solutions spring to mind: upgrade the application (presumably not an option) or change the data type in the data base to the equivalent (deprecated) type: text, ntext, or image.
The deprecated types won't be around much longer, so it may pay you to start planning the application upgrade/rewrite...
Paul
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply