Re: Waarom werkt die ADO rommel niet met datums?

Article View: be.comp.programming

Article #16352

Back to be.comp.programming Previous Next

#16352

From: SLE
Date: Sat, 13 May 2000 00:00

14 lines
1059 bytes

"YvanS" <Someone@Microsoft.com> wrote in message
news:noHS4.25784$oI2.60083@afrodite.telenet-ops.be...
> sprintf(SQLstatement,"select * from agenda where when = #%s# and owner
like
> '%s'",tijd.Format("%m/%d/%Y %H:%M:%S"),m_owner);
>     when is een date/time in een access db.
>     tijd is een COleDateTime
>

de sql standard kent enkel american date/time values, probeer dit eens:

sprintf(SQLstatement,"select * from agenda where when = #%s# and owner like
'%s'",tijd.Format("%Y/%m/%d %H:%M:%S"),m_owner);

Technical Details

Message-ID: <8fjnqs$nam$1@trex.antw.online.be>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <noHS4.25784$oI2.60083@afrodite.telenet-ops.be>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fcea4,24300c020b69cdd7
X-Google-Attributes: gidfcea4,public
From: "SLE" <fake@mail.com>
Subject: Re: Waarom werkt die ADO rommel niet met datums?
Date: 2000/05/13
Message-ID: <8fjnqs$nam$1@trex.antw.online.be>
X-Deja-AN: 622938143
References: <noHS4.25784$oI2.60083@afrodite.telenet-ops.be>
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
Organization: Customer of Online Internet
X-MSMail-Priority: Normal
Newsgroups: be.comp.programming

Reply to Parent Message