IT SOLUTIONS
Your full service technology partner! 
-Collapse +Expand
ASP Classic
Search ASP Classic Group:

Advanced
-Collapse +Expand ASP Classic Store

Prestwood eMagazine

January Edition
Subscribe now! It's Free!
Enter your email:

   ► KBWebsite Scri...ASP ClassicLanguage Det...   Print This     
  From the August 2014 Issue of Prestwood eMag
 
ASP Classic Language Details:
RecordSet Properties, Methods, and Events
 
Posted 13 years ago on 12/26/2006
Take Away: Using a RecordSet's properties, methods and events.

KB100431



RecordSet Fields Count
The following code displays the number of fields in a RecordSet object. 

Dim RS
'''Open the record set with something like RS.Open...
Response.Write "Table Field Count=" & RS.Fields.Count

Once a RecordSet object is open, you can use the Count property to cycle through the fields displaying verious properites.

For example:

<table>
 <%
 For TableField = 0 to RS.Fields.Count - 1
  Response.Write "<tr>"
  Response.Write "<td>" & RS.Fields.Item(TableField).Name & "</td>"
  Response.Write "<td>Type=" & RS.Fields.Item(TableField).Type & "</td>"
  Response.Write "<td>DefinedSize=" & RS.Fields.Item(TableField).DefinedSize & "</td>"
  Response.Write "<td>Precision=" & RS.Fields.Item(TableField).Precision & "</td>"
  Response.Write "<td>NumericScale=" & RS.Fields.Item(TableField).NumericScale & "</td>"
  Response.Write "<td>Attributes=" & RS.Fields.Item(TableField).Attributes & "</td>"
  Response.Write "</tr>"
  Next
 %>
</table>

A dynamic Property object has four built-in properties of its own:

  • The Name property is a string that identifies the property.
  • The Type property is an integer that specifies the property data type.
  • The Value property is a variant that contains the property setting. Value is the default property for a Property object.
  • The Attributes property is a long value that indicates characteristics of the property specific to the provider.

Comments

0 Comments.
Share a thought or comment...
 
Write a Comment...
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1197A1
Enter key:
KB Post Contributed By Mike Prestwood:

Mike Prestwood is a drummer, an author, and creator of the PrestwoodBoards online community. He is the President & CEO of Prestwood IT Solutions. Prestwood IT provides Coding, Website, and Computer Tech services. Mike has authored 6 computer books and over 1,200 articles. As a drummer, he maintains play-drums.com and has authored 3 drum books. If you have a project you wish to discuss with Mike, you can send him a private message through his PrestwoodBoards home page or call him 9AM to 4PM PST at 916-726-5675 x205.

Visit Profile

 KB Article #100431 Counter
7728
Since 4/2/2008
-
   Contact Us!
 
Have a question? Need our services? Contact us now.
--Mike Prestwood

Call: 916-726-5675

email: info@prestwood.com


Go ahead!   Use Us! Call: 916-726-5675 


©1995-2019 Prestwood IT Solutions.   [Security & Privacy]