-Original Message-
From: Paige Chandler [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 20, 2001 11:06 PM
To: CF-Talk
Subject: Selecting on dates
Hi All,
The following function works great for displaying a date, but StartVisit
isn't found when trying to compare it in a Select statement. I'd
Original Message -
From: "Jim McAtee" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Sunday, January 21, 2001 1:40 AM
Subject: Re: Selecting on dates
There are three CreateODBC functions, CreateODBCDate(),
CreateODBCDateTime(),
and CreateODBCTime(). Which one yo
Hi All,
The following function works great for displaying a date, but StartVisit isn't found
when trying to compare it in a Select statement. I'd really appreciate an example of
the correct syntax to use. TIA.
Regards,
Paige
Select *
From WebSite
WHERE StartDate GT
Message-
From: Paige Chandler [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Saturday, January 20, 2001 9:03 PM
Subject: Selecting on dates
Hi All,
The following function works great for displaying a date, but StartVisit isn't
found when trying to compare it in a Select statement. I'd
11:13 PM
Subject: Re: Selecting on dates
It might be safer to use an ODBC formatted date. Depends on the database.
Also,
I'm not sure what happens to your 'GT' operator (does CF translate it?),
but SQL
usually uses operators like , =, , =, =, .
SELECT *
FROM WebSite
WHERE StartDate #Creat
2000.
SELECT *
FROM WebSite
WHERE StartDate = #CreateODBCDate(StartVisit)#
Jim
-Original Message-
From: Paige Chandler [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Saturday, January 20, 2001 10:04 PM
Subject: Re: Selecting on dates
Hi Jim,
I've used 'GT' in other Select sta
.
-Original Message-
From: Paige Chandler [mailto:[EMAIL PROTECTED]]
Sent: January 21, 2001 00:09
To: CF-Talk
Subject: Re: Selecting on dates
Hi Jim,
I've used 'GT' in other Select statements successfully - but I'm not married
to it. The problem is that the field in the table is in the Date/Time format
7 matches
Mail list logo