<% '=============================================================================================================================================================== ' GET SELECTED BLOG '=============================================================================================================================================================== cn = "Driver={SQL Server};Server=SQUIDERS\SQLEXPRESS;Database=DAVEHOLMES;UID=sa;PWD=Monkey77" Set rs01 = Server.CreateObject("ADODB.Recordset") sql = "SELECT * FROM dbo.blog WHERE blog_urn = '" & Request.QueryString("blog_urn") & "'" rs01.Open sql, cn blog_title = rs01.fields.item("blog_title").value blog_intro = rs01.fields.item("blog_intro").value blog_story = rs01.fields.item("blog_story").value blog_story = Replace(blog_story,"
","") blog_story = Replace(blog_story,"

 

","") blog_image = rs01.fields.item("blog_image").value blog_date = rs01.fields.item("blog_date").value blog_date = Left(blog_date,10) %> <%=blog_title%> | The Dave Holmes Blog
Dave Holmes

<%=blog_title%>

<%=blog_title%> <%=blog_story%>

Dave Holmes <%=blog_date%>

back to blog posts

© 2012 Dave Holmes

Dave Holmes