Re: syntaxfout

Article View: be.comp.programming

Article #4887

Back to be.comp.programming Previous Next

#4887

From: Theo
Date: Sat, 28 Jun 2003 11:40

21 lines
1636 bytes

"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

Technical Details

Message-ID: <3efd7eb0$0$147$e4fe514c@dreader9.news.xs4all.nl>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-06!sn-xit-08!supernews.com!mtu.ru!image.surnet.ru!news1.spb.su!news.telebyte.nl!newshub1.home.nl!home.nl!skynet.be!skynet.be!transit.news.xs4all.nl!newsfeed.xs4all.nl!xs4all!newszilla.xs4all.nl!not-for-mail

References: <ocYKa.2872$P26.5420@afrodite.telenet-ops.be>

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-28 04:40:37 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-06!sn-xit-08!supernews.com!mtu.ru!image.surnet.ru!news1.spb.su!news.telebyte.nl!newshub1.home.nl!home.nl!skynet.be!skynet.be!transit.news.xs4all.nl!newsfeed.xs4all.nl!xs4all!newszilla.xs4all.nl!not-for-mail
From: "Theo" <theo_asma.nothere@hotmail.com>
Newsgroups: be.comp.programming,nl.comp.programmeren
References: <ocYKa.2872$P26.5420@afrodite.telenet-ops.be>
Subject: Re: syntaxfout
Date: Sat, 28 Jun 2003 13:40:46 +0200
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Lines: 23
Message-ID: <3efd7eb0$0$147$e4fe514c@dreader9.news.xs4all.nl>
NNTP-Posting-Host: 213.84.150.170
X-Trace: 1056800432 dreader9.news.xs4all.nl 147 213.84.150.170:45717

Reply to Parent Message