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%>
