Re: search question

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 39826
interpreted = N
texte = I thought [interpret] should do the trick, can't think of anything else but a suggestion, why don't you do the search twice, in the first search you will find out the sign=scorpio or whatever that might be, then assign it to a new variable (not really necessary) theSign=[sign] and use this result and the date to search and display the value of scorpio? Will this work for you?= Anup Setty----- Original Message ----- From: Dale Therio To: WebCatalog Talk Sent: Thursday, November 01, 2001 10:52 AM Subject: Re: search question > I do a search in a database. > > I find the record I want. > > Now I need to display only 1 particular field from that record. > > I determine which field of that record I want to display based > on other criteria (namely date). > > So I determine which field I want to display, and store the name > of the field into a variable (how else would I do it?). > > Now within the founditems loop (which has found the proper > record), I need to display only 1 specific field. > > The name of the field I need to display is stored in a variable. > > The problem is how do I get WC to dispaly the field from the > database that matches the value within this variable ? > > Dale > > On Thu, 1 Nov 2001 10:57:14 > Vincent Medina wrote: > > If I understand you correctly you want to display the name of > > the field and > > not its value? If so look at: > > > > [listdatabases] [listfields] > > > > > > -----Original Message----- > > From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On > > Behalf Of Dale Therio > > Sent: Thursday, November 01, 2001 10:33 AM > > To: WebCatalog Talk > > Subject: Re: search question > > > > > > That isn't the problem. > > > > I need to determine which field to display from the database. > > > > So I determine the field that I need to display using > > showifs, > > but can't get the field to display within the [founditems] > > loop. > > > > the variable name is [sign] the VALUE of the variable is the > > name of the field in the database I want to display. > > > > I need to calculate the proper field to display based on > > todays > > date. > > > > e.g. today is November 1st, so the sign is scorpio, the field > > in > > the database I wish to display is called scorpio. The name of > > the variable I am storing the name of the field I need is > > called > > [sign]. Adding a _ won't do anything. > > > > On Thu, 01 Nov 2001 10:23:28 > > John Peacock wrote: > > > Dale Therio wrote: > > > > > > > > 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). > > > > > > > > > > [snipped] > > > > > > > So, any idea on how to get a text value to be interpreted > > > as a > > > > field name? > > > > > > Don't use the same name for fields and formvariables. This > > > would immediately > > > solve your problem and is good policy going forward. One > > way > > > people have > > > suggested in the past is to prefix an underscore on the > > form > > > variables. > > > > > > HTH > > > > > > John > > > > > > -- > > > John Peacock > > > Director of Information Research and Technology > > > Rowman & Littlefield Publishing Group > > > 4720 Boston Way > > > Lanham, MD 20706 > > > 301-459-3366 x.5010 > > > fax 301-429-5747 > > ------------------------------------------------------------- > 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)
I thought [interpret] should do the trick, can't think of anything else but a suggestion, why don't you do the search twice, in the first search you will find out the sign=scorpio or whatever that might be, then assign it to a new variable (not really necessary) theSign=[sign] and use this result and the date to search and display the value of scorpio? Will this work for you?= Anup Setty----- Original Message ----- From: Dale Therio To: WebCatalog Talk Sent: Thursday, November 01, 2001 10:52 AM Subject: Re: search question > I do a search in a database. > > I find the record I want. > > Now I need to display only 1 particular field from that record. > > I determine which field of that record I want to display based > on other criteria (namely date). > > So I determine which field I want to display, and store the name > of the field into a variable (how else would I do it?). > > Now within the founditems loop (which has found the proper > record), I need to display only 1 specific field. > > The name of the field I need to display is stored in a variable. > > The problem is how do I get WC to dispaly the field from the > database that matches the value within this variable ? > > Dale > > On Thu, 1 Nov 2001 10:57:14 > Vincent Medina wrote: > > If I understand you correctly you want to display the name of > > the field and > > not its value? If so look at: > > > > [listdatabases] [listfields] > > > > > > -----Original Message----- > > From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On > > Behalf Of Dale Therio > > Sent: Thursday, November 01, 2001 10:33 AM > > To: WebCatalog Talk > > Subject: Re: search question > > > > > > That isn't the problem. > > > > I need to determine which field to display from the database. > > > > So I determine the field that I need to display using > > showifs, > > but can't get the field to display within the [founditems] > > loop. > > > > the variable name is [sign] the VALUE of the variable is the > > name of the field in the database I want to display. > > > > I need to calculate the proper field to display based on > > todays > > date. > > > > e.g. today is November 1st, so the sign is scorpio, the field > > in > > the database I wish to display is called scorpio. The name of > > the variable I am storing the name of the field I need is > > called > > [sign]. Adding a _ won't do anything. > > > > On Thu, 01 Nov 2001 10:23:28 > > John Peacock wrote: > > > Dale Therio wrote: > > > > > > > > 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). > > > > > > > > > > [snipped] > > > > > > > So, any idea on how to get a text value to be interpreted > > > as a > > > > field name? > > > > > > Don't use the same name for fields and formvariables. This > > > would immediately > > > solve your problem and is good policy going forward. One > > way > > > people have > > > suggested in the past is to prefix an underscore on the > > form > > > variables. > > > > > > HTH > > > > > > John > > > > > > -- > > > John Peacock > > > Director of Information Research and Technology > > > Rowman & Littlefield Publishing Group > > > 4720 Boston Way > > > Lanham, MD 20706 > > > 301-459-3366 x.5010 > > > fax 301-429-5747 > > ------------------------------------------------------------- > 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/ Anup Setty

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:

WAP (2000) OLD PROBLEM (1997) OT: Jobseekers beware... (2003) [Announce] Newest Commerce Site based on WebCatalog (1997) Re:Formulas.db / Quantity Discount problem (1998) SiteBuilder Problem (2004) please anybody help (2005) Text limits in NT version? (1997) building / customizing stores (2000) Answer: WebDelivery downloads alias, not original ? (1997) Searching for (field1 OR field2) AND field3 (2000) Unable to view next 101-200 (1997) RE: Multiple Stores and WebCatalog Prefs (1997) Stopping bad HTML propagation ? (1997) searching illegal HTML (2002) Calculating multiple shipping... (1997) Using Plug-In while running 1.6.1 (1997) W* 3.x & WebCat + WebMerchant (1998) [WebDNA] Upload file to mysql (2017) Error Lob.db records error message not name (1997)