473,320 Members | 1,766 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

How do display new releases songs?

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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#0000FF" face="Monotype Corsiva" size="5">
New Releases in the Last Month&nbsp;</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>&nbsp;</p>
<p>&nbsp;</p>
</form>

</body>

</html>
Mar 3 '10 #1
1 1319
jhardman
3,406 Expert 2GB
Please stop posting your db questions in the asp forum.
Mar 11 '10 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

8
by: Thomas D'Tak | last post by:
Hi everybody! Recently, I am having more and more problems with the fact that my Python version is far ahead of the Python versions I have to write scripts for (CGI servers, LAN servers &...
3
by: Jim Hubbard | last post by:
My own searches have proven to be of little help in understanding the implementation of this technology (available since Win98). Any information that you could share on Display Driver Management...
2
by: Con | last post by:
Hi, I'm getting the following error message in the JavaScript console: Error: mus has no properties Source File: file:///G:/temp/cafedub.htm Line: 35 Now, I would like to script to work in...
4
by: Sumaira Ahmad | last post by:
Hi, Is there any way of playing songs and downloading songs from a server onto a client machine. I want to develop an application such as a music portal which allows clients to play songs that...
1
by: nafogel | last post by:
Hi, I am kinda familiar with html, but i am having a problem. I am working on a menu system for a handheld gaming device (PSP). I want the menu to be able to display all files with a certain...
0
by: vijil | last post by:
Hai Friends I am doing a project using asp and sql server2000.I want to know how we can store songs and retrive it from sql server 2000.
4
by: Shazia Sadiq | last post by:
Hi! i m developing a website for sell of songs all songs are place in songs folder. and at front end of website url to download shows the link of songs folder so it is threat that may be soem try...
1
by: slinkp | last post by:
This seems to be a bit of a FAQ (at least among worried Zope developers :-) ... What are the plans for Python 2 releases after Python 2.6 / Python 3 are released? First, in the 2006 State of...
1
by: vegtard | last post by:
hay. long time since my last post now xD anyways, im playing around with with flash in actionscript 2.0, and the textbook im using wont teach me how to preload songs. it simply tells me that...
16
by: davidson1 | last post by:
Hai friends.... i have a video that contain songs and messages.i just want to extract songs alone.how can i do that.i am using windows XP can u help me....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.