Ouch! I have been looking at code so long I feel like my eyeballs have 
switched places!

We are a couple of newbie programmers working on our woodworking club's 
web site (we are pretty lucky to have a benefactor with lots-o-fun-
software to play with).  And, we have gotten a little over our head on 
something.  I would be enormously grateful to anyone that can help us 
understand the following.

We have several places in our ASP code that, after upgrading from Access 
to SQL server, are just simply not working.  An example of the code is as 
follows....

cmd.CommandText = "select thing from thingtable"
ThingRS = CmdExecute(cmd)

While not ThingRS.EOF
  response.write "Thing is: " & ThingRS("Thing") & "<br>"
  ThingRS.MoveNext
Wend

And, ya' know what - Thing never has a value according to ASP!. Now, I 
know there are Things in my DB. But, I can't seem to access the Thing's 
value through the RS. We think it has something to so with mismatches in 
any one of the multitude of char datatypes in Access and SQL Server but 
we cannot determine a consistent approach or overarching principle to 
guide us in determining how to solve this issue for our application.

We figure someone out there could give us some insight.  Thanks in 
advance to all of ya'

Take care,

TW3