AS400 Table Information

Tek707 · #1 (**permalink**) 09-12-02, 13:39

Is there a way I can get the field names of an AS400 table via ASP coding.

JonathanB · #2 (**permalink**) 09-13-02, 04:31

All depends on what database access layer your using...

Once you have the data in a recordset you can retrieve the field names using:

Quote:

for f = 0 to data_rs.fields.count-1
response.write(data_rs.fields(f).name)
next

Tek707 · #3 (**permalink**) 09-13-02, 12:56

Quote:

Originally posted by JonathanB
All depends on what database access layer your using...

Once you have the data in a recordset you can retrieve the field names using:

Thanks...That helped alot.

Internet Services

Web Development

Digital Marketing

Consumer Tech