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:
Active Server Code... (1998)
Uniqueness of [cart] - revisited (2004)
Multiple fields on 1 input (1997)
Authenticate (1997)
WebDNA 6 on RH - Can you send me your packages list? (2006)
verify online (1997)
Problem during evaluation of WebCatalog (1998)
Javascript Form Validation (2002)
WebCat2 Append problem (B14Macacgi) (1997)
Convert words (2002)
page redirect in webDNA (1997)
Need relative path explanation (1997)
WebCat2: Formulas.db question (1997)
Fedora Core 2 (2005)
webten vs. webstar (1998)
Big Databases (1997)
international time (1997)
unable to run webcatalog locally (1998)
[OT] Templates (For Sale) sites (2004)
All choices on IE different than Netscape (1997)