---

Denne kode

Dim oConn

Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open Session("ADMIN")

strSQL = "INSERT INTO tblArticle (ArticleListOrder) VALUES (" & intOp & ")
WHERE ArticleID = " & intArticleID & " ; "
oConn.Execute(strSQL)

giver følgende fejl (linie 84 er *** oConn.Execute(strSQL) ***)

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Missing semicolon (;) at end of
SQL statement.
/1950/www/admin/article.asp, line 84


Hvad går der galt ? (det er en access 2000 db)

--

Mvh / Regards
-=< Christian >=-
What capital has 164 letters in its name? See my web page to find out.
http://www.cmnielsen.dk ICQ: 25308942
" If something's hard to do, then it's not worth doing. Homer J. Simpson"

---

en response.write strSQL giver dette resultat:


INSERT INTO tblArticle (ArticleListOrder) VALUES (3) WHERE ArticleID =
337 ;


--

Mvh / Regards
-=< Christian >=-
What capital has 164 letters in its name? See my web page to find out.
http://www.cmnielsen.dk ICQ: 25308942
" If something's hard to do, then it's not worth doing. Homer J. Simpson"

---

"Christian M. Nielsen" <look_for_it@my.webpage> wrote in message
news:bccqai$g5i$1@sunsite.dk...

> Error Type:
> Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
> [Microsoft][ODBC Microsoft Access Driver] Missing semicolon (;) at end of
> SQL statement.
> /1950/www/admin/article.asp, line 84
>
Drop semikolon helt...

mvh/Peter Lykkegaard

---

"Peter Lykkegaard" <polonline@hot.mail.com> wrote in message
news:lgoGa.953$842.238@news.get2net.dk...

> Drop semikolon helt...

Det giver ingen forskel

Stadig denne fejlmeddelelse

[Microsoft][ODBC Microsoft Access Driver] Missing semicolon (;) at end of
SQL statement.

--

Mvh / Regards
-=< Christian >=-
What capital has 164 letters in its name? See my web page to find out.
http://www.cmnielsen.dk ICQ: 25308942
" If something's hard to do, then it's not worth doing. Homer J. Simpson"