---
title: "Nya id:iet i samma post blir fel!"
type: "forum-thread"
url: "https://www.webforum.nu/amne/asp/60538-nya-id-iet-i-samma-post-blir-fel"
topic: "ASP"
topic_url: "https://www.webforum.nu/amne/asp"
author: "crisse6"
published: "2002-11-28T20:35:44.000Z"
updated: "2002-11-28T20:47:46.000Z"
replies: 3
views: 219
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/asp/60538-nya-id-iet-i-samma-post-blir-fel"
---

# Nya id:iet i samma post blir fel!

## #1 — crisse6, 2002-11-28T20:35Z

Hej!

Forsoker fora in det nya id:iet som skapades i samma post men i en annan kolumn. Forsokte med denna koden, men det funkar ej, far "Oavslutad strang.. (eller liknande)"

```
[red]
sql = "Insert into t_threads (f_title, f_dte, f_user, f_latest, f_by, f_answers, f_text, forumID) VALUES ('" & request.form("title") & "',#" & Datum &"#, 'crisse6', '" & Datum &"', 'crisse6', '0', '" & request.form("text") & "', '" & request.querystring("forumID") &"');SELECT @@IDENTITY
rs = objConn.execute(sql).NextRecordSet
intNewID=rs(0) 
sql3 = "update t_threads SET svarID = "& intNewID &" Where threadID = "& intNewID
objConn.execute sql3,,128
```

Taclsam for hjalp!

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

## #2 — mikul, 2002-11-28T20:41Z

Detta borde funka:

```
[red]sql = "Insert into t_threads (f_title, f_dte, f_user, f_latest, f_by, f_answers, f_text, forumID) VALUES ('" & request.form("title") & "',#" & Datum &"#, 'crisse6', '" & Datum &"', 'crisse6', '0', '" & request.form("text") & "', '" & request.querystring("forumID") &"');SELECT @@IDENTITY
objConn.execute sql,,128

Set rs = objConn.Execute "SELECT @@Identity" 

sql = "update t_threads SET svarID = "& rs(0) &" Where threadID = "& intNewID
rs.Close : Set rs = Nothing
objConn.execute sql,,128
[/red]
```

Tror dock att det finns nåt bättre sätt.

/ Mikul

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

## #3 — LarsG, 2002-11-28T20:41Z

Access?

```
sql = "Insert into t_threads (f_title, f_dte, f_user, f_latest, f_by, f_answers, f_text, forumID) " & _
" VALUES ('" & request.form("title") & _
"',#" & Datum &"#, 'crisse6', #" &_
Datum &"#, 'crisse6', '0', '" & request.form("text") & _
"', '" & request.querystring("forumID") &"')"
objConn.execute sql,,128
set rs = objConn.execute("SELECT @@IDENTITY")
intNewID=rs(0) 
sql3 = "update t_threads SET svarID = "& intNewID &" Where threadID = "& intNewID
objConn.execute sql3,,128
```

Det går inte att utföra flera satser i samma anrop i Access.

(Du hade glömt en avslutande " )

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

## #4 — crisse6, 2002-11-28T20:47Z

Ta det lugnt killar!! Hinner ju inte uppdatera innan det ar 2 svar, jesus! Aggresiva eller? Hahahha! Funkar kanon, tog din kod LarsG, inget illa menat till dig Mikul, men LarsG har ju ett visst rykte har pa wF! 

Tack igen for sa snabbt svar!!!

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

---

Tråden på webben: https://www.webforum.nu/amne/asp/60538-nya-id-iet-i-samma-post-blir-fel