>WHERE > NewsBySection.sectionID = '13' <!--- is this a char/varchar? ---> > AND News.startDate = <cfqueryparam value="#daterequestAdd#" >cfsqltype="cf_sql_date" /> > AND News.endDate >= <cfqueryparam value="#daterequestAdd#" >cfsqltype="cf_sql_date" /> > AND News.archive = 0 > >* depending on your datatype, that cfsqltype might need to be changed to >cf_sql_timestamp > >On Thu, Jul 31, 2008 at 12:02 PM, Robert Newhart ><[EMAIL PROTECTED]>wrote: > >>
The NewsBySection.sectionID = '13' is an INT in the table. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310021 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4