This one is completely baffling.

DB Enviornment: MSSQL database
Code Environment: ASP / VBscript (obviously)

Problem: data from an nText field disappears from conn.execute(sq l) recordset. The sql statement is a monster, I'll give you a taste down below.

Code Set 1 : always displays fine
do while not rsdata.eof
response.write rsdata("NoteFie ld")
rsdata.movenext...