devxlogo

A Quick Way to Display Text from a Database in ASP

A Quick Way to Display Text from a Database in ASP

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  Essential Measures for Safeguarding Your Digital Data
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