Yep, that woke me up... now, I don't want this to turn into the scene from Airplane where they all get in line to smack that lady... 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:20:43 PM >>> *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 Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
