Re: search question
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 39821
interpreted = N
texte = Unfortunately yes I have.That might be the right general way to go, but obviously I am missing it.All I get is the name of the sign, it doesn't interpret to the field name, just the variable namehttp://www.bear.net/lifestyles/horoscopes/is the page. On Thu, 1 Nov 2001 15:55:59 Jimmi Kristensen
wrote: > > 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/
Associated Messages, from the most recent to the oldest:
Unfortunately yes I have.That might be the right general way to go, but obviously I am missing it.All I get is the name of the sign, it doesn't interpret to the field name, just the variable namehttp://www.bear.net/lifestyles/horoscopes/is the page. On Thu, 1 Nov 2001 15:55:59 Jimmi Kristensen wrote: > > 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/
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:
[WebDNA] WebDNA Showcase? (2008)
Can I invoke an ssi plugin from within a webcat page (1997)
calculating tax rates, mail order solutions and version 2 (1997)
bye bye tax rate (1998)
Shopping Cart Problem (1998)
Progress !! WAS: Trouble with formula.db (1997)
problems with 2 tags (1997)
Looking up two prices in database? (1997)
Developer Edition (2002)
problems with 2 tags (1997)
RE: Languages (1997)
Paradata/Moneris Gateway (2005)
Linux vs Jaguar (OSX) (2002)
Search in 2 or more catalogs (1997)
How To question on setting up downloads (1997)
customizing the color of user's pages (1997)
[input] [/input] (1997)
all records returned. (1997)
RE: Formulas.db + Users.db (1997)
oops private message leaked into talk list (1997)