I am using SQL Server 7.0 and want to have a comment box (using text data type) for the user on an ASP form. I am using the following code and have removed the >< and double quote signs to protect the innocent (me):

TEXTAREA id=txtInvestigation name=txtInvestigation
style=HEIGHT: 270px;
LEFT: 10px;
POSITION: absolute;
TOP: 25px;
WIDTH: 350px
readonly
datafld=%=oRS(Investigation)%
/TEXTAREA

Also assigned datasrc=oRS and it too works. oRs is an ADO object.

The SQL Server Table gets updated correctly – however, after the comments are saved they do not appear on the ASP form (after refresh, etc.). I suggested to a fellow developer this was a “Zen” object – we just had to tell the users to use “Zen” to read the comments. Or I guess we could “Use the Force”.

Any suggestions?

Tom