Mark, I'm taking a long shot here. For what I know of Classical ASP (which consists in years of swearing and loving), a NULL answer from the MySQL database results in... nothing, actually. Unless you define the recordset result as a string, it won't be comparable with a "". So, either you do this:
var recordsetVal = oRs("textthing")&""
... or you could simply do this:
if oRs("textthing")&"" <> "" then
Also, instead of while ... wend, use a do while...loop lace. It might work.
Again, this is a long shot. many factors could be involved in this question, but MySQL Driver and ODBC compatibility issue is only one of them and, fortunately, the least probable. Keep us posted.
Thanks for the response Eric. In this case, there IS text in the response from the database (because it's a fictitious example). But the point is, it's there for access 1, but not anything further. :( I have edited the question code to reflect this more obviously.
Hmmmm,... thats odd. I could have sworn it was a null-type string problem. Honestly, I'm lost here... I'll try to think a little further here. Oh, BTW, you've sliced out the rs.MoveNext from the edited code. I know it was there before, but if someone else comes in and it is not there, they might think that that's where the problem at.
Yes, no movenext is intentional - since I am selecting 1 thing, and showing what happens with that. (I'll change it so it's a string and people will get the idea)