maintaing categories

[Anrew Allen]

Hello,
I have about 25 categories defined and they are entered in the prticular order.

I need to insert 2 additional categories in the middle ( i.e. the 2 new categories need to appear as #5 and #9 on the dropdown).

What is the easiest way to do this?
It seems like using walk web intrface does not allow to do it easely.

Thanks,
Andrew

[mark]

You need to copy and paste the lower entries down to make holes for the insertions.

[Anrew Allen]

Mark,
I new that ...but what I am saying is that with 25 categories and growing it is very awkward and time consuming.


Do you know of any way I can change entries directly in database not using the web interface?

[mark]

Yes, but it requires some effort and care to setup. The settings are in the database "INSTALLDIR/texis/testdb" in table "options". There are 3 settings for the categories: "SSc_catname", "SSc_caturl", and "SSc_catvisible" for the category name, url pattern, and visible flag respectively. Each is an array of items separated by newline. So SSc_catname would contain
Category Name 1
Category Name 2
SSc_caturl would contain
http://pattern1
http://pattern2
SSc_catvisible would contain
Y
Y

Vortex SQL to update all 3 for profile "test" would be something like this:
<$myprofile="test">
<$newnames="Name 1
Name 2
">
<$newurls="http://pattern1
http://pattern2
">
<$newvis="Y
Y
">
<sql novars "update options set String='$newnames' where Profile='$myprofile' and Name='SSc_catname'"></sql>
<sql novars "update options set String='$newurls' where Profile='$myprofile' and Name='SSc_caturl'"></sql>
<sql novars "update options set String='$newvis' where Profile='$myprofile' and Name='SSc_catvisible'"></sql>