Re: Arbitrary Database Problems

[Mike Lerley <mike@bfent.com>]

******    message to minivend-users from Mike Lerley <mike@bfent.com>     ******

Interpolation doesn't seem to be a problem as the correct item-code is making it to the function.
I would add a format field but this data is going to be immense and there will be weekly updates.  It is
an option, I suppose.  Also I don't plan to duplicate everything; just vital data like title, price, etc.
I just dove into this and haven't bothered to clean everything up yet.
-mike

Thompson-Jordan wrote:

> ******    message to minivend-users from "Thompson-Jordan" <Thompson-Jordan@mindspring.com>     ******
>
> have you tried:
> [data base="prodindex" field="title" key="[product-code]"]
>
> I don't know if you also need interpolate=1 at the end. That may be why
> adding ".2" made it work. Check how you are matching in your search.
>
> Maybe you should add a field "format" to products.asc that is set to
> tape,cd,record and then use either coordinated searches or return unique
> to get what you want. Then you could get rid of prodindex.asc. It seems a
> shame to duplicate everything.
>
> Christopher
>
> > -----Original Message-----
> > From: owner-minivend-users@minivend.com
> > [mailto:owner-minivend-users@minivend.com]On Behalf Of Mike Lerley
> > Sent: Thursday, March 11, 1999 10:59 AM
> > To: Dan Busarow
> > Cc: minivend-users@minivend.com
> > Subject: Re: Arbitrary Database Problems
> >
> >
> > ******    message to minivend-users from Mike Lerley
> > <mike@bfent.com>     ******
> >
> > I actually tried that once already.  Still no deal. Returns absolutely
> > nothing.
> > Read The Search Engine/The Results Page 14.5 times.
> > -mike
> >
> > Dan Busarow wrote:
> >
> > > On Thu, 11 Mar 1999, Mike Lerley wrote:
> > > > I have a database of music where different forms of the same product
> > > > (tape, CD, etc) have the same item code with a .1, .2, etc.
> > appended.  I
> > > > created a separate product index (prodindex) for searching
> > that contains
> > > > only the unique item codes.  Otherwise I get multiple returns in the
> > > > search for each form of the product.  So I set up my search page to
> > > > search prodindex.asc. Works great.  Returns the right
> > number, etc.  Now
> > > > I want to build my results page so that it references
> > prodindex.asc for
> > > > the title, artist, etc. info rather than products.asc.  But it's not
> > > > working.  I get no results whatsoever from my [data .. ]
> > tag.  What am I
> > > > doing wrong?  Specifics follow.
> > > >
> > > > catalog.cfg
> > > > Database    prodindex    prodindex.asc    TAB
> > > >
> > > > results.html
> > > > [search-list]
> > > > ...
> > > > [data prodindex title [item-code]]
> > >
> > > Try
> > >
> > >  [item_data prodindex title]
> > >
> > > In the reference manual see THE SEARCH ENGINE / The Results Page.
> > >
> > > Dan
> > > --
> > >  Dan Busarow
> > 949 443 4172
> > >  Dana Point Communications, Inc.
> > dan@dpcsys.com
> > >  Dana Point, California  83 09 EF 59 E0 11 89 B4   8D 09 DB
> > FD E1 DD 0C 82
> >
> > --
> > Mike Lerley, System Integrator
> > Goold Health Systems
> > 24 Stone Street
> > Augusta, ME 04330
> > Email mike@bfent.com
> > Phone (207) 622-3298
> > Fax   (207) 623-5125
> >
> >
> > -
> > 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

--
Mike Lerley, System Integrator
Goold Health Systems
24 Stone Street
Augusta, ME 04330
Email mike@bfent.com
Phone (207) 622-3298
Fax   (207) 623-5125


-
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