Re: search question

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 39820
interpreted = N
texte = have you tried using [interpret]?[search db=databases/zodiac.db&eqZodiacDateDatarq=[math]{[date]}[/math]&eqFreqDaterq =1] [math show=f]found=[numfound][/math] [showif [found]=1] [founditems] [convertchars][interpret][sign][/interpret][/convertchars] [/founditems] [/showif] [/search]---------------------- Jimmi Kristensen WebDNA Developer jimmi@euroteam.com http://euroteam.com ---------------------- > -----Original Message----- > From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On > Behalf Of Dale Therio > Sent: 1. november 2001 15:51 > To: WebCatalog Talk > Subject: search question > > > Hello, > > I can't figure this search out. > > I am using a series of showifs to determine a particular value. > this works fine. Following this, I do a search based on 2 > criteria (the first value is not one of them). > > I can get the record needed just fine based on my search. > However, my problem is that the field from the record found that > I need to display is the value I determined using the showifs. I > can't seem to get the field to display, only the value which > equals the name of the field I want. > > I need WC to interpret the value to be the field name. > > [search > db=databases/zodiac.db&eqZodiacDateDatarq=[math]{[date]}[/math]&eq > FreqDaterq=1] > [math show=f]found=[numfound][/math] > [showif [found]=1] > [founditems] > [convertchars][sign][/convertchars] > [/founditems] > [/showif] > [/search] > > I detemine the needed value for [sign] using the showifs (to > find out what todays's zodiac sign is). > > The database has fields for date, freq, and the horoscopes for > each sign for this day. > > So for today I determine that if you were born today your sign > is scorpio, I search the database to find today's set of > horoscopes and find that record. I now need to display only the > field for scorpio. > > I can't do a lookup as I need to require 2 fields, the date and > freq as I have daily, weekly and monthly horoscopes in this > database. > > So, any idea on how to get a text value to be interpreted as a > field name? > > Thanks > > Dale > > ------------------------------------------------------------- > 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] Search question (frank@cwolfe.com 2013)
  2. Re: [WebDNA] Search question ("Terry Wilson" 2013)
  3. RE: [WebDNA] Search question ("Terry Nair" 2013)
  4. Re: [WebDNA] Search question (Lawrence Banahan 2013)
  5. [WebDNA] Search question (frank@cwolfe.com 2013)
  6. Re: [WebDNA] Search question (Steve Craig 2012)
  7. Re: [WebDNA] Search question (Toby Cox 2012)
  8. Re: [WebDNA] Search question (Steve Craig 2012)
  9. Re: [WebDNA] Search question (Steve Craig 2012)
  10. Re: [WebDNA] Search question (Toby Cox 2012)
  11. [WebDNA] Search question (Steve Craig 2012)
  12. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (Govinda 2011)
  13. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (Donovan Brooke 2011)
  14. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (Steve Raslevich -Northern Sound 2011)
  15. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (Kenneth Grome 2011)
  16. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (christophe.billiottet@webdna.us 2011)
  17. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (Govinda 2011)
  18. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (christophe.billiottet@webdna.us 2011)
  19. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (christophe.billiottet@webdna.us 2011)
  20. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (Govinda 2011)
  21. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (Donovan Brooke 2011)
  22. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (Steve Raslevich -Northern Sound 2011)
  23. Re: [WebDNA] SEARCH question (Stuart Tremain 2011)
  24. Re: [WebDNA] SEARCH question (Kenneth Grome 2011)
  25. Re: [WebDNA] SEARCH question (Donovan Brooke 2011)
  26. Re: [WebDNA] SEARCH question (christophe.billiottet@webdna.us 2011)
  27. Re: [WebDNA] SEARCH question (Govinda 2011)
  28. Re: [WebDNA] SEARCH question (Donovan Brooke 2011)
  29. Re: [WebDNA] SEARCH question (christophe.billiottet@webdna.us 2011)
  30. Re: [WebDNA] SEARCH question (Stuart Tremain 2011)
  31. Re: [WebDNA] SEARCH question (Steve Raslevich 2011)
  32. [WebDNA] SEARCH question (Stuart Tremain 2011)
  33. Re: [WebDNA] Search Question (Tony Miller 2009)
  34. Re: [WebDNA] Search Question (John Butler 2009)
  35. Re: [WebDNA] Search Question (Kenneth Grome 2009)
  36. Re: [WebDNA] Search Question (Tony Miller 2009)
  37. Re: [WebDNA] Search Question ( 2009)
  38. Re: [WebDNA] Search Question (Tony Miller 2009)
  39. Re: [WebDNA] Search Question (Kenneth Grome 2009)
  40. Re: [WebDNA] Search Question ( 2009)
  41. [WebDNA] Search Question (Tony Miller 2009)
  42. Search question with a lookup (3 dbs) ( Palle Bo Nielsen 2004)
  43. Re: Another Search Question ( Donovan Brooke 2003)
  44. Re: Another Search Question ( Gary Krockover 2003)
  45. Re: Another Search Question ( Donovan Brooke 2003)
  46. Re: Another Search Question ( Tim Robinson 2003)
  47. Another Search Question ( Donovan Brooke 2003)
  48. Re: Search Question ( "Alain Russell" 2003)
  49. Search Question ( Jesse Proudman 2003)
  50. Re: Search Question ( Jesse Proudman 2003)
  51. Re: Search Question ( "Dan Strong" 2003)
  52. Re: Search Question ( Mark Derrick 2003)
  53. Search Question ( Jesse Proudman 2003)
  54. Re: Search Question ( 2003)
  55. Re: Search Question ( Daryl Mitchell 2003)
  56. Re: Search Question ( 2003)
  57. Re: Search Question ( Daryl Mitchell 2003)
  58. Search Question ( 2003)
  59. Re: Search Question (Matthew A Perosi 2003)
  60. Re: Search Question (Kimberly D. Walls 2003)
  61. Search Question (stephen 2003)
  62. Re: search question (Dale Therio 2001)
  63. Re: search question (Dale Therio 2001)
  64. Re: search question (Vincent Medina 2001)
  65. Re: search question (Dale Therio 2001)
  66. Re: search question (Christer Olsson 2001)
  67. Re: search question (Rob Marquardt 2001)
  68. Re: search question (Dale Therio 2001)
  69. Re: search question (Anup Setty 2001)
  70. Re: search question (Vincent Medina 2001)
  71. Re: search question (Dale Therio 2001)
  72. Re: search question (Anup Setty 2001)
  73. Re: search question (John Peacock 2001)
  74. Re: search question (Dale Therio 2001)
  75. Re: search question (Jimmi Kristensen 2001)
  76. search question (Dale Therio 2001)
  77. Re: Newbie search question (between two dates) (Kenneth Grome 2001)
  78. Re: Newbie search question (between two dates) (Clint Davis 2001)
  79. Re: Newbie search question (between two dates) (Matthew Bohne 2001)
  80. Re: Newbie search question (between two dates) (Andrew Simpson 2001)
  81. Re: Newbie search question (between two dates) (Glenn Busbin 2001)
  82. Re: Newbie search question (between two dates) (Andrew Simpson 2001)
  83. Re: Newbie search question (between two dates) (Brian Fries 2001)
  84. Re: Newbie search question (between two dates) (Brian Fries 2001)
  85. Re: Newbie search question (between two dates) (Andrew Simpson 2001)
  86. Re: Newbie search question (between two dates) (Glenn Busbin 2001)
  87. Re: Newbie search question (between two dates) (Andrew Simpson 2001)
  88. Re: Newbie search question (between two dates) (Glenn Busbin 2001)
  89. Re: Newbie search question (between two dates) (Andrew Simpson 2001)
  90. Newbie search question (between two dates) (Matthew Bohne 2001)
  91. Re: Search Question (John Butler 2000)
  92. Re: Search Question (Mark Derrick 2000)
  93. Re: Search Question (John Butler 2000)
  94. Re: Search Question (Alex Cheparev 2000)
  95. Re: Search Question (Mark Derrick 2000)
  96. Re: Search Question (Kim Ingram 2000)
  97. Re: Search Question (Paul Fowler 2000)
  98. Re: Search Question (Kim Ingram 2000)
  99. Search Question (Alex Cheparev 2000)
  100. Re: Search Question (Nathaniel Hadley 2000)
  101. Re: Search Question (Jason Tyler 2000)
  102. Search Question (Nathaniel Hadley 2000)
  103. Re: Search Questions (Brady J. Horenstein 2000)
  104. Re: Search Questions (PCS Technical Support 2000)
  105. Re: Search Questions (Bob Minor 2000)
  106. Re: Search Questions (Kenneth Grome 2000)
  107. Re: Search Questions (Paul Fowler 2000)
  108. Search Questions (Brady J. Horenstein 2000)
  109. Re: Search question (Kenneth Grome 1999)
  110. Search question (Conley Hanson 1999)
  111. Re: Newbie - Search question (Julian Clayton 1998)
  112. Re: Newbie - Search question (Mícheál O Sé 1998)
  113. Newbie - Search question (Nitai 1998)
  114. Re: Another search question please... (PCS Technical Support 1998)
  115. Another search question please... (Scott Szretter 1998)
  116. Search Question (Scott Szretter 1998)
  117. Re: Forms Search Questions (Grant Hulbert 1997)
  118. Re: Forms Search Questions (Kenneth Grome 1997)
  119. Re: Forms Search Questions (Jacques VERNAY 1997)
  120. Re: Forms Search Questions (Christer Olsson 1997)
  121. Re: Forms Search Questions (Christer Olsson 1997)
  122. Re: Forms Search Questions (Kenneth Grome 1997)
  123. Forms Search Questions (Richard Shapiro 1997)
