Hello,



I?m working through a weird issue that revolves around LONGTEXT fields in
our DB. For some strange reason whenever we add any type of server side
checking (Classic ASP) to an item in the recordset it loses its value and
becomes empty.



For example:



Assumption: ?description? has a value of ?There is data?



___________________________________________________________________



Set test = db.getRS("SELECT description FROM `case` WHERE case_id = '120')



do until test.EOF

response.write test("description") & " / Getting good data.
<br>"

test.movenext

loop



The above code would output ?There is data / Getting good data.?



___________________________________________________________________







Now, if any type of check is done on the data the result changes?







________________________________________________________________________



Set test = db.getRS("SELECT description FROM `case` WHERE case_id = '120')



do until test.EOF

if test(?description?) <> ?? then

response.write test("description") & " /
Getting good data. <br>"

end if

test.movenext

loop



The above code would output ?/ Getting good data.? The value returned from
the database gets lost.



________________________________________________________________________







Another weird behavior that I noticed is that if you set the field as a
variable everything works as it should, for example:







________________________________________________________________________



Set test = db.getRS("SELECT description FROM `case` WHERE case_id = '120')



do until test.EOF

strHold = test(?description?)

if strHold <> ?? then

response.write strHold & " / Getting good
data. <br>"

end if

test.movenext

loop



The above code would output ?There is data / Getting good data.?



________________________________________________________________________









Has anyone run into anything like this before?



WS2008R2, IIS8, ODBC 5.2.4, MySQL 5.5.



Thanks!

Alex Mordach