Categories order

[pesquisa]

I have just entered new categories, and I have changed the order of them to appear in alfabetical order. After updating and re-index I found that the new categories were added, but in the previous order. How can I reorder them exactly the way it is listed in the walk settings ?

Thanks,
Mauricio

[mark]

It should always show the categories in the order entered. Are you referring to the order on the settings page or on the search form (they should be same)? If the search form, you haven't created your own static search page have you? A static form won't change when the data does. Or maybe you have a browser cache issue? Try forcing the browser to reload the page.

[pesquisa]

I am refering to the order on the search form. What happens is that, I entered the categories in a certain order, and saved in this order. After this I just changed the order of these same categories in the settings page, but nothing happens in the search form, even after building the index again and cleaning the browser cache.
If I remove a category, the change appears in the search form, and after including the same category again it appears in the same order it was before, even if I include it as the last one.

[mark]

The order on the search form should always be the same order as on the settings form. Do the categories get rearranged on on the settings form after you "update"? If so, what web browser brand and version are you using?

Also make sure your "check for new version" cache setting is "every time" or "automatic".

[pesquisa]

Thats it. It get rearranged after the first update. If a rearraged again the previous order always remains. I am using Internet Explorer 5.5.

[mark]

We are unable to replicate what you're reporting using IE 5.5 or anything else. You're not using the browser's "back" button to navigate are you? Beyond that I would have to guess at some odd browser cache setting. Or an odd caching proxy if you're using a proxy.

The way the app is constructed the order of categories on the search form and settings form will always reflect the order in which they last came from the settings form.

[pesquisa]

We have just found the problem:

In the search script where it is written:

<sql "select distinct Catno,Category from categories order by Catno"></sql>

must be:

<sql "select distinct Catno,Category from categories order by Category"></sql>

This will order the list of categories by its description instead of their number(the order that it was previously entered).
Is it right ?

[John]

That will order the categories by name, rather than the sequence from the form. The numbers should get updated when you update the form.

If you want the categories alphabetical then you can make that change to the query.

[tmarino]

I want categories to list alphabetical and the current script has the following code:

<sql "select distinct Catno,Category from categories order by convert(Catno,'int')">

If I just change it to "order by Category" no categories are listed. What do I need to change?

[mark]

Use
<sql "select distinct Catno,Category from categories order by Category"></sql>

If you continue to have problems view the source of the page and look for errors within html comments. Or look at vortex.log for the errors.