Using Dreamweaver
Question 1, On my submit page1 I would like to filter using any of the criteria below within the select statement.
How can I filter the results on page 2 from any of the four criterias from page1 ? (in addition to the email a filter below ?
Question 2, I am also passing the request.form values from each criteria to a session but lose the sessions when navigating through pages if the results go on to 2 or more pages.
<%session("Str") = Request.Form("Street")%>
<%session("OrdNo")=Request.Form("OrderNo")%>
<%session("CRef")=Request.Form("Ref")%>
<%session("ProjName")=Request.Form("ProjectName")%>
Page2
Dim MyProjData
Dim MyProjData_numRows
Set MyProjData = Server.CreateObject("ADODB.Recordset")
MyProjData.ActiveConnection = MM_CLPortal_STRING
MyProjData.Source = "SELECT * FROM table1 WHERE EmailAddress = '" + Replace(MyProjData__MMColParam, "'", "''") + "'"
many thanks in anticipation.
Question 1, On my submit page1 I would like to filter using any of the criteria below within the select statement.
How can I filter the results on page 2 from any of the four criterias from page1 ? (in addition to the email a filter below ?
Question 2, I am also passing the request.form values from each criteria to a session but lose the sessions when navigating through pages if the results go on to 2 or more pages.
<%session("Str") = Request.Form("Street")%>
<%session("OrdNo")=Request.Form("OrderNo")%>
<%session("CRef")=Request.Form("Ref")%>
<%session("ProjName")=Request.Form("ProjectName")%>
Page2
Dim MyProjData
Dim MyProjData_numRows
Set MyProjData = Server.CreateObject("ADODB.Recordset")
MyProjData.ActiveConnection = MM_CLPortal_STRING
MyProjData.Source = "SELECT * FROM table1 WHERE EmailAddress = '" + Replace(MyProjData__MMColParam, "'", "''") + "'"
many thanks in anticipation.