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
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
