Re: creating unique multiple indexes

[mwatkins@lexmark.com]

******    message to minivend-users from mwatkins@lexmark.com     ******

Rob,

It is ok to ask the obvious, I do have a problem when I run reconfig from the
command line.
It says
reconfig failed.

If I run it through the web page, it says
Reconfigured Successfully.

Not sure what to believe, but either way nothing changes.

Also, I am running 3.12beta6.

I was considering the ugly work around of making a second database called
artist.asc and having
to keep it up separately, however I am not sure how to change database to a new
one?

I have tried [set mv_database_file]artist.asc[/set] than a loop, no good.
I have tried [loop search="fi=artist.asc/ra=yes/ml=10000"] no good. I have tried
different paths with or without .asc etc.

All I want is a sql equivalent to:
"select into temptable distinct artist from products"

Thanks again.
Mark Watkins
mwatkins@ecentral.com

>Sorry to ask the obvious but, have you ./reconfig ? Also, does this
>work on older
>versions of MV? I did not notice this feature till about 3.12beta6 when
>the
>products.asc.4 showed up in the distribution.
>Rob
>- --------
>
>> ******    message to minivend-users from Mark Watkins
><mwatkins@ecentral.com>     ******
>>
>> I was wondering how to create multiple indexes for a product database.
>> I have tried the following in catalog.cfg:
>>     Database products INDEX category artist
>>
>> or
>>     Database products INDEX category
>>     Database products INDEX artist
>>
>> They don't seem to create a new index or add a field to the category
>> index.
>>
>> What I really want is a unique artist name index from the products
>> database.
>>
>> I.E. Van Gogh has many products but only shows up once in the index?
>>
>> I would like to list out the artists, but not search the whole
>database
>> because it is WAY to slow.
>>
>> Thank you!
>> Mark Watkins
>> mwatkins@ecentral.com



-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list