Re: Search Command, multiple dbs, etc. --still confused

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 30872
interpreted = N
texte = Mike--Thanks again for taking some time with me. I tried removing the search command on People.tpl and using only the [founditems] context. Now I get an error message: Error: No Search Context Found. Ignoring [FOUNDITEMS] contextWhat next?Mike Davis wrote:> If you use the command style links, then remove the [search] command on > People.tpl and simply use the [founditems] loop. When you use a command > style link, the whole page is assumed to have a [search] command wrapped > around it so all you need is the [founditems] loop wherever you want your > search results. > > Mike > > > Thanks for your reply Mike. However, I'm still quite confused. I tried > > using a link like you suggested on my Results.tpl page and leaving the > > [search] context in my People.tpl file but it didn't return anything. > > > > If I am to use the command style links (as below) then how should I > > modify my People.tpl page? > > > > I understand the need to pass the criteria to the People.tpl page. I > > don't see how the link you offered does this. I'm not too sure of how > > forms work. Does your suggestion involve a form that needs to be > > accounted for in People.tpl? > > > > Thanks. > > > > -------- Original Message -------- > > From: Mike Davis > > Subject: Re: Search Command, multiple dbs, etc. > > To: (WebCatalog Talk) > > > > 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 ------------------------------------------------------------- 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. --still confused (Bob/Amelia McPeak 2000)
  2. Re: Search Command, multiple dbs, etc. --still confused (John Butler 2000)
  3. Re: Search Command, multiple dbs, etc. --still confused (Robert McPeak 2000)
  4. Re: Search Command, multiple dbs, etc. --still confused (Mike Davis 2000)
  5. Search Command, multiple dbs, etc. --still confused (Robert McPeak 2000)
Mike--Thanks again for taking some time with me. I tried removing the search command on People.tpl and using only the [founditems] context. Now I get an error message: Error: No Search Context Found. Ignoring [founditems] contextWhat next?Mike Davis wrote:> If you use the command style links, then remove the [search] command on > People.tpl and simply use the [founditems] loop. When you use a command > style link, the whole page is assumed to have a [search] command wrapped > around it so all you need is the [founditems] loop wherever you want your > search results. > > Mike > > > Thanks for your reply Mike. However, I'm still quite confused. I tried > > using a link like you suggested on my Results.tpl page and leaving the > > [search] context in my People.tpl file but it didn't return anything. > > > > If I am to use the command style links (as below) then how should I > > modify my People.tpl page? > > > > I understand the need to pass the criteria to the People.tpl page. I > > don't see how the link you offered does this. I'm not too sure of how > > forms work. Does your suggestion involve a form that needs to be > > accounted for in People.tpl? > > > > Thanks. > > > > -------- Original Message -------- > > From: Mike Davis > > Subject: Re: Search Command, multiple dbs, etc. > > To: (WebCatalog Talk) > > > > 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 ------------------------------------------------------------- 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 Robert McPeak

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:

Protect (1997) Re:Emailer tracking (1997) Physical Security for WebCatalog Directories (1997) FM PRO Compatibility Issue - Single Database w/o Conversions (1997) Protect (1997) Reversed words (1997) Sorting Numbers (1997) Storebuilder-AutoCategory (2003) Changes to the List (1997) [WebDNA] v7 Stress Test and Strange Behaviour (2012) weird happenings (1997) Referrer field to header field conversion (1997) [Sum] function? (1997) AE aware WebCatalog.acgi? (1997) Buying sans cart (1997) Pulldown Menu Problem (2000) For those of you not on the WebCatalog Beta... (1997) lookups (2000) dos performance (1998) Email truncation test (1998)