fun with ADO

[Tomasz Stochmal]

> 
>     rs=win32com.client.Dispatch(r'ADODB.Recordset')
>     rs.Open(sql,connectString)
>     while not rs.EOF:
>         name=str(rs.Fields("clientname").Value)  #oink!
>         gid=str(rs.Fields("gid").Value)
>         (- do something fun with fields -)
>         rs.MoveNext()
>     rs.Close()
> 

Use rs.GetRows() to retrieve all rows & fields with one call only
on python side you can extract the field values that you need