Re: search question

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 39830
interpreted = N
texte = 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 ?DaleOn 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/ 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 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 ?DaleOn 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/ Dale Therio

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:

WebCatalog can't find database (1997) Size limit for tmpl editor ? (1997) [SHOWIF]s and empty arguments (1997) RE: Signal Raised (1997) PCS Frames (1997) WebCat for mass emailings (1997) Yet another db manager (2004) Plugin or CGI or both (1997) Cookie setting (2003) Separate SSL Server (1997) Not really WebCat (1997) [listfiles] nested in a [loop] (1998) Emailer setup (1997) WebCat for Unix?? (1997) Multiple Pulldowns (1997) where to put code (1998) Tip: upgrading to WebCatalog 3.x, fields to watch for (1999) WebCatalog can't find database (1997) Answer: WebDelivery downloads alias, not original ? (1997) NT version (1997)