[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: Question about the 'Database' config parameter & SQL
****** message to minivend-users from Dan Busarow <dan@dpcsys.com> ******
On Tue, 23 Feb 1999, Nicholas Albright wrote:
> On Mon, 22 Feb 1999, Mark Stosberg wrote:
> > Here's the lines that worked for me, using Postgres:
> >
> > Database products products.asc SQL
> > Database products DSN dbi:Pg:dbname=your_db_name
> > host=your.host.com port=5432
> >
> > of course, your port varies, and the table doesn't have to be named
> > products, nor do you necessarily have to have the first line, which
> > imports the SQL database from products.asc initially, I think.
>
> Well, I don't have a products.asc file (ie, no local file, it's all in
> SQL), so in that case is the products.asc entry actually doing anything?
> WHen I make queries on the SQL products, does my table have to be named
> products as well? (And if not, how do I specify what the SQl table is
> called)
The first Database line is telling MV that products is an SQL database as
opposed to say a TAB or CSV database. products.asc can be viewed as a
placeholder in this case, or it can be viewed as a *possible* source
for data to be imported to the SQL database.
You can name your tables whatever you want. You need to tell
MV which one(s) is the product table though so [item-XXX] will work.
See ProductFiles in catalog.cfg
The second field, products above, is the name MV will use when
executing queries on its own behalf so the name does need to be
the same as the SQL table name. And if your SQL DB is case sensitive
then case is important.
Dan
--
Dan Busarow 949 443 4172
Dana Point Communications, Inc. dan@dpcsys.com
Dana Point, California 83 09 EF 59 E0 11 89 B4 8D 09 DB FD E1 DD 0C 82
-
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
