attaching these values(i mean checkbox values) in the Prev and Next Navigation links...
please show your code so that someone here can suggest you a solution...
Thanks
-SecondToNone
...name= request.form("name")
email = request.form("email")
country = request.form("country")
'Connection String is here
strSQL = "Select * from yourtable where name='"&name&"' AND email='"&email&"' AND country='"&country&"' "
rs=con.execute(strSQL)
if rs.EOF AND rs.BOF then...
SUM(yourcolumn) - gives the sum of all the values in the column
Count(yourcolumn) - gives the count of all the values in the column
then you can easily get the average from these two numbers...
or i guess you can use the AVG() function...
-SecondToNone
try using a session variable to persist the value of username...something like this...
Session("username")=Request.form("username")
now you have this Session("username") variable available throughout the session..
-SecondToNone
Try this:
once the user enters both the dates save these values to two session variables...
Session("start_date")=Request.Form("start_date")
Session("end_date")=Request.Form("end_date")
then check on these check variables...when the results are displayed for the first time and user just wants...
i think you are doing the other way round...
when you first stated your logic...you wanted to add days if your Date800 field is NOT null...in the above query you are doing the opposite...
-SecondToNone
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.