I am creating a database driven web site using asp vbscript in dreamweaver. I have a MS Access query that is based on another query that has a parameter. In other words, my first query is this:
SELECT tbl_Books_Read.Books_Read_ID, tbl_Books_Read.Book_Link, tbl_Employees.Employee_ID, [Employee_First_Name] & " " & [Employee_Last_Name] AS Employee_Name, tbl_Employees.Employee_First_Name, tbl_Employees.Employee_Last_Name
FROM tbl_Employees RIGHT JOIN tbl_Books_Read ON tbl_Employees.Employee_ID = tbl_Books_Read.Employee_Link
Then I have another query based on that one that I need to access from my ASP page in Dreamweaver:
SELECT qry_Books_OTDS.Book_ID, qry_Books_OTDS.Title, qry_Books_OTDS.Author, qry_Books_OTDS.Description, qry_Books_OTDS.Type, qry_Books_OTDS.Pay_Amount, qry_Books_OTDS.Checked_Out_To, qry_Books_OTDS.In_Christys_Library, qry_Books_Read_Employee.Employee_ID, qry_Books_Read_Employee.Employee_Name
FROM qry_Books_OTDS LEFT JOIN qry_Books_Read_Employee ON qry_Books_OTDS.Book_ID = qry_Books_Read_Employee.Book_Link;
Right now I'm just trying to figure out how to pass the [Emp_ID] parameter to my asp page from Dreamweaver and access my first query. I have this value stored as a Session Variable called varEmpID, but I can't figure out how to pass the parameter to the Access query. Is this possible?