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 elsebut a suggestion,why don't you do the search twice, in the first search you willfind out the sign=scorpio or whatever that might be, thenassign it to a new variable (not really necessary) theSign=[sign] anduse this result and the date to search and display the valueof scorpio? Will this work for you?= Anup Setty----- Original Message -----From: Dale Therio
To: WebCatalog Talk Sent: Thursday, November 01, 2001 10:52 AMSubject: 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:
I thought [interpret] should do the trick, can't think of anything elsebut a suggestion,why don't you do the search twice, in the first search you willfind out the sign=scorpio or whatever that might be, thenassign it to a new variable (not really necessary) theSign=[sign] anduse this result and the date to search and display the valueof scorpio? Will this work for you?= Anup Setty----- Original Message -----From: Dale Therio To: WebCatalog Talk Sent: Thursday, November 01, 2001 10:52 AMSubject: 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)