I suspect that's more your brain seeing what you wanted to see, not what your eyes where sending to it. Happens to me all the time. Sometimes you just need to get somebody else to look at it without any expectations so that they see what is actually there. I've wasted hours and days over things like this.
-------------- Ian Skinner Web Programmer BloodSource Sacramento, CA -----Original Message----- From: Candace Cottrell [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 11:19 AM To: CF-Community Subject: Re: Date quickie Ever hear the expression "can't see the forest for the trees..."? Story of my life... Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] >>> [EMAIL PROTECTED] 6/4/2003 2:08:01 PM >>> Because you are looking at dates less than or equal to today? Jerry Johnson >>> [EMAIL PROTECTED] 06/04/03 02:00PM >>> Any idea why this where clasue is bombing? The expDates in the database are 6/30/2003 and 7/1/2003, yet no records are returning. The MS-SQL datatype for the field is datetime. <cfquery name="getAnnouncements" datasource="#Request.DSN#"> SELECT * FROM Announcements WHERE Announcements.AnnouncementExpDate <= <cfqueryparam cfsqltype="cf_sql_date" value="#DateFormat(Now(),'m/d/yyyy')#"> ORDER BY Announcements.AnnouncementStartDate </cfquery> Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=5 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=5 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
