Article View: be.comp.programming
Article #4900Re: syntaxfout
From: Rollo Tomasi
Date: Mon, 30 Jun 2003 09:20
Date: Mon, 30 Jun 2003 09:20
28 lines
1815 bytes
1815 bytes
Theo wrote:
> "Mathias Vissers" <matje008@hotmail.com> wrote in message
> news:ocYKa.2872$P26.5420@afrodite.telenet-ops.be...
>> Hallo,
>>
>> mijn asp-code geeft altijd de melding syntax-fout, terwijl ik totaal
>> geen fout terugvindt in mijn lijn.
>>
>> sql = "INSERT INTO message (Time,From,Message,Read) Values ('" &
>> TimeValue(now()) & "', '" & nummer & "', '" & tekst & "', false)"
>> conn.execute(sql)
>>
>> Time: tijd/datum veld
>> From: tekst
>> Message: tekst
>> Read: boolean
>>
>> Database is een access-datebase
>
> "From" is een reserved word.
>
> Theo
Time ook.
--
Rollo Tomasi
Technical Details
Message-ID:
<ghTLa.6467$S%1.724622366@hestia.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!newsfeed.news2me.com!aotearoa.belnet.be!news.belnet.be!ossa.telenet-ops.be!hestia.telenet-ops.be.POSTED!not-for-mailReferences:
<ocYKa.2872$P26.5420@afrodite.telenet-ops.be> <3efd7eb0$0$147$e4fe514c@dreader9.news.xs4all.nl>Show Full Headers
Complete Article Headers
X-Google-Language: DUTCH,ASCII-7-bit X-Google-Thread: 107324,b305f58fa980c7d7 X-Google-Attributes: gid107324,public X-Google-Thread: fcea4,b305f58fa980c7d7 X-Google-Attributes: gidfcea4,public X-Google-ArrivalTime: 2003-06-30 02:28:34 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!newsfeed.news2me.com!aotearoa.belnet.be!news.belnet.be!ossa.telenet-ops.be!hestia.telenet-ops.be.POSTED!not-for-mail From: "Rollo Tomasi" <nospam@anyhost.com> Newsgroups: be.comp.programming,nl.comp.programmeren References: <ocYKa.2872$P26.5420@afrodite.telenet-ops.be> <3efd7eb0$0$147$e4fe514c@dreader9.news.xs4all.nl> Subject: Re: syntaxfout Lines: 30 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Message-ID: <ghTLa.6467$S%1.724622366@hestia.telenet-ops.be> Date: Mon, 30 Jun 2003 09:20:12 GMT NNTP-Posting-Host: 81.82.97.244 X-Complaints-To: abuse@telenet.be X-Trace: hestia.telenet-ops.be 1056964812 81.82.97.244 (Mon, 30 Jun 2003 11:20:12 CEST) NNTP-Posting-Date: Mon, 30 Jun 2003 11:20:12 CEST Organization: Telenet Internet