Re: SEARCHES

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 33281
interpreted = N
texte = sorry I used a code from a page that some one else built a while ago. but I already fixed the problem thank you. Art. -----Original Message----- From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of John Butler Sent: Thursday, June 15, 2000 6:20 PM To: WebCatalog Talk Subject: Re: SEARCHES Art is this code generated by storebuilder or did you write it from scratch? Or did you modify storebuilder code? It may help me appreciate your level of skill as I try to wade thru and guess what is your problem exactly... (did you break storebuilder code, or just not write your own well at first...)I could be totally off the mark, but I would assume you want your opening [search] tag on details.tpl to be- [search db=catalog.txt&eqphotonamedatarq=[url][photoname][/url]](take out any linebreaks added by email)and not- [search db=catalog.txt&eqdescriptiondatarq=[description]&photonamesumm=t&asdescripti onsort=1](otherwise where is the value for [description] coming from? The link(s) generated from the results2.tpl search do not pass the var 'description'. And what if two descriptions happen to be the same in the db? Isn't it better to search by something you know will be unique? - like 'photoname'?break down each param of the search into its pieces seperated by the &'s and ask yourself do I know exactly what that part is doing? If not then look it up in the docs to see what it does. And if you need to restrict your search by some criteria, then you likewise look up in the docs for ideas how to build it.Also in case that is ALL the code in the details.tpl form, you don't seem to be submitting anything...? There is zero input posting to the shoppingcart.tpl.HTH -JohnArturo Vargas wrote:> Please help, > > I am driving my self crazy trying to use logic to solve this problem: > > In my site I have to search a data base =catalog.txt > > shop.tpl - select from list of last names = search for last names from field > category (this is easy it works fine) > > results.tpl - select from list of picture types = search for picture type > from field subcategory (this works fine as well) > > results2.tpl - select from a group of images = search for image from field > photoname this works fine as well) > > ----My problem starts right here----- > > details.tpl has to display the picture that was chosen in results.tpl and > give me a list of photo sizes (this is not working and I am not sure why) > > this are the codes I am using in results2.tpl and details.tpl > > results2.tpl > > > > > > Select the picture you are interested on > [search > db=catalog.txt&eqsubcategorydatarq=[subcategory]&photonamesumm=t&asphotoname > sort=1] > [FoundItems] > > > > [/founditems] > [/search] > > > > details.tpl > > > >
> [search > db=catalog.txt&eqdescriptiondatarq=[description]&photonamesumm=t&asdescripti > onsort=1] > [founditems] > > Last Name:[category] > > Size:[description] > > > > [/founditems] > [/search] >
> > > > any suggestions??? > > ------------------------------------------------------------- > 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 > Web Archive of this list is at: http://search.smithmicro.com/ ------------------------------------------------------------- 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 Web Archive of this list is at: http://search.smithmicro.com/ ------------------------------------------------------------- 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 Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] max number of searches and lookups on a page (Kenneth Grome 2016)
  2. Re: [WebDNA] max number of searches and lookups on a page ("Matthew A Perosi, Psi Prime" 2016)
  3. Re: [WebDNA] max number of searches and lookups on a page (Richard Kwasniewski 2016)
  4. Re: [WebDNA] max number of searches and lookups on a page (Kenneth Grome 2016)
  5. [WebDNA] max number of searches and lookups on a page (Richard Kwasniewski 2016)
  6. Re: [WebDNA] Combining searches (Terry Wilson 2016)
  7. Re: [WebDNA] Combining searches (Rich Kwas 2016)
  8. Re: [WebDNA] Combining searches (Terry Wilson 2016)
  9. Re: [WebDNA] Combining searches (Stuart Tremain 2016)
  10. Re: [WebDNA] Combining searches (Rich Kwas 2016)
  11. Re: [WebDNA] Combining searches (Stuart Tremain 2016)
  12. [WebDNA] Combining searches (Rich Kwas 2016)
  13. Re: [WebDNA] Nested Searches (Stephen Braun 2013)
  14. Re: [WebDNA] Nested Searches (WebDNA 2013)
  15. Re: [WebDNA] Nested Searches ("Brian B. Burton" 2013)
  16. Re: [WebDNA] Nested Searches (Eddie Z 2013)
  17. Re: [WebDNA] Nested Searches (Stephen Braun 2013)
  18. Re: [WebDNA] Nested Searches ("Terry Wilson" 2013)
  19. Re: [WebDNA] Nested Searches (Stuart Tremain 2013)
  20. Re: [WebDNA] Nested Searches (Stephen Braun 2013)
  21. RE: [WebDNA] Nested Searches ("Gary Krockover" 2013)
  22. RE: [WebDNA] Nested Searches ("Terry Nair" 2013)
  23. [WebDNA] Nested Searches (Stephen Braun 2013)
  24. Re: [WebDNA] Combining searches with blank and zero values? (Ronald Kirkland 2011)
  25. Re: [WebDNA] Combining searches with blank and zero values? (Dan Strong 2011)
  26. Re: [WebDNA] Combining searches with blank and zero values? (Ronald Kirkland 2011)
  27. Re: [WebDNA] Combining searches with blank and zero values? (Govinda 2011)
  28. Re: [WebDNA] Combining searches with blank and zero values? (Govinda 2011)
  29. Re: [WebDNA] Combining searches with blank and zero values? (Dan Strong 2011)
  30. Re: [WebDNA] Combining searches with blank and zero values? (William DeVaul 2011)
  31. Re: [WebDNA] Combining searches with blank and zero values? (Dan Strong 2011)
  32. Re: [WebDNA] Combining searches with blank and zero values? (Dan Strong 2011)
  33. Re: [WebDNA] Combining searches with blank and zero values? (Govinda 2011)
  34. [WebDNA] Combining searches with blank and zero values? (William DeVaul 2011)
  35. Re: Or Searches ( Donovan Brooke 2004)
  36. Or Searches ( "Jesse Crofoot" 2004)
  37. Re: hideif/showif causes error if wrapped around searches ( "WebDna @" 2003)
  38. Re: hideif/showif causes error if wrapped around searches ( Chris List Recipient 2003)
  39. Re: hideif/showif causes error if wrapped around searches ( "WebDna @" 2003)
  40. Re: hideif/showif causes error if wrapped around searches ( Chris List Recipient 2003)
  41. Re: hideif/showif causes error if wrapped around searches ( "Scott Anderson" 2003)
  42. Re: hideif/showif causes error if wrapped around searches ( Terry Wilson 2003)
  43. Re: hideif/showif causes error if wrapped around searches ( "Gary Krockover" 2003)
  44. Re: hideif/showif causes error if wrapped around searches ( Matthew A Perosi 2003)
  45. Re: hideif/showif causes error if wrapped around searches ( "Gary Krockover" 2003)
  46. Re: hideif/showif causes error if wrapped around searches ( "WebDna @" 2003)
  47. Re: hideif/showif causes error if wrapped around searches ( "Gary Krockover" 2003)
  48. Re: hideif/showif causes error if wrapped around searches ( "WebDna @" 2003)
  49. Re: hideif/showif causes error if wrapped around searches ( "Dan Strong" 2003)
  50. Re: hideif/showif causes error if wrapped around searches ( "Dan Strong" 2003)
  51. Re: hideif/showif causes error if wrapped around searches ( "WebDna @" 2003)
  52. Re: hideif/showif causes error if wrapped around searches ( "Gary Krockover" 2003)
  53. Re: hideif/showif causes error if wrapped around searches ( Terry Wilson 2003)
  54. hideif/showif causes error if wrapped around searches ( "Gary Krockover" 2003)
  55. Re: About the hyphen in searches (Brian Fries 2003)
  56. About the hyphen in searches (Claude Gelinas 2003)
  57. Re: AND/OR searches in WebCat 3.07 (Marko Bernyk 2003)
  58. Re: AND/OR searches in WebCat 3.07 (Tim Robinson 2003)
  59. Re: AND/OR searches in WebCat 3.07 (Donovan 2003)
  60. Re: AND/OR searches in WebCat 3.07 (Gary Krockover 2003)
  61. Re: AND/OR searches in WebCat 3.07 (Stuart Tremain 2003)
  62. AND/OR searches in WebCat 3.07 (Marko Bernyk 2003)
  63. Re: shownext and searches (Terry Wilson 2002)
  64. Re: shownext and searches (Gary Krockover 2002)
  65. Re: shownext and searches (Kenneth Grome 2002)
  66. Re: shownext and searches (Gary Krockover 2002)
  67. Re: shownext and searches (Kenneth Grome 2002)
  68. Re: shownext and searches (Terry Wilson 2002)
  69. shownext and searches (Lester Emo 2002)
  70. Dates and range searches (Ken MacMurchy 2002)
  71. FYI: Store / Dealer locators & Location-based searches (David M. Dantowitz 2001)
  72. Re: Writing custom WebCat searches?? (Parker 2000)
  73. Re: Writing custom WebCat searches?? (John Hill 2000)
  74. Writing custom WebCat searches?? (Parker 2000)
  75. Re: Writing custom WebCat searches?? (Brian Boegershausen 2000)
  76. Re: Writing custom WebCat searches?? (Brian Boegershausen 2000)
  77. Re: Word-And searches (John Hill 2000)
  78. Re: Word-And searches (Rónán 2000)
  79. Re: Word-And searches (John Hill 2000)
  80. Word-And searches (Rónán 2000)
  81. Re: SEARCHES (Arturo Vargas 2000)
  82. Re: SEARCHES (John Butler 2000)
  83. SEARCHES (Arturo Vargas 2000)
  84. Re: Summary Searches (WebDNA Support 2000)
  85. Re: Summary Searches (Chuck Rice 2000)
  86. Re: Summary Searches (WebDNA Support 2000)
  87. Summary Searches (Chuck Rice 2000)
  88. Re[3]: searches with dash, period etc. (back form politenes (jpeacock@univpress.com 2000)
  89. Re: politeness (was Re: searches with dash...) Please Read (Kim Ingram 2000)
  90. Re: politeness (was Re: searches with dash...) Please Read (Stuart Tremain 2000)
  91. Re: politeness (was Re: searches with dash...) Please Read ( 2000)
  92. Re: politeness (was Re: searches with dash...) Please Read (Kenneth Grome 2000)
  93. Re: politeness (was Re: searches with dash...) Please Read (John Hill 2000)
  94. Re: searches with dash, period etc. (John Bennett 2000)
  95. Re: searches with dash, period etc. (John Hill 2000)
  96. Re: politeness (was Re: searches with dash...) Please Read (Mike Davis 2000)
  97. Re[2]: searches with dash, period etc. (back form politenes (Marty Schmid 2000)
  98. Re[2]: searches with dash, period etc. (back form politenes (jpeacock@univpress.com 2000)
  99. Re: searches with dash, period etc. (back form politeness) (John Hill 2000)
  100. Re: searches with dash, period etc. (back form politeness) (Marty Schmid 2000)
  101. Re: politeness (was Re: searches with dash...) Please Read (John Hill 2000)
  102. Re: politeness (was Re: searches with dash...) (The Mooseman 2000)
  103. Re: politeness (was Re: searches with dash...) (Chris Vargas 2000)
  104. Re: searches with dash, period etc. (Marty Schmid 2000)
  105. Re: searches with dash, period etc. (Kenneth Grome 2000)
  106. Re: searches with dash, period etc. (Joseph D'Andrea 2000)
  107. Re: searches with dash, period etc. (John Hill 2000)
  108. Re: searches with dash, period etc. (John Hill 2000)
  109. Re: searches with dash, period etc. (Kenneth Grome 2000)
  110. searches with dash, period etc. (John Bennett 2000)
  111. Re: Physical Proximity searches (Joseph D'Andrea 2000)
  112. Re: Physical Proximity searches (Joseph D'Andrea 2000)
  113. Re: Physical Proximity searches (jpeacock@univpress.com 2000)
  114. Physical Proximity searches (Mike Davis 2000)
  115. Re: Generating Searches on the fly? (Philip Edell 1999)
  116. Re: Generating Searches on the fly? (Joseph D'Andrea 1999)
  117. Generating Searches on the fly? (Philip Edell 1999)
  118. Multiple searches on a single page / random record from full database? (webcat 1999)
  119. Re: Nested searches (Tim Taylor 1998)
  120. Re: Nested searches (PCS Technical Support 1998)
  121. Nested searches (Tim Taylor 1998)
  122. Re: Combining Searches (PCS Technical Support 1998)
  123. Combining Searches (Steve Rosenbaum 1998)
  124. Re: Nesting searches. (John Hill 1998)
  125. Nesting searches. (Mícheál O Sé 1998)
  126. Re: Mixing and/or in searches (Michael Winston 1998)
  127. Re: Mixing and/or in searches (Christer Olsson 1998)
  128. Re: Mixing and/or in searches (Kenneth Grome 1998)
  129. Mixing and/or in searches (Michael Winston 1998)
sorry I used a code from a page that some one else built a while ago. but I already fixed the problem thank you. Art. -----Original Message----- From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of John Butler Sent: Thursday, June 15, 2000 6:20 PM To: WebCatalog Talk Subject: Re: SEARCHES Art is this code generated by storebuilder or did you write it from scratch? Or did you modify storebuilder code? It may help me appreciate your level of skill as I try to wade thru and guess what is your problem exactly... (did you break storebuilder code, or just not write your own well at first...)I could be totally off the mark, but I would assume you want your opening [search] tag on details.tpl to be- [search db=catalog.txt&eqphotonamedatarq=[url][photoname][/url]](take out any linebreaks added by email)and not- [search db=catalog.txt&eqdescriptiondatarq=[description]&photonamesumm=t&asdescripti onsort=1](otherwise where is the value for [description] coming from? The link(s) generated from the results2.tpl search do not pass the var 'description'. And what if two descriptions happen to be the same in the db? Isn't it better to search by something you know will be unique? - like 'photoname'?break down each param of the search into its pieces seperated by the &'s and ask yourself do I know exactly what that part is doing? If not then look it up in the docs to see what it does. And if you need to restrict your search by some criteria, then you likewise look up in the docs for ideas how to build it.Also in case that is ALL the code in the details.tpl form, you don't seem to be submitting anything...? There is zero input posting to the shoppingcart.tpl.HTH -JohnArturo Vargas wrote:> Please help, > > I am driving my self crazy trying to use logic to solve this problem: > > In my site I have to search a data base =catalog.txt > > shop.tpl - select from list of last names = search for last names from field > category (this is easy it works fine) > > results.tpl - select from list of picture types = search for picture type > from field subcategory (this works fine as well) > > results2.tpl - select from a group of images = search for image from field > photoname this works fine as well) > > ----My problem starts right here----- > > details.tpl has to display the picture that was chosen in results.tpl and > give me a list of photo sizes (this is not working and I am not sure why) > > this are the codes I am using in results2.tpl and details.tpl > > results2.tpl > > > > > > Select the picture you are interested on > [search > db=catalog.txt&eqsubcategorydatarq=[subcategory]&photonamesumm=t&asphotoname > sort=1] > [founditems] > [cart]&photoname=[url][photoname][/url]> > > > [/founditems] > [/search] > > > > details.tpl > > > >
> [search > db=catalog.txt&eqdescriptiondatarq=[description]&photonamesumm=t&asdescripti > onsort=1] > [founditems] > > Last Name:[category] > > Size:[description] > > > > [/founditems] > [/search] >
> > > > any suggestions??? > > ------------------------------------------------------------- > 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 > Web Archive of this list is at: http://search.smithmicro.com/ ------------------------------------------------------------- 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 Web Archive of this list is at: http://search.smithmicro.com/ ------------------------------------------------------------- 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 Web Archive of this list is at: http://search.smithmicro.com/ Arturo Vargas

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:

Webmerchant (1999) SKU generator? (1998) Blocking form spam (2006) Introduction/Tutorial/QuickStart (1997) WebCat2 - [format thousands] (1997) Date AND time (2001) Autoreturn Submit? (1997) Error 11 (1996) ASP and Web DNA (1998) Date Math bug (1998) Are they really global tags? (2002) [date] for today's date, while inside old order file (1998) [WebDNA] No more SQL in 7.1? (2012) Sku numbers (1997) OT: Too many lines too add in one go (2003) Date problems-more (1997) What am I missing (1997) [Cart] ... (1997) [WebDNA] Send Mail and Outlook Express (2008) Euro WebDNA Conference (2004)