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
