I am a newbe to all of this so please bear with me.
I have a membership database that is searchable by state. I also have a fiels that has multi state entries for members that choose to be listed in more than one state.
The problem is when I search this Multi-state field I want it to return all states in order and also sort the results for each state alpha by last name? Does any of this make sense?

Please Advise
Bryan

I understand what you want to do, but DBMan won't do that.

I have a general idea of the procedure that would be necessary to do a sort on multiple fields, but implementing it would be quite a chore. And it the sorting routine would have to be hard-coded into db.cgi, so you would lose a lot of flexibility in the script.


------------------
JPD

Thanks for the quick response. I didn't think it would be an easy chore. I'll see if I can figure something else out.

Any Ideas?

Bryan

The only thing I can suggest is that you limit the searches to one state and sort on the last name field.

Or you switch to SQL-DBMan and work with the SQL statements.



------------------
JPD