RE: [KCFusion] DateDiff in SQL Query

2003-08-04 Thread Kory Bakken
,createODBCDate(now()))#' -Original Message-From: Robert [mailto:[EMAIL PROTECTED]Sent: Friday, August 01, 2003 11:03 PMTo: [EMAIL PROTECTED]Subject: [KCFusion] DateDiff in SQL Query I am running into a problem and I can't figure out why. I know i've had this problem before

Re: [KCFusion] DateDiff in SQL Query

2003-08-04 Thread Robert
To: [EMAIL PROTECTED] Sent: Monday, August 04, 2003 8:10 AM Subject: RE: [KCFusion] DateDiff in SQL Query You cannot treat CustomerEnrollmentDateas a CF Variable until you are outside of that query. The following where clause should get you what you need: WHERE

[KCFusion] DateDiff in SQL Query

2003-08-01 Thread Robert
I am running into a problem and I can't figure out why. I know i've had this problem before with using CF functions inside of SQL queries, but I can never remember what it was the last time that fixed it, so I wanted to post this query: CFQUERY name="getcustomers" DATASOURCE="x"SELECT

Re: [KCFusion] DateDiff in SQL Query

2003-08-01 Thread Adaryl Wakefield
to assign it a value before you use it in the DateDiff function, or did you already do that and it does not show up in your snippet?A. - Original Message - From: Robert To: [EMAIL PROTECTED] Sent: Friday, August 01, 2003 11:02 PM Subject: [KCFusion] DateDiff in SQL Query