I've re-read through all the old posts about getting the "List All" link to show all the records in Alphabetical Order. I add the &sb=FIELD_NUMBER&so=ascend to the end of the link, and whenever I click the "list all" it gives me a debugging error. It says it's in the db.cgi on line 472, which talks about sorting.

Any tips? Is this because I have my database in default as "view" only?

http://www.erroneous-dross.net/...ault&uid=default

that's the link, and right now "View all residents" works just fine...however, when adding that little bit to the code, it goes to debugging mode.

You can sort by field NAME, but I don't think you can sort by field NUMBER.

sb=Name works "OK".
sb=1 causes a dbman error (however sb=0 doesn't).


By the way... what did the error message say?

Thanks for the reply! I figured it out because I was putting "sb=1" instead of "name" for 1, and it works lovely now!