Re: [mv] How does minivend know which table to use

["Regina Zuccolillo" <regina@cyberia.net.py>]

******    message to minivend-users from "Regina Zuccolillo" <regina@cyberia.net.py>     ******

I don't know if this applies for SQL users too, (im not) but I had the same
problem, and realized I was  creating my aditional databases as root, so I
chown to the minivend user (in my case "comercio") and worked very well.
Check the permissions, must be the same as products.asc
In the catalog.cfg I defined a new line for each new database like this
Database            new_products        new_products.asc         TAB
Database            new_products2        new_products2.asc         TAB
ProductFiles        new_products        new_products2        products

Thats it.
Ah! I remember Mike also gave this tag  [loop-field column] != [loop-data
products column]
it's helpful when you do not want mv to search the products.asc database.

Hope it helps you. By the way, as this is one of the FAQs, wouldnt be
interesting to copy-paste it to the FAQ section?

Gina

----- Original Message -----
From: Christian J. Müller <cmueller@polinet.ch>
To: <minivend-users@minivend.com>
Sent: Friday, January 21, 2000 4:11 AM
Subject: Re: [mv] How does minivend know which table to use


> ******    message to minivend-users from "Christian J.
=?iso-8859-1?Q?M=FCller?=" <cmueller@polinet.ch>     ******
>
> MV does not distinguish between database and table. i.e. MV calls tables
> and databases both databases.
> The database (as per SQL) is defined in the DSN directive or as a
> shortcut in the Database directive.  All other "database" defines are
> really the equivalent of SQL tables.
>
> Chris
>
> Roger Arnold wrote:
> >
> > ******    message to minivend-users from Roger Arnold
<rbarnold@a-dream.com.au>     ******
> >
> > Roger wrote:
> >
> > Hello,
> >
> > I have now got minivend working in the sense that it is accepting the
> > MySQL database called "minivend" named minivend as suggested in the
> > manual, and starting up without error.
> >
> > However, for the life of me I can't work out how minivend knows which
> > table in the database to use.
> >
> > It knows the database name because that is set in the catalog.cfg file,
> > so where in the .cfg file do you tell it to use a table called
> > "businesses" as the default table ?
> >
> > If it is set like "products    products.asc" do you have to make a file
> > in the database directory called businesses.asc and if so what do you
> > put in the file "businesses.asc" to tell minivend that the table to use
> > as default is "businesses" ?
> >
> > Why is this simple feat so complicated, and where is the documentation
> > to accomplish it?
> >
> > I have asked a simple question about the "catalog.cfg" file before and
> > it seems that minivend users think that configuring the config file is
> > so simple that the question was not worth answering.
> >
> > I would be extremely grateful if someone could answer this question and
> > give me some pointers please
> >
> > Thanks, indeed many thanks in advance
> >
> >

-
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