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 basedon other criteria (namely date).So I determine which field I want to display, and store the nameof the field into a variable (how else would I do it?).Now within the founditems loop (which has found the properrecord), 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 thedatabase 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:
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 basedon other criteria (namely date).So I determine which field I want to display, and store the nameof the field into a variable (how else would I do it?).Now within the founditems loop (which has found the properrecord), 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 thedatabase 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)