This one is completely baffling.
DB Enviornment: MSSQL database
Code Environment: ASP / VBscript (obviously)
Problem: data from an nText field disappears from conn.execute(sql) 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("NoteField")
rsdata.movenext
loop
Code set 2: does NOT always display NoteField correctly.
do while not rsdata.eof
response.write rsdata("ID")
response.write rsdata("NoteField")
rsdata.movenext
loop
Here are the different ways I have created the recordset
Does Not display correctly
-------------------------------------------
set rsdata = conn.execute(sql)
rsdata.open sql, conn
Does display correctly
------------------------------
rsdata.open sql, conn, 3,3
The only way I can get the ID and the NoteField to display correctly is if I open the recordset keystatic, pessimistic.
You are saying to yourself, this guy just solved his own problem.....here's the wrinkle. While the sql is a monster, I have to run it thru a STORED PROCEDURE ( which handles recordset paging ). The sql alone works with the sql, conn, 3,3..... but the stored procedure call will only display the note in codeset 1, not codeset 2.
The $65,000 is:
Why will the Note field display when called by itself, but NOT display if another field is called just before or after it?