Last post Sep 05, 2013 02:34 PM by EvgenKa
Sep 05, 2013 01:29 PM|EvgenKa|LINK
please tell me what
you need to add a string to
in the past 3 days?))
var selectQueryString = "SELECT * FROM NEWS ORDER BY Date";
new to this, so much
not yet understand))
Sep 05, 2013 01:44 PM|A2H|LINK
Assuming you have a column with name"Date"
Please try with the below query
SELECT * FROM NEWS where [Date] >= dateadd(d,-3,getdate()) ORDER BY [Date]
Sep 05, 2013 01:51 PM|EvgenKa|LINK
longer displays any article
Sep 05, 2013 02:06 PM|A2H|LINK
I was able to get the results properly.
Please find the query which I tried
SELECT * FROM TestTable where [DateColumn] >= dateadd(d,-3,getdate()) ORDER BY [DateColumn] desc
Change the TableName and DateColumn as per your table and column name.
Sep 05, 2013 02:34 PM|EvgenKa|LINK
like works. Let's see what
will happen next)))
very big thank you))