<%
Set rs = Server.CreateObject("ADODB.Recordset")
strSQL = "select distinct strPubDate, intPubdateSort from tbWriteItLessons order by intPubdateSort"
rs.Open strSQL, "DSN=dotcom",adOpenDynamic,3
if rs.EOF or rs.BOF then
blnEmptyRs = true
else
blnEmptyRs = false
end if
if not blnEmptyRs then
Do While not rs.EOF
pubdate = rs("strPubDate")
urlpbdt = server.URLEncode(pubdate)
Response.Write "" & vbCrLf
Response.Write "| "&pubdate&" | " & vbCrLf
Response.Write " " & vbCrLf
Response.Write "" & vbCrLf
Response.Write " | " & vbCrLf
Response.Write " " & vbCrLf
rs.MoveNext
loop
Else
Response.write "No Data Found...."
end if
set rs = nothing
%>
|  |
<%
Set rs = Server.CreateObject("ADODB.Recordset")
strSQL = "select distinct strGenre from tbWriteItLessons where datalength(strGenre) > 0 order by strGenre"
rs.Open strSQL, "DSN=dotcom",adOpenDynamic,3
if rs.EOF or rs.BOF then
blnEmptyRs = true
else
blnEmptyRs = false
end if
if not blnEmptyRs then
Do While not rs.EOF
genre = rs("strGenre")
urlgenre = server.URLEncode(genre)
Response.Write "" & vbCrLf
Response.Write "| "&genre&" | " & vbCrLf
Response.Write " " & vbCrLf
Response.Write "" & vbCrLf
Response.Write " | " & vbCrLf
Response.Write " " & vbCrLf
rs.MoveNext
loop
Else
Response.Write "No Data Found...."
end if
set rs = nothing
%>
|
 |
|
 |
<%
Set rs = Server.CreateObject("ADODB.Recordset")
strSQL = "select distinct strSkills from tbWriteItLessons where datalength(strSkills) > 0 order by strSkills"
rs.Open strSQL, "DSN=dotcom",adOpenDynamic,3
if rs.EOF or rs.BOF then
blnEmptyRs = true
else
blnEmptyRs = false
end if
if not blnEmptyRs then
Do While not rs.EOF
skills = rs("strSkills")
urlskills = server.URLEncode(skills)
Response.Write "" & vbCrLf
Response.Write "| "&skills&" | " & vbCrLf
Response.Write " " & vbCrLf
Response.Write "" & vbCrLf
Response.Write " | " & vbCrLf
Response.Write " " & vbCrLf
rs.MoveNext
loop
Else
Response.Write "No Data Found...."
end if
set rs = nothing
%>
|