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

[Mark Stosberg <mark@summersault.com>]

******    message to minivend-users from Mark Stosberg <mark@summersault.com>     ******


for an arbitrary table without a flatfile, try
 Database            table_name DSN  dbi:Pg:dbname=your_db_name
host=your.host.com port=5432

The relevent docs aren't fresh in my fmind, you might do a reality check
with them.

 -mark


Nicholas Albright wrote:
> 
> ******    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

-- 
http://flip.summersault.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