I have the following mysql query that works fine in mysql:
Set @FirstDate = Date_Add(Now(),Interval -2 month);
Set @LastDate = Concat(Year(@x),'-',Month(@x),'4');
Select Assignment.Name, Assignment.ID, Assignment.DueDate, Assignment.Description, Assignment.Grade, Assignment.CharCount, Assignment.CompletedDate, Assignment.Class, Students.FullName from Assignment Left Join Students On Assignment.ID = Students.ID Where Date(Assignment.Completed) >= Date(@lastdate) AND Date(Assignment.Completed) < Date(Date_Add(@Lastdate,Interval 1 Month))
My question is how do I write the same query in ASP? I already have the connection string, i just need to know how do I write this query in ASP. Thanks and any help is appreciated!
Set @FirstDate = Date_Add(Now(),Interval -2 month);
Set @LastDate = Concat(Year(@x),'-',Month(@x),'4');
Select Assignment.Name, Assignment.ID, Assignment.DueDate, Assignment.Description, Assignment.Grade, Assignment.CharCount, Assignment.CompletedDate, Assignment.Class, Students.FullName from Assignment Left Join Students On Assignment.ID = Students.ID Where Date(Assignment.Completed) >= Date(@lastdate) AND Date(Assignment.Completed) < Date(Date_Add(@Lastdate,Interval 1 Month))
My question is how do I write the same query in ASP? I already have the connection string, i just need to know how do I write this query in ASP. Thanks and any help is appreciated!