Kinky!
-- Ben Doom
Programmer & General Lackey
Moonbow Software, Inc
: -----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
