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]&eqFreqDateDatarq=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 ofblanks here. : )Rob MarquardtDesigner/Resident WireheadToast Design800 Washington Avenue NorthMinneapolis MN 55401612.330.9863 v612.321.9424 fhttp://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]&eqFreqDateDatarq=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 ofblanks here. : )Rob MarquardtDesigner/Resident WireheadToast Design800 Washington Avenue NorthMinneapolis MN 55401612.330.9863 v612.321.9424 fhttp://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:
RE: Can a database get stomped by simultaneous access? (1997)
Nesting format tags (1997)
refreshing IE with posted .tmpl (1997)
[append] problem (1997)
Separate SSL Server (1997)
Practice runs ? (1997)
PCS Customer submissions ? (1997)
syntax question, not in online refernce (1997)
[WriteFile] problems (1997)
Beta Documentation (1997)
[Replace] really replaces? (2000)
Multiple results (2001)
Security Question (1997)
Search returns all, not 20 (1997)
[format xs] freeze (1997)
Not really WebCat (1997)
Shopping cart now bad (1997)
WCS Newbie question (1997)
two unique banners on one page (1997)
Merging databases (1997)