Referencing data column by it's name

here's my code:

<%

set conn = server.createobject("ADODB.Connection")
conn.open "databasename"

set rs = conn.execute("select * from myTable")

var_firstname = rs(1)

// THE NAME OF COLUMN 1 IS FirstName

%>

here's my question:
I'd like to know how to pull data from the database using the name of the
column instead of using it's column number rs(1)

Can't you reference it somehow by saying var_firstname = rs("FirstName") or
something like that?

Thanks for any input!
Michael
.

Loading