It is a connection to an Access Database. strSQLstring = "SELECT * FROM tblNews WHERE Newsdate = between date30daysago and datenow ORDER by NewsDate DESC"
-----Original Message----- From: Ian Payne [mailto:[EMAIL PROTECTED] Sent: Friday, February 11, 2005 8:01 AM To: [email protected] Subject: RE: [AspNetAnyQuestionIsOk] strSQLstring = "SELECT * FROM tblNews WHERE Newsdate = between date30daysago and date now ORDER by NewsDate DESC" What db are you using? -----Original Message----- From: Mike Belcher [mailto:[EMAIL PROTECTED] Sent: 10 February 2005 23:22 To: [email protected] Subject: [AspNetAnyQuestionIsOk] strSQLstring = "SELECT * FROM tblNews WHERE Newsdate = between date30daysago and date now ORDER by NewsDate DESC" I have a news database that when displayed I want to list the articles from the current date to 30 days ago. How can this be done with a SQL String... strSQLstring = "SELECT * FROM tblNews WHERE Newsdate = between date30daysago and date now ORDER by NewsDate DESC" that is what I am trying to accomplish.......... Mike Belcher Yahoo! Groups Links Yahoo! Groups Links Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