have you tried using [interpret]?[search db=databases/zodiac.db&eqZodiacDateDatarq=[math]{[date]}[/math]&eqFreqDaterq =1] [math show=f]found=[numfound][/math] [showif [found]=1] [founditems] [convertchars][interpret][sign][/interpret][/convertchars] [/founditems] [/showif] [/search]---------------------- Jimmi Kristensen WebDNA Developer jimmi@euroteam.com http://euroteam.com ---------------------- > -----Original Message----- > From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On > Behalf Of Dale Therio > Sent: 1. november 2001 15:51 > To: WebCatalog Talk > Subject: search question > > > Hello, > > I can't figure this search out. > > I am using a series of showifs to determine a particular value. > this works fine. Following this, I do a search based on 2 > criteria (the first value is not one of them). > > I can get the record needed just fine based on my search. > However, my problem is that the field from the record found that > I need to display is the value I determined using the showifs. I > can't seem to get the field to display, only the value which > equals the name of the field I want. > > I need WC to interpret the value to be the field name. > > [search > db=databases/zodiac.db&eqZodiacDateDatarq=[math]{[date]}[/math]&eq > FreqDaterq=1] > [math show=f]found=[numfound][/math] > [showif [found]=1] > [founditems] > [convertchars][sign][/convertchars] > [/founditems] > [/showif] > [/search] > > I detemine the needed value for [sign] using the showifs (to > find out what todays's zodiac sign is). > > The database has fields for date, freq, and the horoscopes for > each sign for this day. > > So for today I determine that if you were born today your sign > is scorpio, I search the database to find today's set of > horoscopes and find that record. I now need to display only the > field for scorpio. > > I can't do a lookup as I need to require 2 fields, the date and > freq as I have daily, weekly and monthly horoscopes in this > database. > > So, any idea on how to get a text value to be interpreted as a > field name? > > Thanks > > Dale > > ------------------------------------------------------------- > 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/ Jimmi Kristensen

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:

Workaround for Emailer doubled bcc messages (1998) Not really WebCat (1997) [shownext] and descending order (1997) limitation found on group searching (1997) No luck with taxes (1997) same bill to and ship to? (1998) Lost Password? (2002) WebCatalog NT beta 18 problem (1997) Where's Cart Created ? (1997) WebDNA-Talk Digests (1997) More to Expire (1998) Location of Browser Info.txt file (1997) Getting total number of items ordered (1997) WebCatalog2 Feature Feedback (1996) Date range Problem (2006) Help name our technology! (1997) Generating Report Totals (1997) [shownext] and descending order (1997) cart number tracking (1998) Great product and great job ! (1997)