---
title: "AND ... OR"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/136456-and-or"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "Eclipse"
published: "2005-10-26T20:03:10.000Z"
updated: "2005-10-26T20:43:16.000Z"
replies: 2
views: 204
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/136456-and-or"
---

# AND ... OR

## #1 — Eclipse, 2005-10-26T20:03Z

Osäker på datumet. Access + asp.

```
' ## LOAD ALL POSTS TO GUESTBOOK
FUNCTION funcLoadAllInGuestbook()
	' ## 2. QUESTION
	SQL = "SELECT g.intID, g.strName, g.dteCreated, g.strText, g.strSignature, g.intCounter, g.bolURL " _
	& ", ( SELECT COUNT(*) FROM comments c WHERE c.intGuestbookID = g.intID ) " _
	& " FROM [guestbook] g WHERE [b](g.bolView = TRUE OR " _
	& " g.dteCreated = format(g.dteCreated, 'short date') = #" & date() & "#)[/b] ORDER BY g.dteCreated DESC;"
response.write SQL
	set mySQL = Conn.Execute(SQL)
	IF NOT mySQL.EOF THEN application("myGuestbook") = mySQL.GetRows() ELSE application("myGuestbook") = ""
END FUNCTION
```

response.write =
SELECT g.intID, g.strName, g.dteCreated, g.strText, g.strSignature, g.intCounter, g.bolURL , ( SELECT COUNT(\*) FROM comments c WHERE c.intGuestbookID = g.intID ) FROM \[guestbook\] g WHERE  *(g.bolView = TRUE OR g.dteCreated = format(g.dteCreated, 'short date') = #2005-10-26#)* ORDER BY g.dteCreated DESC;

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

## #2 — Peter S, 2005-10-26T20:41Z

```
OR " _
	& " format(g.dteCreated, 'short date') = #" & date() & "#
```

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

## #3 — Eclipse, 2005-10-26T20:43Z

\*skäms\*

Tack...

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

---

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