Varchar(max) fields not displaying in wep ASP

  • 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

  • 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

  • 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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply