No value given for one or more required parameters.

Databaser & SQLur Databashanterare & SQL

3 svar · 347 visningar · startad av preben 1 nov. 2009

prebenMedlem sedan mars 2009452 inlägg

Frågan1 nov. 2009 08:51#1

SQL = "SELECT a.intID, a.strName FROM [article] a, [articleCounter] ac WHERE a.intID = ac.intArticleID " _
	& " AND DATEPART(month, ac.dteCreated) = " & month(date()) & " AND DATEPART(year, ac.dteCreated) = " & year(date()) _
	& " ORDER BY ac.intCounter DESC;"

Jag kör klassisk ASP + Access och det är nåt som inte stämmer med datumraden. Men vad!?

Utskriven ser koden ut så här:

SELECT a.intID, a.strName FROM [article] a, [articleCounter] ac WHERE a.intID
= ac.intArticleID AND DATEPART(month, ac.dteCreated) = 11 AND
DATEPART(year, ac.dteCreated) = 2009 ORDER BY ac.intCounter DESC;

prebenMedlem sedan mars 2009452 inlägg

1 nov. 2009 09:24#2

SELECT * FROM [articleCounter] ac WHERE DATEPART(month, ac.dteCreated) = 11;

Inte heller denna fungerar...:

SELECT * FROM [articleCounter] ac WHERE DATEPART(month, ac.dteCreated) = 11;

prebenMedlem sedan mars 2009452 inlägg

1 nov. 2009 09:37#3

SQL = "SELECT * FROM  [articleCounter] ac  WHERE  DATEPART('mm', ac.dteCreated) = 11;"

OK, jag svarar mig själv här. The answer is... enkelfjumpar!

Tack!

***
Bra tutorial: http://www.tizag.com/sqlTutorial/sqldatepart.php
Sökte efter datePart i detta forumet.

prebenMedlem sedan mars 2009452 inlägg

1 nov. 2009 11:19#4

Fel av mig... Igen.

' ## TOP 5 MOST READ ARTICLES PER EACH MONTH
SQL = "SELECT a.intID, a.strName, ac.intCounter FROM [article] a, [articleCounter] ac WHERE a.intID = ac.intArticleID " _
	& " AND month(ac.dteCreated) = " & month(date()) & " AND year(ac.dteCreated) = " & year(date()) _
	& " ORDER BY ac.intCounter DESC;"
'	response.write SQL
set mySQL = Conn.Execute(SQL)
IF NOT mySQL.EOF THEN listMyTOP5List = mySQL.GetRows()

Så här ska det vara i Access!