Re: search question
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 39823
interpreted = N
texte = Have you tried [interpret] ? if not you may want to try that.[interpret][[sign]][/interpret]if sign=scorpio you would display the value of [scorpio] from the database provided scorpio is a component of the same record as signHTH= Anup Setty----- Original Message ----- From: Dale Therio
To: WebCatalog Talk Sent: Thursday, November 01, 2001 9:50 AM 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]&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. > > 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 [interpret] ? if not you may want to try that.[interpret][[sign]][/interpret]if sign=scorpio you would display the value of [scorpio] from the database provided scorpio is a component of the same record as signHTH= Anup Setty----- Original Message ----- From: Dale Therio To: WebCatalog Talk Sent: Thursday, November 01, 2001 9:50 AM 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]&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. > > 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/
Anup Setty
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:
Falsifying [BROWSERNAME] (1998)
best way to store prefs (1998)
converchars in sendmail context.... (2004)
[BULK] [WebDNA] Happy St. Patricks Day WEBDNA (2018)
Um...how do I ask this? (1999)
Search probl. since change WebCatalog from 2.1.3 to 3.0 (1998)
WebCatalog2 Feature Feedback (1996)
WebCat/PDF Integration Time Est (2000)
[WebDNA] Setting secure cookie (2009)
mySQL --- problem?? (2004)
Paths (2000)
Fwd: FW: Purchase Command error (1997)
rename a file (1997)
WebDNA vs PHP (2003)
Day of the week (2006)
Ken's Data Manager (finally available I think ...) (2005)
Open Databases on Restart (1999)
Separate SSL Server (1997)
Strange intermittent WebDNA problems (2008)
Newbie search question (between two dates) (2001)