The hardest code to debug is the code that you wrote that is /almost/ right.
Part of the 80/20 rule in programming.
-- Ben Doom
Programmer & General Lackey
Moonbow Software, Inc
: -----Original Message-----
: From: Ian Skinner [mailto:[EMAIL PROTECTED]
: Sent: Wednesday, June 04, 2003 2:22 PM
: To: CF-Community
: Subject: RE: Date quickie
:
:
: 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
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
http://www.cfhosting.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
