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 make sense to construct *command* style links. Change your links to something like [Author1] and it should work. Just remember, you don't want to mix context and command syntax, unless you are using the context independently of the command, which in this case you are not. In order for [Author1] to be a valid variable on the People.tpl page, it must be passed to it in a form or link. You are passing a search command with a variable named eqAuthor1data, which is not the same thing. If you want to use a command, you don't use the [search] context on the results page. If you want to use a [search] context on the results page, you don't use command syntax in your link, but instead make sure you pass 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] > > > > > > > > > > > [/founditems] > [/search] >
[Author1][Text][Biography]
[showif [hasPhoto]=T] > > SRC=Images/FitImages/[Image]>
>
[/showif] >
> >
> > > Press your browser's "Go Back" button to see the page you just > came from,
> or return to the Search by Category > Page >
> > > > > > > Thanks for your insights! ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Associated Messages, from the most recent to the oldest:

    
  1. Re: Search Command, multiple dbs, etc. --Right! (Mike Davis 2000)
  2. Re: Search Command, multiple dbs, etc. --Right! (Bob/Amelia McPeak 2000)
  3. Re: Search Command, multiple dbs, etc. --further elucidation needed (Kenneth Grome 2000)
  4. Re: Search Command, multiple dbs, etc. --Getting Results Now! (Bob/Amelia McPeak 2000)
  5. Re: Search Command, multiple dbs, etc. --further elucidation needed (Bob/Amelia McPeak 2000)
  6. Re: Search Command, multiple dbs, etc. --further elucidation needed (Kenneth Grome 2000)
  7. Re: Search Command, multiple dbs, etc. --further elucidation needed (Bob/Amelia McPeak 2000)
  8. Re: Search Command, multiple dbs, etc. --still confused (Bob/Amelia McPeak 2000)
  9. Re: Search Command, multiple dbs, etc. --still confused (John Butler 2000)
  10. Re: Search Command, multiple dbs, etc. --still confused (Robert McPeak 2000)
  11. Re: Search Command, multiple dbs, etc. --still confused (Mike Davis 2000)
  12. Search Command, multiple dbs, etc. --still confused (Robert McPeak 2000)
  13. Re: Search Command, multiple dbs, etc. (Mike Davis 2000)
  14. Search Command, multiple dbs, etc. (Robert McPeak 2000)
Since you are using a search context on the People.tpl page, it doesn't make sense to construct *command* style links. Change your links to something like [Author1] and it should work. Just remember, you don't want to mix context and command syntax, unless you are using the context independently of the command, which in this case you are not. In order for [Author1] to be a valid variable on the People.tpl page, it must be passed to it in a form or link. You are passing a search command with a variable named eqAuthor1data, which is not the same thing. If you want to use a command, you don't use the [search] context on the results page. If you want to use a [search] context on the results page, you don't use command syntax in your link, but instead make sure you pass 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] > > > > > > > > > > > [/founditems] > [/search] >
[Author1][text][Biography]
[showif [hasPhoto]=T] > > SRC=Images/FitImages/[Image]>
>
[/showif] >
> >
> > > Press your browser's "Go Back" button to see the page you just > came from,
> or return to the [cart]>Search by Category > Page >
> > > > > > > Thanks for your insights! ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Mike Davis

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

multi-paragraph fields (1997) Bug Report, maybe (1997) A question on sub-categories (1997) WCS Newbie question (1997) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) [isfolder] and [filename] (1997) Preventing Merchant Settling ? (1997) Shopping cart now good (fixed it) (1997) AuthorizeNet Declines (2005) Defualt folder locations (2004) Initiating NewCart (1997) question: webdelivery folder and file (1997) 2.0 Info (1997) Format of Required fields error message (1997) Emailer error 550? Never mind. (1999) Dynamic Lists (2005) emailer and bad addresses (1997) Date sorting (2004) Email Not Being Sent (2004) [BULK] [WebDNA] [BULK] Console / WebDNA no connection to module (2011)