<% ' Property of and written by Adam Ford --> dim intHID intHID = request.querystring("hid") ' Create the SQL statement strSQL = "SELECT * from Houses WHERE HID=" & intHID & ";" ' Open a recordset set objRS = objDBConn.execute(strSQL) intHID = empty %>