Text Title Text Department Text Next we want to connect to our new database. For this example we will be using a Static cursor and a Read-Only lock type RecordSet. I do this to make the application a little more portable. I simply code the path in the global.asa file, so that if I want to move the site to a different server, or move the database to a remote directory to increase security, I can with ease. The next step is to create the output table and our form.
Lets start with the output table.
BOF Then RecordSet. Do Until RecordSet. If Do not forget to close out the table. We are now going to create our sorting buttons. Do this for each of the fields you would like to sort.