<% ' ********************************** ' * MasterPlumbers.com ' * PlumbViews - Meet The Authors ' * Version 2.0.0 8.Nov.2010 ' ********************************** PageTitle = "PlumbViews" PageDesc = "Meet The Authors" %> <%Call OpenSQLDB()%> PlumbViews : Colin Dunn : Articles - MasterPlumbers.com
PlumbViews articles by
Colin Dunn

<% searchSQL = "SELECT [pub_date],[url],[title],[blurb],[author] FROM [MP_plumbviews] WHERE [author] LIKE '%Dunn%' ORDER BY [pub_date] DESC" set articles = DBConnection.execute(searchSQL) IF articles.EOF = True THEN %>

No articles have been published by this author

<% ELSE DO UNTIL articles.EOF %>

" title="<%=articles("title")%>" target="_blank"><%=articles("title")%>

Posted on <%=FormatDateTime(articles("pub_date"), 1)%> by <%=articles("author")%>

<%=articles("blurb")%>... " target="_blank">more info»

<% articles.MoveNext LOOP END IF articles.Close: set articles = nothing: %> <%Call CloseSQLDB()%>