Re: Question about the 'Database' config parameter & SQL

[Nicholas Albright <albrnick@bobcat.ent.ohiou.edu>]

******    message to minivend-users from Nicholas Albright <albrnick@bobcat.ent.ohiou.edu>     ******

On Mon, 22 Feb 1999, Mark Stosberg wrote:

> ******    message to minivend-users from Mark Stosberg <mark@summersault.com>     ******
> 
> 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)

  Thanks for your time,
    -Nick

> 
> > ******    message to minivend-users from Nicholas Albright <albrnick@bobcat.ent.ohiou.edu>     ******
> > 
> >   When I'm using an SQL database, what does the 2nd argument to the
> > Database directive mean.  Example:
> > 
> > Database        test    ca2g_test       dbi:mSQL:database
> > 
> >   Is the arg 'ca2g_test' used for anything?  Such as the table name?  If
> > not, how can you specify the table name?  Or does the minivend name of the
> > table have to be the name of the table in the SQL database?
> 

-- 

"Computers in the future may weigh no more than 1.5 tons"
		-- Popular Mechanics, 1949



-
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