how do display top 10 new release 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;"

error - getDate()

Expand|Select|Wrap|Line Numbers

 
<%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 4 '10 #1

Subscribe Post Reply

1421

jhardman

3,406

Expert 2GB

Haven't I warned you before about posting db questions in the ASP forum? Your issue is in Access, Access is returning an error, go post in the Access forum!

Jared

Mar 11 '10 #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...

Javascript

Playing and downloading songs in ASP.NET

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...

ASP.NET

Trying to perform build...website will only display debug

by: andy6 via DotNetMonster.com | last post by:

I am in VS2005 Configuration Manager and have selected from the Active Solution Configuration "release". The deployment project and a supporting c# dll project both switch to release, however the...

ASP.NET

mp3 songs in SQLSERVER

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.

Microsoft SQL Server

I want to secure the folder songs from Unauthenticated usage

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...

PHP

help in drag and drop as adding songs to playlist in media layer

by: rajbala | last post by:

Hi, I want code in javascript in which i can able to drag and drop components between the frames. At same my condition are that it doesn't removed from first frame in which we are going to...

Javascript

Embedding several songs on one page with JS player

by: alice | last post by:

I've been trying for a long time to figure this out, to have a page with several MP3 clips, and each one having a custom start and stop button next to them to play the track. I finally found a bit...

Javascript

Actionscript 2.0, preloading songs

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...

Flash / Actionscript

How to extract songs alone from videos in windows

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....

Microsoft Windows

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

Similar topics