Vista - Loop through Northwind records

Hi All.

I'm trying to do something verysimple with vbscript: open a Northwind
table and loop through the recordset, echoing a field as I do so. Here
is what I'm attempting. The problem is that I can't find the syntax
documented for how to get to the fields of a recordset. The
'FieldByName' part, I made up, to illustrate what I'm trying to do.

Const adOpenStatic = 3
Const adLockReadOnly = 1
Const adUseClient = 3
Set objConnection = CreateObject("ADODB.Connection")
Set objRecordset = CreateObject("ADODB.Recordset")
objConnection.Open "DSN=Northwind;"
objRecordset.CursorLocation = adUseClient
objRecordset.Open "SELECT * FROM Employees" , objConnection,
adOpenStatic, adLockReadOnly
do while not objRecordset.eof

'the problem is here
wscript.echo objRecordset.FieldByName("Last Name")

objRecordset.MoveNext
loop
objRecordset.Close
objConnection.Close

Could anyone direct me to either an example or to where I can find
documentation?

Thanks,
Richard

On Wed, 30 Jul 2008 13:09:42 -0500, "McKirahan" <News@xxxxxx>
wrote:
Thanks McKirahan.
That's exactly what I was looking for.

Richard