Problem running ASP page


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Problem running ASP page

  1. #1
    Gia Guest

    Problem running ASP page


    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

  2. #2
    Diana L Guest

    Re: Problem running ASP page


    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.











Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center