---
title: "Flera \"OR\""
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/78995-flera-or"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "SteveP"
published: "2003-06-05T22:00:33.000Z"
updated: "2003-06-05T22:05:06.000Z"
replies: 3
views: 179
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/78995-flera-or"
---

# Flera "OR"

## #1 — SteveP, 2003-06-05T22:00Z

Detta är min query för en enkel sökning

```
SQL = "Select *, (SELECT COUNT(*) FROM DollsGuestBook "&_
"Where DollsGuestBook.Inlagg Like '%" & sok & "%' "&_
"OR DollsGuestBook.Rubrik LIKE '%" & sok & "%') "&_
"AS soktraffar from DollsGuestBook "&_
"Where DollsGuestBook.Inlagg Like '%" & sok & "%' "&_
"OR DollsGuestBook.Rubrik LIKE '%" & sok & "%' "
```

Om jag nu försöker lägga till ännu en rad med  OR så får jag Incorrect syntax near the keyword 'OR'. 

```
SQL = "Select *, (SELECT COUNT(*) FROM DollsGuestBook "&_
"Where DollsGuestBook.Inlagg Like '%" & sok & "%' "&_
"OR DollsGuestBook.Rubrik LIKE '%" & sok & "%') "&_
"OR DollsGuestBook.Skribent LIKE '%" & sok & "%') "&_
"AS soktraffar from DollsGuestBook "&_
"Where DollsGuestBook.Inlagg Like '%" & sok & "%' "&_
"OR DollsGuestBook.Rubrik LIKE '%" & sok & "%' "&_
"OR DollsGuestBook.Skribent Like '%" & sok & "%' "
```

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

## #2 — Peeer, 2003-06-05T22:02Z

Du har en ')' för mycket. Tog bort en av dem, vet dock inte om det var rätt :)

```
SQL = "Select *, (SELECT COUNT(*) FROM DollsGuestBook "&_
"Where DollsGuestBook.Inlagg Like '%" & sok & "%' "&_
"OR DollsGuestBook.Rubrik LIKE '%" & sok & "%' "&_
"OR DollsGuestBook.Skribent LIKE '%" & sok & "%') "&_
"AS soktraffar from DollsGuestBook "&_
"Where DollsGuestBook.Inlagg Like '%" & sok & "%' "&_
"OR DollsGuestBook.Rubrik LIKE '%" & sok & "%' "&_
"OR DollsGuestBook.Skribent Like '%" & sok & "%' "
```

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

## #3 — SteveP, 2003-06-05T22:04Z

Ah sedär, klantigt av mig.
Tack!

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

## #4 — Peeer, 2003-06-05T22:05Z

Så lite så :)

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

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/78995-flera-or