On Thu, Jul 31, 2008 at 12:27 PM, Robert Newhart <[EMAIL PROTECTED]>wrote:
> >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. > in that case, it shouldn't have single quotes around it. NewsBySection.sectionID = 13 is it currently working with the single quotes? -- A byte walks into a bar and orders a pint. Bartender asks him "What's wrong?" Byte says "Parity error." Bartender nods and says "Yeah, I thought you looked a bit off." ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:310023 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4