[SQL] fout in Update opdracht

Article View: be.comp.programming

Article #4880

Back to be.comp.programming Previous Next

#4880

From: YuGo
Date: Fri, 27 Jun 2003 13:06

21 lines
1781 bytes

Wat is er mis met deze SQL opdracht:

Update Members Set Name = 'Davy', Location = 'Brussel', Birthdate = '1980',
E-mail = 'xyz@microsoft.be', Url = 'www.yugo.be', Car = 'Citroen', Type =
'Saxo', Ice = 'Panasonic', Design = 'wimpers, spoiler, antenne, zonneband',
Others = 'vanalles' Where Login = 'test';

Dit commando zit in de string str en wordt dan met dit commando uitgevoerd:
cnnSimple.Execute(str)

Daarop geeft hij de fout:

Microsoft JET Database Engine (0x80040E14)
De instructie UPDATE bevat een syntaxisfout.
/change.asp, line 44

Ik kan de syntaxisfout maar niet vinden, de namen van de velden zijn juist.

Iemand die de fout ziet?

Alvast bedankt.

Technical Details

Message-ID: <ajXKa.2808$P26.5538@afrodite.telenet-ops.be>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed.icl.net!newsfeed.fjserv.net!kibo.news.demon.net!demon!aotearoa.belnet.be!news.belnet.be!ossa.telenet-ops.be!afrodite.telenet-ops.be.POSTED!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: DUTCH,ASCII-7-bit
X-Google-Thread: fcea4,a4319061def6cb6b,start
X-Google-Attributes: gidfcea4,public
X-Google-ArrivalTime: 2003-06-27 06:06:17 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed.icl.net!newsfeed.fjserv.net!kibo.news.demon.net!demon!aotearoa.belnet.be!news.belnet.be!ossa.telenet-ops.be!afrodite.telenet-ops.be.POSTED!not-for-mail
From: "_YuGo_" <yugo(geenspam)@pandora.be>
Newsgroups: be.comp.programming
Subject: [SQL] fout in Update opdracht
Lines: 23
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <ajXKa.2808$P26.5538@afrodite.telenet-ops.be>
Date: Fri, 27 Jun 2003 13:06:14 GMT
NNTP-Posting-Host: 213.119.19.52
X-Complaints-To: abuse@telenet.be
X-Trace: afrodite.telenet-ops.be 1056719174 213.119.19.52 (Fri, 27 Jun 2003 15:06:14 MET DST)
NNTP-Posting-Date: Fri, 27 Jun 2003 15:06:14 MET DST
Organization: Telenet Internet