RE: list of categories

["Thompson-Jordan" <Thompson-Jordan@mindspring.com>]

******    message to minivend-users from "Thompson-Jordan" <Thompson-Jordan@mindspring.com>     ******

I assume that you keep your database in some form other than the
products.asc file. In which case, most databases can do a simple SQL query,
like the following, to generate the second database:

SELECT DISTINCT code, category
FROM products
ORDER BY code;

Perhaps someone else who knows SQL well could help you with the exact query
you need.

If you only have the products.asc file, then perhaps you could use a
combination of unix tools, or write a script in something like Perl to do
what you want. I think that most people use a DB package and export to
products.asc file.

Christopher Thompson


> -----Original Message-----
> From: owner-minivend-users@minivend.com
> [mailto:owner-minivend-users@minivend.com]On Behalf Of Thomas Walter
> Sent: Monday, February 08, 1999 4:39 AM
> To: minivend-users@minivend.com
> Subject: Re: list of categories
>
>
> ******    message to minivend-users from Thomas Walter
> <tw@mail.itreff.de>     ******
>
> Hiho Christopher...
>
> How do you generate such a separate database? Do you have a script to do
> so?
>
>      Balu
>
> Thompson-Jordan wrote:
> >
> > ******    message to minivend-users from "Thompson-Jordan"
> <Thompson-Jordan@mindspring.com>     ******
> >
> > I do this same thing my generating a separate database from my products
> > database that contains a list of the categories. Each record in this
> > database contains the category name and type, plus a count of
> the number of
> > items in that category.
> >
> [... snipp ...]
> -
> 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