search question
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 39819
interpreted = N
texte = 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?ThanksDale------------------------------------------------------------- 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:
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?ThanksDale------------------------------------------------------------- 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:
Help with Shipping Costs (1997)
E-mailer error codes (1997)
grep matching (2003)
Handy Browser Counter Tip (1997)
Variable Math (1998)
Re:PCS Customer submissions ? (1997)
dollar $ signs in database (2000)
Accented chars and emailer (1998)
Grep all content between twp p tags (2006)
2 easy questions re: [showif] and [sendmail] (1997)
Nested searches (1998)
[Webcat 2]Next (1997)
Forcing a NEWCART (1997)
random in arizona (2003)
Obscure Question of the day (1997)
WebCat with WebTen (1998)
Re[3]: 2nd WebCatalog2 Feature Request (1996)
Where's Cart Created ? (1997)
OT : Best book for OSX (2002)
Re(2): typhoon ? (2003)