<% ' Property of and written by Adam Ford --> if isempty(intStartid) then intStartID = 1 end if if isempty(strSortMethod) then strSortMethod = "name" end if ' Create the SQL statement strSQL = "SELECT * from Bedrooms WHERE BEDID>=" & CINT(intStartid) & " AND Deleted=False ORDER by " & strSortMethod & ";" ' Open a recordset set objRS = objDBConn.execute(strSQL) strSQL = empty strSortMethod = empty intStartID = 1 %>