%@LANGUAGE="VBSCRIPT"%> <% Dim Recordset1__varType Recordset1__varType = "%" If (Request.QueryString("PropertyType") <> "") Then Recordset1__varType = Request.QueryString("PropertyType") End If %> <% Dim Recordset1 Dim Recordset1_numRows Set Recordset1 = Server.CreateObject("ADODB.Recordset") Recordset1.ActiveConnection = MM_FP_STRING Recordset1.Source = "SELECT PropertyType,PropertyID, City, Beds, PriceEuros, PictureA FROM properties WHERE PropertyType LIKE '" + Replace(Recordset1__varType, "'", "''") + "' ORDER BY PriceEuros ASC" Recordset1.CursorType = 0 Recordset1.CursorLocation = 2 Recordset1.LockType = 1 Recordset1.Open() Recordset1_numRows = 0 %> <% Dim Repeat1__numRows Dim Repeat1__index Repeat1__numRows = 5 Repeat1__index = 0 Recordset1_numRows = Recordset1_numRows + Repeat1__numRows %>
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||