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

[ericho@vantixnet.com (Erich Oliphant)]

******    message to minivend-users from ericho@vantixnet.com (Erich Oliphant)     ******

Most of what I read in the posts led me to believe that I was doing this
correctly.  I came across a post concerning the undocuments "Replace"
directive.  I've tried this:
----
Replace ProductFiles products
ProductFiles        products
Replace Database products
Database            products     products      SQL
Database   products  DSN  dbi:ODBC:mv
---
And I'm still not getting anywhere.  Of course I don't know is this is
correct since Replace is undocumented.

I also turned on DBI tracing.  When MV starts up it does a "select *"
against the products table in my database.  I can see the fields that are in
my products table and not in products.asc.  I have a simple page that only
has:

  [loop search="ra=yes"]
    [loop-field name] |  [loop-increment] <BR>
  [/loop]

Via DBI (and the generated page, of course) I watch MV cycle through the
products.asc file.  Is there some additional setting other than "Database
products" that I need to have the MV tags use the product table in the DB?

Thanks
EKO




----- Original Message -----
From: Hans-Joachim Leidinger <jojo@buchonline.net>
To: <minivend-users@minivend.com>
Sent: Sunday, January 23, 2000 7:06 AM
Subject: Re: [mv] Using SQL's DB's


> ******    message to minivend-users from Hans-Joachim Leidinger
<jojo@buchonline.net>     ******
>
> Erich Oliphant wrote:
> >
> > 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
> >
> [BIG DEL]
>
> I wish, i can help you. But i have no experience with any SQL (I am
> starting to use a SQL-Database now).
> If i remembered right, the questions how to set the catalog.cfg to use a
> SQL-Database is answered and is in minivend mailarchiv. Did you search
> for this answers from the mailarchiv?
> It seems me, the setting is not right and it seems me, i am missing User
> and Password to access the SQL Databases. But i am not sure about my
> archiv in my head and sorry for my poor english.
>
> Regards,
>
> Joachim
>
> --
> -------------Hans-Joachim Leidinger---------------------
>
>
> -
> 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
>

-
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