%@LANGUAGE="VBSCRIPT"%>
<%
Dim rsEnq__MMColParam
rsEnq__MMColParam = "0"
if(Request.QueryString("TripRef") <> "") then rsEnq__MMColParam = Request.QueryString("TripRef")
set rsEnq = Server.CreateObject("ADODB.Recordset")
rsEnq.ActiveConnection = objConn
rsEnq.Source = "SELECT * FROM trips WHERE TripRef = '" + Replace(rsEnq__MMColParam, "'", "''") + "'"
rsEnq.CursorType = 0
rsEnq.CursorLocation = 2
rsEnq.LockType = 3
rsEnq.Open
rsEnq_numRows = 0
set rsCountry = Server.CreateObject("ADODB.Recordset")
rsCountry.ActiveConnection = objConn
rsCountry.Source = "SELECT * FROM Countries order by country"
rsCountry.CursorType = 0
rsCountry.CursorLocation = 2
rsCountry.LockType = 1
rsCountry.Open
rsCountry_numRows = 0
set rsActivity = Server.CreateObject("ADODB.Recordset")
rsActivity.ActiveConnection = objConn
rsActivity.Source = "SELECT * FROM activities order by activity"
rsActivity.CursorType = 0
rsActivity.CursorLocation = 2
rsActivity.LockType = 1
rsActivity.Open
rsActivity_numRows = 0
%>
Realworld-Travel - Request more Details