devxlogo

A Quick Way to Display Text from a Database in ASP

A Quick Way to Display Text from a Database in ASP

Why Trust Us

Suppose you are creating a dynamic page in ASP. Most of the page elements are dynamic and you need a few of the headers to have the first letter of each work to be capitalized. With a very small amount of CSS, you can avoid using VBScript for string manipulation. Using text-transform:capitalize you can apply a quick style to any database driven data.

<%'Create the variablesDim Conn, RS, SQL'Set your connection and recordsetSet Conn = Server.CreateObject("ADODB.Connection") Set RS = Server.CreateObject("ADODB.Recordset")'Set the DSN of the connectionConn.Open "DSN=myODBC"'create the SQL stringSQL = "Select TopicTitle From Topics Where ID > 0"'Open the recordset and make it read-onlyRS.Open (SQL), Conn,1,1'loop through recordsetif not RS.EOF then %>
<%=TopicTitle%>

<% 'end IF statement and cleanup database infoRS.Closeend if Set RS = NothingConn.CloseSet Conn = Nothing%>
See also  Professionalism Starts in Your Inbox: Keys to Presenting Your Best Self in Email
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist

Charlie Frank

Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
View Author
Show More