ASP Date Select

Post Reply

Page <12

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
michael Members Profile Find Members Posts Senior Member Joined: 08 April 2002 Location: United States Status: Offline Points: 4670	Post Options Post Reply Quote michael Report Post Thanks(0) Quote Reply Posted: 31 May 2003 at 8:57pm
	strSQL = "SELECT * FROM events WHERE [date] Between now() AND dateadd(""d"",7,now())" No need to mix asp; access know the dateadd function as well Edited by michael
	Blog \| MPG Tracker

phorne Members Profile Find Members Posts Newbie Joined: 18 May 2003 Location: United States Status: Offline Points: 23	Post Options Post Reply Quote phorne Report Post Thanks(0) Quote Reply Posted: 31 May 2003 at 9:10pm
	Nope - that code did not work either and page would not display at all... Do I need to go back and change the name of the date field to something other than date??

michael Members Profile Find Members Posts Senior Member Joined: 08 April 2002 Location: United States Status: Offline Points: 4670	Post Options Post Reply Quote michael Report Post Thanks(0) Quote Reply Posted: 31 May 2003 at 10:38pm
	Not if you keep it in []'s The code I wrote work 100% as I am using it myself successfully. You are doing something else wrong, or you use an old version of access that might not know the function.
	Blog \| MPG Tracker

phorne Members Profile Find Members Posts Newbie Joined: 18 May 2003 Location: United States Status: Offline Points: 23	Post Options Post Reply Quote phorne Report Post Thanks(0) Quote Reply Posted: 01 June 2003 at 5:11am
	Version of Access is 2000 All I am doing is taking the line of code that works: strSQL = "SELECT events.* FROM events where date >= Date() order by date;" and I cut and paste the code you guys have been sending me! (which I really appreciate!) I am using an Iframe to load the page - but I don't think that is the problem as the code works fine with the line above.... You can see the page at: http://www.midgachristian.com/index1.asp

phorne Members Profile Find Members Posts Newbie Joined: 18 May 2003 Location: United States Status: Offline Points: 23	Post Options Post Reply Quote phorne Report Post Thanks(0) Quote Reply Posted: 01 June 2003 at 5:19am
	Michael - I went back and put your code in again and get this error: Microsoft OLE DB Provider for ODBC Drivers error '80040e10' [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. /Events/display_select-test.asp, line 97 Thought it was because ther was no ";" at the end of the statement - added it in different places and then added an additional " - then the page would not display at all... Sure it is something I am doing but I have been banging my head for days with this!!

phorne Members Profile Find Members Posts Newbie Joined: 18 May 2003 Location: United States Status: Offline Points: 23	Post Options Post Reply Quote phorne Report Post Thanks(0) Quote Reply Posted: 01 June 2003 at 5:49am
	PROBLEM SOLVED!!!!!!!! User on forum at http://www.haneng.com/ gave me the code: strSQL = "select * from events where date >= Date() and (( Date <= #"&DateAdd("d",7,date)&"#)) order by date;" This works great!!!! Now I am wondering if I can change the number of days to add with a variable a user can select to view a different number of days??

Post Reply	Page <12

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum