Forums
This topic is locked
Filter recordset by time ?
Posted 17 Nov 2002 10:33:49
1
has voted
17 Nov 2002 10:33:49 suhail kaleem posted:
Hi !i have date field in my acess db
now i want to filter recordset by time1 to time2 ?? how can i do that
any help
suhailkaleem
Replies
Replied 18 Nov 2002 09:35:06
18 Nov 2002 09:35:06 Vince Baker replied:
Use the SQL Between command.
Select *
FROM tablename
WHERE date BETWEEN time1 AND Time2
(If you are using MS Access you will need to do the following)
Select *
FROM tablename
WHERE date BETWEEN #time1# AND #Time2#
Regards
Vince
Response.write("The best line of code you can ever use"
VBScript | ASP | HTML | SQL | Oracle | Hosting
Select *
FROM tablename
WHERE date BETWEEN time1 AND Time2
(If you are using MS Access you will need to do the following)
Select *
FROM tablename
WHERE date BETWEEN #time1# AND #Time2#
Regards
Vince
Response.write("The best line of code you can ever use"

VBScript | ASP | HTML | SQL | Oracle | Hosting
Replied 18 Nov 2002 13:43:34
18 Nov 2002 13:43:34 suhail kaleem replied:
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Use the SQL Between command.
Select *
FROM tablename
WHERE date BETWEEN time1 AND Time2
(If you are using MS Access you will need to do the following)
Select *
FROM tablename
WHERE date BETWEEN #time1# AND #Time2#
Regards
Vince
Response.write("The best line of code you can ever use"
VBScript | ASP | HTML | SQL | Oracle | Hosting
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
hi !
tried this it always give me empty recordset
<%
Recordset2__date1 = request.querystring("time1"
Recordset2__date2 = request.querystrinng("time2"
Recordset2__q = request.querystrinng("qid"
set Recordset2 = Server.CreateObject("ADODB.Recordset"
Recordset2.ActiveConnection = MM_nhs_STRING
Recordset2.Source = "SELECT * FROM answers WHERE Date_answered BETWEEN #" + Replace(Recordset2__date1, "'", "''"
+ "# AND #" + Replace(Recordset2__date2, "'", "''"
+ "# AND QID='" + Replace(Recordset2__q, "'", "''"
+ "'"
Recordset2.CursorType = 0
Recordset2.CursorLocation = 2
Recordset2.LockType = 3
Recordset2.Open()
Recordset2_numRows = 0
%>
Any help ?
suhailkaleem
Use the SQL Between command.
Select *
FROM tablename
WHERE date BETWEEN time1 AND Time2
(If you are using MS Access you will need to do the following)
Select *
FROM tablename
WHERE date BETWEEN #time1# AND #Time2#
Regards
Vince
Response.write("The best line of code you can ever use"

VBScript | ASP | HTML | SQL | Oracle | Hosting
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
hi !
tried this it always give me empty recordset
<%
Recordset2__date1 = request.querystring("time1"

Recordset2__date2 = request.querystrinng("time2"

Recordset2__q = request.querystrinng("qid"

set Recordset2 = Server.CreateObject("ADODB.Recordset"

Recordset2.ActiveConnection = MM_nhs_STRING
Recordset2.Source = "SELECT * FROM answers WHERE Date_answered BETWEEN #" + Replace(Recordset2__date1, "'", "''"



Recordset2.CursorType = 0
Recordset2.CursorLocation = 2
Recordset2.LockType = 3
Recordset2.Open()
Recordset2_numRows = 0
%>
Any help ?
suhailkaleem