Problem running ASP page

[Gia]

hello,
i want to be able to view the description of the column name in SQL
for example when i open recordset, i use the following
rs - recordset

---> rs.fields(column name).value
in my script.

If I want to view description of column, what is the property i can use?
Suggestions? sample if have one?

regards,
Giovanna

[Diana L]

Hello,
One of the properties you are looking for is Type.
rs.Fields("colimn name").Type
This will return an integer which is DataTypeEnum.
Type is read/write property.

Take a look for other Field properties like Size, Precision, etc.
http://msdn.microsoft.com/library/de...k/mdao2o9w.htm

Also look for interpretation of returned integers:
http://msdn.microsoft.com/library/de...k/mdae8o19.htm

Hope this helps.
D.