% Dim rsResidential Dim rsResidential_cmd Dim rsResidential_numRows Set rsResidential_cmd = Server.CreateObject ("ADODB.Command") rsResidential_cmd.ActiveConnection = MM_HAOR_STRING rsResidential_cmd.CommandText = "SELECT MLS, Area, [Asking Price], City, BEDROOMS, [F/BATHS], [H/BATHS], [Agent ID], [Agent Name], [Agent Phone], [Listing Office 1 ID], [Listing Office 1 Name], Image1, Image2, Image3, Image4, ImageTN FROM dbo.residential WHERE [Agent ID] = ? ORDER BY [Asking Price] DESC" rsResidential_cmd.Prepared = true rsResidential_cmd.Parameters.Append rsResidential_cmd.CreateParameter("param1", 200, 1, 10, rsResidential__MMColParam) ' adVarChar Set rsResidential = rsResidential_cmd.Execute rsResidential_numRows = 0 %>
![]() |
![]() |
|||||||||||||||||||||||||
|
|
|
|
|
|
|
|||||||||||||||||||||
|
||||||||||||||||||||||||||
![]() |
||||||||||||||||||||||||||