Hi!
My backend is MS-Access. I want to display the resent new releases song.
i got in error in query. i tryed in two way, but i didn't got the answer. pls help me........
1. "Select Title,singer,Release_date from tbl_Item_Master where datediff(month,Release_date,now())<=1 order by Release_date;"
2. "Select Title,singer,Release_date from tbl_Item_Master where datediff(month,Release_date,getDate())<=1 order by Release_date;"
<%pathdefiner = "../"%>
<!--#include file="../Connection/connector.asp" -->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>Song</title>
</head>
<body>
<form method="POST" action="--WEBBOT-SELF--">
<!--webbot bot="SaveResults"
U-File="C:\Inetpub\wwwroot\AspDemo\home\_private\for m_results.txt"
S-Format="TEXT/CSV" S-Label-Fields="TRUE" -->
<table border="1" width="100%">
<tr>
<td width="100%">
<h2> &nbs p; <font color="#0000FF" face="Monotype Corsiva" size="5">
New Releases in the Last Month </font></h2>
</td>
</tr>
<%
Set rs = Server.CreateObject("ADODB.Recordset")
Set rs.ActiveConnection = my_Conn
retrieveSql = "Select Title,singer,Release_date from tbl_Item_Master where datediff(month,Release_date,now())<=1 order by Release_date;"
rs.Source = retrieveSql
rs.Open
Do While not rs.EOF %>
<tr>
<td width="12%"><% = rs("Item_code") %></td>
<td width="88%"><% = rs("Title") %></td>
</tr>
<%rs.MoveNext
Loop
rs.Close
my_Conn.Close
set rs=nothing
set my_Conn=nothing
%>
</table>
<p> </p>
<p> </p>
</form>
</body>
</html>