Re: Search Command, multiple dbs, etc.
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 30862
interpreted = N
texte = Since you are using a search context on the People.tpl page, it doesn't makesense to construct *command* style links. Change your links to somethinglike
[Author1] and it shouldwork. Just remember, you don't want to mix context and command syntax,unless you are using the context independently of the command, which in thiscase you are not. In order for [Author1] to be a valid variable on thePeople.tpl page, it must be passed to it in a form or link. You are passinga search command with a variable named eqAuthor1data, which is not the samething. If you want to use a command, you don't use the [search] context onthe results page. If you want to use a [search] context on the resultspage, you don't use command syntax in your link, but instead make sure youpass the necessary variables so that the [search] context works.Mike> > > Can somebody clue me in as to why my search commands below do not return> any data on my People.tpl page.> > My Results.tpl page yields a list of books with a list of authors &> editors hyperlinked to a People.tpl page (which comes up empty). The> author/editor name on the Results.tpl page comes from my products.db. I> want the user to then click on the hyperlinked name (from products.db)> and return a a People.tpl page that pulls data (bio, image, contact> info, etc.) from a people.db based and the author/editor field data> hyperlinked on the Results.tpl page from the product.db.> > In other words, I've got two dbs --one for products, one for people.> The products Results page yields a hyperlinked author name that when> clicked should yield a people results page that presents data from the> people.db. The products db has fields for authors/editors 1-4, the> people db has only one name field: Author1. Any hyperlinked author1-4> or editor 1-4 from products should search for matching records in the> Author1 field in people.db.> > Here are my search commands from the product results page, and below> that is my People.tpl page.> >
HREF=People.tpl?command=search&db=fitpeople.db&eqAuthor1data=[Author1]>[Auth> or1]> >
HREF=People.tpl?command=search&db=fitproducts.db&eqAuthor1data=[Author2]>[Au> thor2]> >
HREF=People.tpl?command=search&db=fitproducts.db&eqAuthor1data=[Author3]>[Au> thor3]> >
HREF=People.tpl?command=search&db=fitproducts.db&eqAuthor1data=[Author4]>[Au> thor4]> >
HREF=People.tpl?command=search&db=fitpeople.db&eqAuthor1data=[Editor1]>[Edit> or1]> >
HREF=People.tpl?command=search&db=fitpeople.db&eqAuthor1data=[Editor2]>[Edit> or2]> >
HREF=People.tpl?command=search&db=fitpeople.db&eqAuthor1data=[Editor3]>[Edit> or3]> >
HREF=People.tpl?command=search&db=fitpeople.db&eqAuthor1data=[Editor4]>[Edit> or4]> > ________________________________________________> > People.tpl> > > > >
FIT People Detail> > > [include file=header.htm]>
>
> > [search db=fitpeople.db&eqAuthor1data=[Author1]]> [founditems]> > >
> > > Press your browser's "Go Back" button to see the page you just> came from,
> or return to the Search by Category> Page> > > >