On Tue, 28 Aug 2001 09:06:15 +0800, "Kay Smoljak" <[EMAIL PROTECTED]>
wrote:
>Sorry for what is undoubtably a basic question, but I've been spoilt
>with SQL Server. I'm trying to insert a date into an Access database.
>The parts of the date have been split into their day, month and year
>componen
der, Jason
To: CF-Talk
Sent: Tuesday, August 28, 2001 10:13 AM
Subject: RE: Dates in Access
It seems that normally in Access and with ASP (VBScript) you access date fields with
# signs around the value. For some reason ColdFusion doesn't like it when I do that.
What I do is to us
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 28, 2001 2:56 AM
To: CF-Talk
Subject: Re: Dates in Access
On 8/28/01, Kay Smoljak penned:
>Sorry for what is undoubtably a basic question, but I've been spoilt
>with SQL Server. I'm trying to insert a date into an Access da
On 8/28/01, Kay Smoljak penned:
>Sorry for what is undoubtably a basic question, but I've been spoilt
>with SQL Server. I'm trying to insert a date into an Access database.
>The parts of the date have been split into their day, month and year
>components - and #createdate(form.year,form.month,form
Hi all,
Sorry for what is undoubtably a basic question, but I've been spoilt
with SQL Server. I'm trying to insert a date into an Access database.
The parts of the date have been split into their day, month and year
components - and #createdate(form.year,form.month,form.day)# is throwing
a very u
Why would this query run OK in Access 2000, yet not work when pasted into a
ColdFusion template (with the #2/1/01#s changed to CreateODBCDate() values)?
SELECT t.Tank,
Iif((SELECT wr.Closing
FROM WetstockRecords wr
WHERE wr.WetstockRecordTypeID = 2
AND wr.TankID = 133
6 matches
Mail list logo
