Re: [mv] Using SQL's DB's

[ericho@vantixnet.com (Erich Oliphant)]

I am obviously misunderstanding something.  I assumed that something like
this:
---
Database            products     products      SQL
                  ---      OR    ----
Database            products     products.asc      SQL
Database   products  DSN  dbi:ODBC:mv
Database            products     INDEX             code
---
in my catalog.cfg would result MV using the "products" table in the "mv"
ODBC alias as the products table for the catalog.   In addition the
"prodcuts.asc" file would not be used,referenced,etc.  However, [loop] tags
and the like still seem to want the products.asc file.  They do not pull the
products from my database, rather they use the products.asc file.  If I
remove this file and retrieve pages that use these tags the MV daemon gives
me a "couldn't open search file ".....\products.asc" : No such file..."
message.

How is this supposed to work?  I thought I was setting MV up to use my
database table instead of the flat file.  What am I missing here?

Thanks,
EKO


----- Original Message -----
From: Erich Oliphant <ericho@vantixnet.com>
To: <minivend-users@minivend.com>
Sent: Saturday, January 22, 2000 1:08 PM
Subject: Re: [mv] Using SQL's DB's


> I think I may have figured this out.  Because I am using a SQL DB do I
have
> to use SQL searches?
> Should this code:
>  [loop search="ra=yes"]
>  [loop-field description] |  [loop-increment] |  [loop-code]<BR>
>
> [/loop]
>
> Look more like this?:
> [sql html]
>     select description, code from products
> [/sql]
>
>
> If this is the case why does the SQL Access Methods section of the manual
> start with:
>
> "A MiniVend SQL database can be accessed with the same tags as any of the
> other databases can"
>
> Thanks in advance
>
> Erich
>
>
>
>
>
>
> ----- Original Message -----
> From: Erich Oliphant <ericho@vantixnet.com>
> To: <minivend-users@minivend.com>
> Sent: Saturday, January 22, 2000 9:47 AM
> Subject: Re: [mv] Using SQL's DB's
>
>
> > Absolutely!  I've restarted several times to no avail.  In an earlier
post
> I
> > describe how I temporarily renamed my products table to confirm that MV
> was
> > connecting.  I get an error when it can find the products table.  I get
no
> > messages when it's there, so I know that MV is "looking" in the SQL DB
at
> > startup.  However, it seems to be ignoring it when it runs this query.
> >
> >
> > ----- Original Message -----
> > From: Ramsey French <rammjet@mindspring.com>
> > To: <minivend-users@minivend.com>
> > Sent: Saturday, January 22, 2000 1:33 AM
> > Subject: Re: [mv] Using SQL's DB's
> >
> >
> > > ******    message to minivend-users from Ramsey French
> > <rammjet@mindspring.com>     ******
> > >
> > > Did you restart the MV server after you modified catalog.cfg ?
> > >
> > > On 1/22/00 1:11 AM, Erich Oliphant at ericho@vantixnet.com wrote:
> > >
> > > > OK, My last post was due to ignorance, perhaps this one is as well.
I
> > am
> > > > just trying to list products on a "test page" with the following
code:
> > > >
> > > > ---
> > > > [loop search="ra=yes"]
> > > > [loop-field description] |  [loop-increment] |  [loop-code]<BR>
> > > >
> > > > [/loop]
> > > > ---
> > > >
> > > > I have the following in my catalog.cfg:
> > > >
> > > > ----
> > > > #Database            products     products.asc      TAB
> > > > Database   products  products   dbi:ODBC:mv
> > > > #Database            products     INDEX             category
> > > > Database            pricing      pricing.asc       TAB
> > > > Database            transactions transactions.txt  TAB
> > > > Database            userdb       userdb.asc        TAB
> > > > Database            country      country.asc       TAB
> > > > Database            locale       locale.asc        TAB
> > > > Database            Ground       Ground.csv        CSV
> > > > Database            2ndDayAir    2ndDayAir.csv     CSV
> > > > Database            NextDayAir   NextDayAir.csv    CSV
> > > > ----
> > > >
> > > >
> > > > For some reason the page lists the contents of the products.asc
file.
> > This
> > > > is weird because I know MV is checking the Access DB for the
presence
> of
> > the
> > > > "products" table.  I have commented out the ref. to products.acs.  I
> am
> > very
> > > > confused.
> > > >
> > > > Thanks In Advance,
> > > > Erich
> > > >
> > >
> > > -
> > > 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
> > >
> >
>

smime.p7s