How to get the value from each field in table?

We can use either index number or the field name to get the value from the table.

For example:

First, we use index number to get the member name:

<% response.write(rs.fields(2).value) %> 'we assume fields 2 is the member name;

or

<% response.write(rs.fields(2)) %>

Or, we use the field name to display the member name:

<% response.write(rs.fields("MemName")) %>

or

<% response.write(rs("MemName")) %> 'we can also not using the keyword "fields".