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

["Mr. Christopher F. Miller" <cfm@maine.com>]

******    message to minivend-users from "Mr. Christopher F. Miller" <cfm@maine.com>     ******

On Fri, Jan 21, 2000 at 09:11:30AM +0100, Christian J. Müller wrote:
> ******    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.

Well to be precise, the MV **documentation** falls into the common
usage and does not distinguish that well.  MV itself very much does 
distinguish.  If you are using mySQL and have permissions set 
appropriately, you can cross **databases** too:

SELECT my_other_db.foo,bar FROM my_other_db.products,products etc...

> 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.

I'm pretty sure as well that as long as you have the default
products you don't even need to define the other tables.  YMMV; that
might be one of our local "features".

> 
> 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
> > 
> > Roger
> > 
> > -
> > 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
> -
> 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

-- 

Christopher F. Miller, Publisher                             cfm@maine.com
MaineStreet Communications, Inc         208 Portland Road, Gray, ME  04039
1.207.657.5078                                       http://www.maine.com/
Database publishing, e-commerce, office/internet integration, Debian linux.
-
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