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 ammissing it.All I get is the name of the sign, it doesn't interpret to thefield 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 ammissing it.All I get is the name of the sign, it doesn't interpret to thefield 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:
[referrer] -truncates at & (1998)
[ShowIf] if the varieable exists (1998)
[WebDNA] Off topic: ImageMagick (2008)
HTTP "host" header (2003)
A Global Variable (1997)
problems with 2 tags shakur (1997)
[WebDNA] [OT] WebDNA Wiki - need grammar check / suggestions (2009)
webcat NT with [dos] command (1997)
Uh...can someone help me out with the b10? (1997)
Friendly , quick 'security' check, please (2003)
WebCat2 - [include] tags (1997)
Credit card processing - UK (1997)
Formulas.db + Users.db (1997)
RE: too many nested [xxx] (1997)
problems with 2 tags (1997)
Webcat/Webmerchant (1998)
Help name our technology! (1997)
date search not working when type=date specified (2007)
cart info (1998)
Summarizing on two fields (1998)