SQL Searches etc. Was: makecat templates

["Russ" <russ@khouse.org>]

Can you share your page code for that?  This is where I am having problems,
it seems as though doing things in SQL is harder than text...  If you could
give code snippets of SQL based searches and other ways you access the data
that would be great!!!

Does anyone have external/helper perl scripts accessing mySQL data?  I have
a couple using the text files, but when upgrading to mySQL I want to still
use them...

Thanks,

Russ

-----Original Message-----
From: owner-minivend-users@minivend.com
[mailto:owner-minivend-users@minivend.com]On Behalf Of Erik
Aase-Remedios
Sent: Wednesday, July 07, 1999 10:01 AM
To: minivend-users@minivend.com
Subject: Re: makecat templates


******    message to minivend-users from Erik Aase-Remedios
<erik@fourfish.com>     ******

As far as makecat goes my MySQL/Minivend config isn't any different than a
non-MySQL makecat config.
The only real difference comes in the configuration file 'catalog.cfg' in
the Database section.
I use this:
  Database  products     products.asc     dbi:mysql:db_name:localhost:3306
  Database  products     LongReadLen      128
  Database  formats      formats.asc      dbi:mysql:db_name:localhost:3306
  ... one line for each table ...

And I use NoImport on all of my tables.
  NoImport products formats ...

The real changes come in the page templates where I'm using SQL searches
and lots of SQL lookups to deal with a complex table structure.

-Erik

On Wed, 7 Jul 1999 Scott_Schenkein@ccnotes.ccity.com wrote:

> ******    message to minivend-users from Scott_Schenkein@ccnotes.ccity.com
******
>
>
>
> Hello,
>
> I am exploring using minivend with MySQL, msql, oracle, and informix...  I
was
> wondering if anyone had any SQL enabled makecat templates (exp. for MySQL)
that
> they were willing to share?  Also I am interested in maintaining a page of
other
> templates to encourage minivend users to make their pages look and feel a
little
> more "diverse" so if anyone has any submissions they would like to make,
please
> let me know.
>
> Scott Schenkein
> -------------------------------
> Owner, Virtual Imagery Design Group, LLC
> http://www.vidg.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