*SMACK* Is that better?
M -----Original Message----- From: Candace Cottrell [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 2:18 PM To: CF-Community Subject: RE: Date quickie 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
