We currently have an area of our site that people must register to enter. Registrants are put into an MSSQL database. They are assigned a userid #, but the names, etc. are inserted in a random fashion. That is, id #2 does not necessarily follow id #1. Since we have a few hundreds names now, this makes it difficult to see the latest additions to the database (we are generally notified by email through the registration page, but not always).
I can find an "dbOrderBy" command or code in the .asp page that apparently sends the information to the database, but I have no idea what to change it to. (I don't find any additional command or string other than "dbOrderBy." Does anyone have any idea how to change it so that it orders by id #?
It seems that you are looking at the DB tables directly for the infromation you want. If you want to see the entries in order, without resorting to outputting to a page, then use Query Analyser to view the results.
SQL Server input does seem to be pretty random when you look at the tables. If you really MUST have the table ordered by ID field then you can create a clustered index on the ID to force the order.
Remember, you can only create 1 clustered index per table.