[ic] alphabetical searches

[Jon Jensen]

On Fri, 3 May 2002, Mitch G wrote:

> what would be the easiest way to make a search ( it tried the wizard with no
> success) list the results in alphabetical order?
> 
> i'm setting up interchange to search for album titles like a-g, h-m,
> n-q,r-z??

Hmm, it sounds like Stefan's excellent mv_more_alpha is similar to what
you want:

[query
	type=list
	ml=100
	more=1
	ma=1
	mc=3
	tf=artist_name
	table=products
	sql=|
		SELECT sku, artist_name, album_title
		FROM products
		ORDER BY artist_name
	|
]

...

[more-list]More: [more][/more-list]
[/query]

ma=1 turns on mv_more_alpha, mc=3 says to use up to the first three 
characters for the page links, tf=artist_name says to use that field for 
the paging.

Of course that's an SQL search. But it's pretty much the same for an 
Interchange search.

Jon