---
title: "visa bara aktuella poster"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/158705-visa-bara-aktuella-poster"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "WebbisNet"
published: "2007-03-29T14:51:13.000Z"
updated: "2007-03-29T14:59:11.000Z"
replies: 1
views: 214
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/158705-visa-bara-aktuella-poster"
---

# visa bara aktuella poster

## #1 — WebbisNet, 2007-03-29T14:51Z

vill bara lista de poster där dagens datum är mindre än sistaDag

får bara
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

\[MySQL\]\[ODBC 3.51 Driver\]\[mysqld-4.0.25-max\]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '() \<= ''' at line 1

/jobb/Default.asp, line 67 
med denna kod

set jobbRS=objConn.Execute("SELECT \* from tblJobb where Date() \< '"& sistaDag &"'")

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

## #2 — LarsG, 2007-03-29T14:59Z

```
SELECT * from tblJobb where current_date < sistaDag
```

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

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/158705-visa-bara-aktuella-poster