---
title: "Korkar update fel?!"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/85627-korkar-update-fel"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "ConnyFox"
published: "2003-09-09T22:29:18.000Z"
updated: "2003-09-09T23:00:10.000Z"
replies: 2
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/85627-korkar-update-fel"
---

# Korkar update fel?!

## #1 — ConnyFox, 2003-09-09T22:29Z

hmm får fel på detta o vet inte varför..

```
mysql = "update ip set ipantal = ipantal + 1 set ipdatum = '" & now & "' where ip = '" & ip & "'"
```

Felmeddelande : 

```
Feltyp:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[MySQL][ODBC 3.51 Driver][mysqld-4.0.14-nt]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 'set ipdatum = '2003-09-10 00:26:14' where ip = '127.0.0.1'' at 
/mysql/top.asp, line 58

Webbläsare:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; MyIE2) 

Sida:
POST 47 bytes to /mysql/top.asp
```

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

## #2 — LarsG, 2003-09-09T22:39Z

```
mysql = "update ip set ipantal = ipantal + 1, ipdatum = '" & now & "' where ip = '" & ip & "'"
```

Flyttas från ASP

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

## #3 — ConnyFox, 2003-09-09T23:00Z

jasså det e så d funkar! tack

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

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/85627-korkar-update-fel