code.progysm.com

ADODB.Recordset

RS("nomChamp") ' valeur d'un champ

Exemple:
Dim strRequeteSQL
strRequeteSQL = "SELECT champA,champB FROM tableA"
Set RS = nomConn.Execute(strRequeteSQL) ' Set RS = Server.CreateObject("ADODB.RecordSet")
                                        ' RS.Open strRequeteSQL, nomConn

Response.Write RS("champA")
If Not RS.EOF Then
  RS.MoveNext
  Response.Write RS.fields(0).name ' "champA"
End If

RS = Nothing