Good wishes,
I have a problem i am using access database *.mdb to provide dynamic content to my website using asp classic as server side scripting.
I have a table named "circ"
Structure is ID autonumber, particulars text field, updatetime Date/time field
I have some entries in it I want to display it on my website Year/Month wise.
Eg.
2014
May
RECORD1
RECORD2
January
RECORD3
RECORD4
2013
December
RECORD5
RECORD6
At present I am using following code to create connection and fetch data from mdb file.
set rsd =server.CreateObject("ADODB.Recordset")
rsd.ActiveConnection = Con (Connection name)
Set rsd = Con.Execute("Select * from circ order by updatetime desc ")
if not(rsd.EOF or rsd.BOF) then
rscirc=rsd("Particulars")
rsupt=rsd("updatetime")
rsyear=year(rsupt)
rsmonth=(MonthName(month(rsupt)))
else
end if
and following code to display data but clueless about the syntax
<%
if not(rsd.EOF or rsd.BOF) then
While not rsd.Eof %>
<FONT ><%=rsyear%></FONT> <BR>
<% rsd.MoveNEXT
Wend
%>
<% else %>
Information coming soon...
<% end if %>
I am recieving the Year repeatedly.
Please help. Thanks in advance
I have a problem i am using access database *.mdb to provide dynamic content to my website using asp classic as server side scripting.
I have a table named "circ"
Structure is ID autonumber, particulars text field, updatetime Date/time field
I have some entries in it I want to display it on my website Year/Month wise.
Eg.
2014
May
RECORD1
RECORD2
January
RECORD3
RECORD4
2013
December
RECORD5
RECORD6
At present I am using following code to create connection and fetch data from mdb file.
set rsd =server.CreateObject("ADODB.Recordset")
rsd.ActiveConnection = Con (Connection name)
Set rsd = Con.Execute("Select * from circ order by updatetime desc ")
if not(rsd.EOF or rsd.BOF) then
rscirc=rsd("Particulars")
rsupt=rsd("updatetime")
rsyear=year(rsupt)
rsmonth=(MonthName(month(rsupt)))
else
end if
and following code to display data but clueless about the syntax
<%
if not(rsd.EOF or rsd.BOF) then
While not rsd.Eof %>
<FONT ><%=rsyear%></FONT> <BR>
<% rsd.MoveNEXT
Wend
%>
<% else %>
Information coming soon...
<% end if %>
I am recieving the Year repeatedly.
Please help. Thanks in advance