Re: search question
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 39832
interpreted = N
texte = Rob,Thanks for catching the error in my search the freqDate wassupposed to be freqData :)You are correct on the field names. I don't need to search onthe sign info, the zodiacdate and freq fields give me the properrecord (once I fix the error you point out).I need to display the content of the field for the sig asappropriate.Basically the main page loads, determines today's date.Determines what sign you have if born today, then wants to lookinto the database for today's horoscope and display the properhoroscope for people born today.So I determine today's sign, and find the proper record, but nowneed to display one particular field from the record.Maybe I need to stick my test for the sign within the founditems loop. I will give that a try next.DaleOn Thu, 01 Nov 2001 09:50:38 -0600 Rob Marquardt
wrote:> 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 Design> > 800 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:
Rob,Thanks for catching the error in my search the freqDate wassupposed to be freqData :)You are correct on the field names. I don't need to search onthe sign info, the zodiacdate and freq fields give me the properrecord (once I fix the error you point out).I need to display the content of the field for the sig asappropriate.Basically the main page loads, determines today's date.Determines what sign you have if born today, then wants to lookinto the database for today's horoscope and display the properhoroscope for people born today.So I determine today's sign, and find the proper record, but nowneed to display one particular field from the record.Maybe I need to stick my test for the sign within the founditems loop. I will give that a try next.DaleOn Thu, 01 Nov 2001 09:50:38 -0600 Rob Marquardt wrote:> 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 Design> > 800 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/
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:
Max Record length restated as maybe bug (1997)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
Using Cookie for client specific info? (1997)
How do you hide [math]stuff[/math] (1997)
[WebDNA] Error 500 with =?UTF-8?Q?SUMM=3DT?= (2017)
Re:2nd WebCatalog2 Feature Request (1996)
Database access (2003)
[NT] ie 4.0 required (1997)
windows file upload = weirdness (2004)
Allowed fields in formulas.db (1998)
Showif, Hideif reverse logic ? (1997)
Ok here is a question? (1997)
Help name our technology! (1997)
Email (1998)
2.1b3 --> way slow (1997)
BR (1997)
need help with textA field (1998)
Price + Texte (1999)
AD Error Msg (1997)
WebCat2 as a chat server? (1997)