Retrieving Column Names with values

Tutorials Shared by the Internet Community

Advertisements

  Top Tutorials     New Tutorials     Submit     Login     Register  

Tutorial Detail

Retrieving Column Names with values

This tutorials based on a bit of knowledge on SQL.
http://www.devtutorials.info/articles/9_Retrieving_Column_Names_with_values.asp
  • Total Hits: 13614

  • Average Rating :
    URL RatingURL RatingURL RatingURL RatingURL Rating

  •  

  • Total Votes: 139 votes

  • Category: ASP/Database Concepts

  • Submitted on: 2008-03-06 09:12:37

  • Submitted By: Devesh Khanna

  • Set as Favorite

Description:

This tutorials based on a bit of knowledge on SQL. Sample code displays us how to get and show name of columns with values.

Sample Code:

<%

set cn = server.createobject("adodb.connection")

cn.open strCon

set rs = cn.execute("select * from product_list order by productID")

do while not rs.eof    More detail...

Rating Detail

 Stars  Percentage  Total Vote
 One star  Vote LeftVote MiddleVote Right 38.85%  54
 Two starsTwo star  Vote LeftVote MiddleVote Right 10.07%  14
 Three starsThree starsThree stars  Vote LeftVote MiddleVote Right 11.51%  16
 Four starsFour starsFour starsFour stars  Vote LeftVote MiddleVote Right 10.79%  15
 Five starsFive starsFive starsFive starsFive stars  Vote LeftVote MiddleVote Right 28.78%  40

Caste Your Vote

 Rating  Selection  Guidelines
 Poor:     Very disappointing, useless.
 Fair:     Below average, disappointing but not useless.
 Good:     About average in its class.
 Very Good:     Above average for its category.
 Excellent:     One of the best Tutorials in its category.






Advertisements