Date? Smacking?... hmmm ;-) At 02:18 PM 6/4/2003 -0400, you wrote: >Ok, since that was such an idiotic error, you can smack me... > >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:07:08 PM >>> >Date and a quickie? Sure! > >Oh, wait... >You meant something else. :-( >I guess I'll try to help anyway. > >Just a guess, but if expDate is an expiration date, shouldn't you check >if >the expiration date is /after/ today instead of /before/? > > >-- Ben Doom > Programmer & General Lackey > Moonbow Software, Inc > >: -----Original Message----- >: From: Candace Cottrell [mailto:[EMAIL PROTECTED] >: Sent: Wednesday, June 04, 2003 2:00 PM >: To: CF-Community >: Subject: Date quickie >: >: >: 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
