Akopia Akopia Services

[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date ][Minivend by thread ]

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



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

Well I think I got it!  For my case "st" should be "sql". And it seems to
work.  I'm glad this part is  figured out (Thanks everybody), but this is
definitely one of those things that could be clearer.


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


> ******    message to minivend-users from ericho@vantixnet.com (Erich
Oliphant)     ******
>
> Hi,
> Thanks for the input.  I have now tried your suggestion:
>   [loop search="ra=yes/st=db"]
>     [loop-field name]  <BR>
>   [/loop]
>
> Now nothing comes back in the page and the MV daemon spits out: "Bad
search,
> probably bad search string."   This is so bizarre.  So you are not using
> products.asc at all, right.  All of your product stuff is in the DB?
Also,
> what's the HOT directive.  I didn't see that in the docs.
>
> Thanks for your reply,
> Erich
>
> ----- Original Message -----
> From: Bill Randle <billr@exgate.tek.com>
> To: Erich Oliphant <ericho@vantixnet.com>
> Sent: Sunday, January 23, 2000 2:08 PM
> Subject: Re: [mv] Using SQL's DB's
>
>
> > Erich,
> >
> > Don't know if this will help, but have tried explicity telling Minivend
> > to do a db search? E.g.:
> > [loop search="ra=yes/st=db"]
> > ...
> > [/loop]
> >
> > -Bill Randle
> > billr@exgate.tek.com
> >
> > P.S. For what it's worth, the definition in my catalog.cfg file for
> > using mySQL looks like this:
> >
> > Database            products        products.asc       dbi:mysql:golf
> > Database            products        HOT 1
> > Database            products        USER  minivend
> > Database            products        INDEX              category
> > Database  products  COLUMN_DEF   "code=char(12) NOT NULL PRIMARY KEY"
> >  ... rest of products db definition ...
> >
> > ----
> >
> > On Jan 23, 11:07am, Erich Oliphant wrote:
> > } Subject: Re: [mv] Using SQL's DB's
> > } ******    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
> > }-- End of excerpt from Erich Oliphant
> >
> >
> >
>
> -
> 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


Search for: Match: Format: Sort by: