%@ LANGUAGE="VBScript" %> <% Set Connection = Server.CreateObject("ADODB.Connection") Connection.Mode = adModeRead Connection.Open phdb_rd SQLStmt = "select * from sitester.testkey_ono,sitester.sensor_log,sitester.batch_info where testkey_ono.batch = batch_info.batch and startdate=logdate AND testkey_ono.batch='"+Request("batch")+"' AND testkey_ono.sensor="+Request("sensor")+" order by keynumber,startdate" Set RS = Connection.Execute(SQLStmt) %>