Classic ASP Discussion - show field description

Print Page | Close Window

show field description

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=6874
Printed Date: 01 April 2026 at 1:00am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: show field description

Posted By: regevli
Subject: show field description
Date Posted: 31 October 2003 at 6:33am

is there an option to view the description of a field ?

im using access as my db.

thanks

Replies:

Posted By: MorningZ
Date Posted: 31 October 2003 at 10:51am

there is no provisions in ADO (what asp uses to talk to DB) to get that from the table

-------------
Contribute to the working anarchy we fondly call the Internet

Posted By: michael
Date Posted: 31 October 2003 at 12:43pm

Not in ADO but in ADOX


<% 
    Set c = Server.CreateObject("ADOX.Catalog") 
    c.ActiveConnection = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\db1.mdb" 
    d = c.Tables("table1").Columns("Field1").Properties("Description ").Value 
    Response.Write "Description = " & d  
    Set c = nothing 
%>

You can of course loop through every field to get them all.

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker

Posted By: amirahmed
Date Posted: 08 December 2003 at 5:21pm

correction.. the code should be:

<%
    Set c = Server.CreateObject("ADOX.Catalog")
    c.ActiveConnection = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\db1.mdb"
    d = c.Tables("table1").Columns("Field1").Properties("Description ").Value
    Response.Write "Description= " & d
    Set c = nothing
%>

the space after description will stop it from working...

there is something wrong with this forums text box, it adds a space to the end of Description.. real weird.. sorry guys just remember to remove it after you copy the code.

Posted By: fernan82
Date Posted: 10 December 2003 at 11:13pm

those spaces are made by the function that cuts long strings on the forum to prevent the layout from being broken or by one of the thousands of security checks a post has to go thru before being posted.

<edit> or maybe that's borg playing with our minds

-------------
FeRnAN
http://www.danasoft.com/">

Posted By: pmormr
Date Posted: 11 December 2003 at 7:32pm

damn security

-------------
Paul A Morgan

http://www.pmorganphoto.com/" rel="nofollow - http://www.pmorganphoto.com/