---
title: "No value given for one or more required parameters."
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/181021-no-value-given-for-one-or-more-required-parameters"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "preben"
published: "2009-11-01T08:51:12.000Z"
updated: "2009-11-01T11:19:18.000Z"
replies: 3
views: 367
page: 1
pages: 1
language: "sv-SE"
site: "webForum — webforum.nu"
rights: "Upphovsrätten till varje inlägg tillhör dess författare."
attribution: "Citera som: webForum, https://www.webforum.nu/amne/databaser-sql/181021-no-value-given-for-one-or-more-required-parameters"
---

# No value given for one or more required parameters.

## #1 — preben, 2009-11-01T08:51Z

```
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;

Permalänk: https://www.webforum.nu/p/181021

## #2 — preben, 2009-11-01T09:24Z

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

Inte heller denna fungerar...:

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

Permalänk: https://www.webforum.nu/p/2210078

## #3 — preben, 2009-11-01T09:37Z

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

Permalänk: https://www.webforum.nu/p/2210080

## #4 — preben, 2009-11-01T11:19Z

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!

Permalänk: https://www.webforum.nu/p/2210081

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/181021-no-value-given-for-one-or-more-required-parameters