Can someone help me format this query so It accept input from the form text :) This is what I have so far
<html>
<body>
<form method="POST" action="temp02.asp">
<p><input type="text" name="txtBeginDate" size="20"></p>
<p><input type="text" name="txtEndDate" size="20"></p>
<p><input type="submit" value="Submit" name="B1"></p>
</form>
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "C:\Inetpub\wwwroot\butlerapp\database\data.md b"
set rs = Server.CreateObject("ADODB.recordset")
rs.Open "SELECT * FROM shippers WHERE date Between #10/23/2013# AND #11/1/2013#" , conn
do until rs.EOF
for each x in rs.Fields
Response.Write(x.name)
Response.Write(" = ")
Response.Write(x.value & "<br>")
next
Response.Write("<br>")
rs.MoveNext
loop
rs.close
conn.close
%>
</body>
</html>
Searching by date
