I do not know if this helps, but, when I am looking for SQL insights, I go to http://www.sqlteam.com/
Good SQL Server Resource link with many forums, there is usually a thread about the problem I am trying to resolve. Good luck, Mike -----Original Message----- From: Tyler Silcox [mailto:[EMAIL PROTECTED]] Sent: Friday, December 14, 2001 9:02 AM To: CF-Talk Subject: OT: I need a good MS-SQL list>>> Can someone recommend a good SQL (MS-SQL preferred) list? I'm trying to get a date query working, and it's not quite living up to it's part of the bargain. The following is what I'm using, if anyone here has a quick resolution, please email me off-list ([EMAIL PROTECTED]) thanks-> <!--- i get all the emails older than 30 days that you have already read ---> <cfquery name="getOldEmail" datasource="#request.datasource#"> SELECT pop_store_id FROM pop_store WHERE date_created < #CreateODBCDateTime(CreateTimeSpan(-30, 0, 0, 0) + Now())# AND unread = 0 </cfquery> (just trying to get all the emails that are older than 30 days, and I thought that all I needed to do was throw a Less Than operator into the mix...) Tyler ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists