List:General Discussion« Previous MessageNext Message »
From:Alexander Mordach Date:March 4 2013 2:40am
Subject:Recordset item becomes malformed / truncated
View as plain text  
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

Thread
Recordset item becomes malformed / truncatedAlexander Mordach4 Mar
  • Re: Recordset item becomes malformed / truncatedJohan De Meersman4 Mar