Classic ASP result set - ultimate confusion!
- by Paul
Consider a simple result set from a mysql query.
rs("description")
and
rs("description").Value
should be considered as the same thing. However, depending on how you access them, you get different results (!!)
Access rs("description") directly and you are returned a "Field" object. Or, more importantly, use it directly in a call, and you are returned a "Field" object.
mydescription = rs("description") + " is the description"
Assign it to another variable, and the Value of that object is assigned...
mydescription = rs("description")
the contents of "mydescription" is a string.
Why this difference? At one point in the life of ASP they must have both worked exactly the same, so why have they changed, and how can I change it back?