FW: Displaying data from 2 databases on a results page - Now Understood

[Thompson-Jordan <thompson-jordan@mci2000.com>]

******    message to minivend-users from Thompson-Jordan <thompson-jordan@mci2000.com>     ******

I'd like to thank Erik Aase-Remedios [erik@fourfish.com] and cfm@maine.com
for there help on this basic question.

I had tried the following which is the correct syntax:

	[data base="descriptions" field="description" key="automobile"]

It didn't work because I had copied the line out of the documentation and
the quotes were messed up and because I didn't have the search key in the
first column of the database. When I fixed the quotes and changed my
database to the below format it worked fine.

key          description
automobile   An automobile is ...
motorcycle   A motorcycle is a ...

In addition I was able to both list the items from the products.asc
database that meet a searchspec and display a description using searchspec
from descriptions.asc with the following:

Page with one-click search (using a search profile that sets correct search
field, etc):

	[page scan/mp=1/se="automobile"]

Results page contains:

	A description of [value mv_searchspec] is
	[data base="descriptions" field="description" key="[value
mv_searchspec]"]<p>

	The list of matches in products.asc is: <p>
	[search-list]
	[sort products:description]
		[item-code] - [item-description]<p>
	[/search-list]

I spelled it out above because a number of people emailed me on the side
asking that I forward them the answer if I got one. Thanks again.

Christopher Thompson


>
> -----Original Message-----
> From: owner-minivend-users@minivend.com
> [mailto:owner-minivend-users@minivend.com]On Behalf Of Thompson-Jordan
> Sent: Tuesday, January 19, 1999 1:30 AM
> To: Minivend Users
> Subject: Displaying data from 2 databases on a results page
>
>
> ******    message to minivend-users from Thompson-Jordan
> <thompson-jordan@mci2000.com>     ******
>
> In addition to displaying the items from the products.asc database that
> match the searchspec passed via a one-click search, I'd like to display a
> description from a separate database that contains a record for each
> possible searchspec. For example, a [page scan/mp=1/se="automobile"] would
> display all of the automobiles in products.asc and also display a
> description of an automobile from descriptions.asc.
>
> I've tried numerous combinations based on the information about in-page
> searches, but have only succeeded in getting lots of bad search entries in
> error.log. It seems like it should be possibly. Does anyone know how to do
> this?
>
> Thanks
>
> Christopher Thompson
> -
> 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