[ic] alphbetical sorting

[interchange-users@icdevgroup.org (Curt Hauge)]

Mitch G [mitchg@mwahosting.com] wrote:

> I am currently designing a site that i need a little help with..
>
>
> On the left i am going to have an areas like A-G, H-J, K-Q,
> and R-Z.  (i'm
> sorry, this is going to be a listing for Album names)  how
> do i make this
> kind of sort work?  If i click on A-G, i want to list albums sorted
> alphabetically A-G..

Look into the Search Reference "mv_begin_string", or the One Click
Search parameter "bs". Also for sorting, check out "mv_sort_field" and
"tf".

I once shoveled something together in a test site by making a simple
data table with a few fields with the letters A-Z each in it's own
record, like this:

code  char_id
1     A
2     B
3     C
etc., etc...

In my "products" table I also had a field called char_id, which I had
to input a value (A-Z) for every product I added. This way I could set
up a search for char_id. You also have to deal with "other" characters
if a title starts with ", #, etc. Yes, it is very kludgy. This was a
few years ago before I understood IC (Minivend back then) and I
haven't tried again to see if there is a better way to do it.

YMMV, good luck!


Curt Hauge

//////////////////////////////////////////////////////////////////
// Web Design - Interchange Hosting - Small Business Consulting //
// 1525 Meadowwood Drive                    www.mnwebdesign.com //
// Brooklyn Park, MN 55444             www.iwantaconsultant.com //
// Phone 612-598-5530                      info@mnwebdesign.com //
//////////////////////////////////////////////////////////////////