Re: search question
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 39828
interpreted = N
texte = on 11/1/01 8:50 am, Dale Therio at stuff@colony.net so noted...> I need WC to interpret the value to be the field name. > > [search db=databases/zodiac.db&eqZodiacDateDatarq=[math]{[date]}[/math] > &eqFreqDaterq=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.If I'm reading this correctly, the value for [sign] has been set *before* your search?Does your database look something like this?ZodiacDate FreqDate Aries Tarus Gemini (etc...) You can include [sign] as part of the search itself.[search db=databases/zodiac.db&eqZodiacDateDatarq=[math]{[date]}[/math]&eqFreqDateDa tarq=1&ne[sign]Datarq=[blank]](note that FreqDate was missing the Data suffix in the search string) ... that is if I'm interpreting the problem right -- filling in a number of blanks here. : ) Rob Marquardt Designer/Resident Wirehead Toast Design800 Washington Avenue North Minneapolis MN 55401 612.330.9863 v 612.321.9424 f http://www.toastdesign.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:
on 11/1/01 8:50 am, Dale Therio at stuff@colony.net so noted...> I need WC to interpret the value to be the field name. > > [search db=databases/zodiac.db&eqZodiacDateDatarq=[math]{[date]}[/math] > &eqFreqDaterq=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.If I'm reading this correctly, the value for [sign] has been set *before* your search?Does your database look something like this?ZodiacDate FreqDate Aries Tarus Gemini (etc...) You can include [sign] as part of the search itself.[search db=databases/zodiac.db&eqZodiacDateDatarq=[math]{[date]}[/math]&eqFreqDateDa tarq=1&ne[sign]Datarq=[blank]](note that FreqDate was missing the Data suffix in the search string) ... that is if I'm interpreting the problem right -- filling in a number of blanks here. : ) Rob Marquardt Designer/Resident Wirehead Toast Design800 Washington Avenue North Minneapolis MN 55401 612.330.9863 v 612.321.9424 f http://www.toastdesign.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/
Rob Marquardt
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:
AutoCommit Preference? (1998)
Problems with ^ could be solved with [REPLACE CHARACTERS] (1997)
[WebDNA] Getting to know ARRAY (2014)
Strange intermittent WebDNA problems (2008)
Undeliverable Mail (1997)
[WebDNA] Sorry WebDNA server not running (2014)
the dreaded unitShipCost (2003)
Credit Card Number checking (1997)
Field name-subcategory (1997)
Summing fields (1997)
FlushDatabase Suggestion (1998)
emailer settings and control questions (1997)
[ConvertChars] problem (1997)
Word wrapping (1997)
5.0 features (2001)
[WebDNA] includes with includes (2009)
OT: Urgent help with Windows and Javascript (2003)
[append] vs. [appendfile] delta + question? (1997)
Caching [include] files ... (1997)
emailer (1997)