/ Forside / Teknologi / Udvikling / ASP / Nyhedsindlæg
Login
Glemt dit kodeord?
Brugernavn

Kodeord


Reklame
Top 10 brugere
ASP
#NavnPoint
smorch 9259
Harlekin 1866
molokyle 1040
Steffanst.. 758
gandalf 657
smilly 564
gibson 560
cumano 530
MouseKeep.. 480
10  Random 410
Missing semicolon?
Fra : Quinn


Dato : 01-12-02 01:58

I have programmed ASP with MS Access for quite a while but I've never seen
this one before:

-----

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

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

------

Here is my code:

MYSTRING = "INSERT INTO Maal VALUES (spiller_id, lag_id, kamp_id, tid, str)
VALUES (1,1,1,1,1)"

Con.Execute( MYSTRING )

All the fields in the table are "number"s.

Can anyone help me?

Quinn



 
 
Kasper Katzmann (01-12-2002)
Kommentar
Fra : Kasper Katzmann


Dato : 01-12-02 10:29

> I have programmed ASP with MS Access for quite a while but I've never
> seen this one before:
>
> Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
>
> [Microsoft][ODBC Microsoft Access Driver] Missing semicolon (;) at
> end of SQL statement.

> MYSTRING = "INSERT INTO Maal VALUES (spiller_id, lag_id, kamp_id,
> tid, str) VALUES (1,1,1,1,1)"
>
> Con.Execute( MYSTRING )

Maybe you're trying to insert in a table where you should use update
instead??
I had the same problem for a couple af days ago. I made that mistake and got
that error.


--
Mvh
Kasper K
---------------------------------
Find en masse gode svar på de spørgsmål
der oftest stilles i nyhedsgruppen d.e.i.w.s.a
http://www.asp-faq.dk



Ras (01-12-2002)
Kommentar
Fra : Ras


Dato : 01-12-02 20:59

> Here is my code:
>
> MYSTRING = "INSERT INTO Maal VALUES (spiller_id, lag_id, kamp_id, tid,
str)
> VALUES (1,1,1,1,1)"
>
> Con.Execute( MYSTRING )
>
> All the fields in the table are "number"s.
>
> Can anyone help me?

Maybe it`s where you connect...?
ex.
Con.Open "DRIVER={Microsoft Access Driver (*.mdb)}; <<= = =

If there is no semicolon it will fail.

- Ras.



Søg
Reklame
Statistik
Spørgsmål : 177552
Tips : 31968
Nyheder : 719565
Indlæg : 6408849
Brugere : 218887

Månedens bedste
Årets bedste
Sidste års bedste