(register_date = '10/1/2005')
You can also use the CFQUERYPARAM CFSQLTYPE=CF_SQL_DATE
VALUE=10/1/2005
-Original Message-
From: Tim Laureska [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 05, 2006 11:57 AM
To: CF-Talk
Subject: greater than date query ?
Trying to setup a where
Have you tried either of these?
Where (register_date = #createodbcdate('10/1/2005')#)
Or
Where (register_date = #createodbcdatetime('10/1/2005')#)
..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: Tim Laureska
Thanks all for the reponses!
Tim
-Original Message-
From: Bobby Hartsfield [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 05, 2006 12:08 PM
To: CF-Talk
Subject: RE: greater than date query ?
Have you tried either of these?
Where (register_date = #createodbcdate('10/1/2005
3 matches
Mail list logo