<% ' 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 Bathrooms WHERE BATHID>=" & CINT(intStartid) & " AND Deleted=False ORDER by "& strSortMethod & ";" ' Open a recordset set objRS = objDBConn.execute(strSQL) strSQL = empty strSortMethod = empty intStartid = 1 %>