Well getDate() is an SQL server function, so what error do you get ? If you simply mean the doesn't return data, then it could be because the comparison is not matching, i.e.
Dateadded = 12/01/2006 GetDate = 12/01/2005 09:46:00 Which would never be equal. Russ -----Original Message----- From: Richard Cooper [mailto:[EMAIL PROTECTED] Sent: 06 March 2006 17:01 To: CF-Talk Subject: getDate() Hi all, Does anyone know why this works in access but not in SQL Server <cfquery name="checkForView" datasource="#theDatabase#"> SELECT viewID, views FROM eventViews WHERE active = '1' AND eventID = '#theEventID#' AND dateAdded = getdate() </cfquery> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234264 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
