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

[ericho@vantixnet.com (Erich Oliphant)]

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