Re: Possible search bug in 3.12beta13 (and earlier)

[Frank Miedreich <miedreich@acm.org>]

******    message to minivend-users from Frank Miedreich <miedreich@acm.org>     ******

>******    message to minivend-users from Matthew.Rice@ftlsol.com     ******
>
>Synopsis:
>	When doing a search through a database other than 'products',
>	minivend seems to be trying to relate the [item-code] to a
>	match in the products database.
>
>	This causes things like [item-field blah] to be incorrect
>	or empty.
>
>Side Note:
>	The partcat.asc database is configures the same way as
>	products.asc but no .gdbm files or column files are
>	ever created.
>
>It may just be that I don't know what I'm doing but...
>
>I'm trying to do a search through a categories file and the I have
>a file called partcat.asc (with a sample):
>
>code	category	subcategory
>Bearing:Mounted	Bearing	Mounted
>Bearing:Un-Mounted	Bearing	Un-Mounted
>
>Now when I do the search (assuming it matches stuff in producsts.asc):
>
>
>	http://mysite/cgi-bin/catalog/scan/fi=products/sf=category/sp=catwalk/se=Bearin
>g?fVLC75zZ;;746
>
>Everything is fine.  However when I do the exact same thing with partcat.asc:
>
>
>	http://mysite/cgi-bin/catalog/scan/fi=partcat/sf=category/sp=catwalk/se=Categor
>yB?fVLC75zZ;;746
>
>Only [item-code] is valid.  If I put the same code entry in product.asc,
>then the other fields get filled in (with the products.asc values).
>

Hi

You explain the situation very well. It is not a bug though, it is a
feature. the [item-field whatever] tag retrieves data from the products
database, no matter which database you were searching in.

If you want data from another arbitrary database you will have to use:
[item-data database fieldname]

It is in section docindex/08.13.Item_Lists.html of the documentation:
[item-field fieldname]
       Evaluates to the field name fieldname in the products
       database, for the current item. If the item is not found
       in the first of the ProductFiles, all will be searched in
       sequence.

[item-data database fieldname]
       Evaluates to the field name fieldname in the arbitrary
       database table database, for the current item.

Cheers, Frank

--
Frank Miedreich
Max-Planck-Institut fuer psychologische Forschung


-
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