But! I have yet to figure out how to loops through the RS to print out a whole table. trying this:
i = 0
for i < range(MyRS):
Response.Write(MyRS(0), MyRS(1))
MyRS.MoveNext
i = i + 1
Try this instead. (Note: MoveNext is a method, and needs to have '()' appended.)
while not MyRS.EOF and not MyRS.BOF:
Response.Write(MyRS(0), MyRS(1))
MyRS.MoveNext()
This returns an error on the range function - I can't get a range for the RS object. Obviously I have a lot to learn about python datatypes, statements, etc. A few hours of web searching and scanning py documentation has yielded little. Can anyone offer some poiters and/or point me to some documentation on this? Thanks in advance.
You are right, range() takes in integers and produce a "list". The above solution have very little to do with python. It works with ADO in general.
Arthur Lee