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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
