© 2012 Dave Holmes
%
'===============================================================================================================================================================
' 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) %>
© 2012 Dave Holmes