Re: data filteren via SQL

Article View: be.comp.programming

Article #13776

Back to be.comp.programming Previous Next

#13776

From: Jackie Cane
Date: Thu, 24 May 2001 09:24

26 lines
2120 bytes

"Daffy Duck" <jjj@planetinternet.be> wrote in message
news:3b0c3027$0$3124$456d72a3@news.skynet.be...
> Ik zou graag gegevens filteren tussen 2 datums via SQL.
> Ik heb onderstaande code geschreven, maar ik krijg deze error:
> Run-time error '-2147217900(80040e14)':
> [Microsoft][ODBC SQL Server Drive] [SQL Server] Line 1:
> Incorrect syntax near '#'
>
> Private Sub Command1_Click()
>   Dim db As New ADOdb.Connection
>   Dim adoPrimaryRS as New ADOdb.RecordSet
>   db.CursorLocation = adUseClient
>   db.Open "PROVIDER=MSDASQL;driver={SQL
> Server};server=PC2;uid=sa;pwd=;database=sampleSQL6;"
> Dim sql1 As String
> sql1 = "select * from tblSamples WHERE LoginDate BETWEEN #" &
> CDate(Text1.Text) & "# AND #" & CDate(Text2.Text) & "#"
>

ik dacht dat de juiste syntax devolgende is :
"select * from tblSamples WHERE LoginDate BETWEEN '#" & CDate(Text1.Text) &
"#' AND '#" & CDate(Text2.Text) & "#'"

dus vb  :  where date > '#05/05/01#'

Groetjes !

Technical Details

Message-ID: <Cr4P6.10106$FL1.979786@afrodite.telenet-ops.be>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-03!supernews.com!mtu.ru!news-out.nuthinbutnews.com!propagator!feed2.newsfeeds.com!newsfeeds.com!news-in-austin.nuthinbutnews.com!isdnet!newsgate.cistron.nl!newsfeeds.belnet.be!news.belnet.be!afrodite.telenet-ops.be!not-for-mail

References: <3b0c3027$0$3124$456d72a3@news.skynet.be>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fcea4,55004f7176a513c1
X-Google-Attributes: gidfcea4,public
X-Google-ArrivalTime: 2001-05-24 02:26:18 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-03!supernews.com!mtu.ru!news-out.nuthinbutnews.com!propagator!feed2.newsfeeds.com!newsfeeds.com!news-in-austin.nuthinbutnews.com!isdnet!newsgate.cistron.nl!newsfeeds.belnet.be!news.belnet.be!afrodite.telenet-ops.be!not-for-mail
From: "Jackie Cane" <JackieCane@nowhere.land>
Newsgroups: be.comp.programming
References: <3b0c3027$0$3124$456d72a3@news.skynet.be>
Subject: Re: data filteren via SQL
Lines: 30
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
Message-ID: <Cr4P6.10106$FL1.979786@afrodite.telenet-ops.be>
Date: Thu, 24 May 2001 09:24:50 GMT
NNTP-Posting-Host: 213.224.26.236
X-Complaints-To: abuse@pandora.be
X-Trace: afrodite.telenet-ops.be 990696290 213.224.26.236 (Thu, 24 May 2001 11:24:50 MET DST)
NNTP-Posting-Date: Thu, 24 May 2001 11:24:50 MET DST
Organization: Telenet Internet

Reply to Parent Message