Here's the scenario. I hold the shift, line, date, department, and text in an sql database.
I would like to use an asp page prior to loading the runner pages and pass the shift and line variables to the runner sql code.
Example:
Current sql
select [Department],
[Line],
[Shift],
[Text],
From [dbo].[tblText]
would like to add the Where clause and variables on the fly from the asp page so it would look something like this.
Current sql
select [Department],
[Line],
[Shift],
[Text],
From [dbo].[tblText]
Where [Line]='1'
