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,Re lease_date from tbl_Item_Master where datediff(month, Release_date,no w())<=1 order by Release_date;"
2. "Select Title,singer,Re lease_date from tbl_Item_Master where datediff(month, Release_date,ge tDate())<=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="Micros oft FrontPage 4.0">
<meta name="ProgId" content="FrontP age.Editor.Docu ment">
<title>Song</title>
</head>
<body>
<form method="POST" action="--WEBBOT-SELF--">
<!--webbot bot="SaveResult s"
U-File="C:\Inetpu b\wwwroot\AspDe mo\home\_privat e\form_results. txt"
S-Format="TEXT/CSV" S-Label-Fields="TRUE" -->
<table border="1" width="100%">
<tr>
<td width="100%">
<h2>   ; &n bsp;   ; &n bsp;   ; &n bsp;   ; &n bsp;   ; <font color="#0000FF" face="Monotype Corsiva" size="5">
New Releases in the Last Month </font></h2>
</td>
</tr>
<%
Set rs = Server.CreateOb ject("ADODB.Rec ordset")
Set rs.ActiveConnec tion = my_Conn
retrieveSql = "Select Title,singer,Re lease_date from tbl_Item_Master where datediff(month, Release_date,no w())<=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>
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,Re lease_date from tbl_Item_Master where datediff(month, Release_date,no w())<=1 order by Release_date;"
2. "Select Title,singer,Re lease_date from tbl_Item_Master where datediff(month, Release_date,ge tDate())<=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="Micros oft FrontPage 4.0">
<meta name="ProgId" content="FrontP age.Editor.Docu ment">
<title>Song</title>
</head>
<body>
<form method="POST" action="--WEBBOT-SELF--">
<!--webbot bot="SaveResult s"
U-File="C:\Inetpu b\wwwroot\AspDe mo\home\_privat e\form_results. txt"
S-Format="TEXT/CSV" S-Label-Fields="TRUE" -->
<table border="1" width="100%">
<tr>
<td width="100%">
<h2>   ; &n bsp;   ; &n bsp;   ; &n bsp;   ; &n bsp;   ; <font color="#0000FF" face="Monotype Corsiva" size="5">
New Releases in the Last Month </font></h2>
</td>
</tr>
<%
Set rs = Server.CreateOb ject("ADODB.Rec ordset")
Set rs.ActiveConnec tion = my_Conn
retrieveSql = "Select Title,singer,Re lease_date from tbl_Item_Master where datediff(month, Release_date,no w())<=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>
Comment