Re: search question
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 39820
interpreted = N
texte = have you tried using [interpret]?[searchdb=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/>-------------------------------------------------------------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:
have you tried using [interpret]?[searchdb=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/>-------------------------------------------------------------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/
Jimmi Kristensen
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:
Ok here is a question? (1997)
WCS Newbie question (1997)
copyfile (2003)
Friendly , quick 'security' check, please (2003)
problems with WebCat-Plugin ()
Emailer setup (1997)
Question (1997)
Best way to add data to .db (1999)
Displaying raw values (1998)
[include] affect on filepaths for links? (1997)
back button problem (1999)
summ=T (2003)
Sorting Numbers (1997)
sorting on date in search (2000)
Re2: frames & carts (1997)
Nested tags count question (1997)
[WebDNA] 6.2 Monitor (2012)
RE: Fishing: anyone on this group willing to do support? (1998)
tricky embedded[showifs/hideifs] (w/ code.. long) (2000)
Something about defining variables (1998)