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] fromthe database provided scorpio is a component of the samerecord as signHTH= Anup Setty----- Original Message -----From: Dale Therio
To: WebCatalog Talk Sent: Thursday, November 01, 2001 9:50 AMSubject: 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.>> [searchdb=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] fromthe database provided scorpio is a component of the samerecord as signHTH= Anup Setty----- Original Message -----From: Dale Therio To: WebCatalog Talk Sent: Thursday, November 01, 2001 9:50 AMSubject: 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.>> [searchdb=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:
What is WebDNA (1997)
More on the email templates (1997)
Hideif / Showif (1998)
Remove Multiple Line Items (2005)
Enhancement Request for WebCatalog-NT (1996)
problem 'building' field names (2000)
Problems with v4.01 email (2000)
[WebDNA] WebDNA code validator (2011)
OT: 800x600 (2003)
f2 download problems (1997)
What is the default seed for the encrypt context? (2000)
WebCat and Personal Web Server (1998)
unable to launch acgi in WebCat (1997)
transferring values (1998)
sendmail and accented characters (1998)
Where is f2? (1997)
Ok here is a question? (1997)
all records returned. (1997)
[foundItems] context question --returns some fields but not others-- (2000)
2.0 Info (1997)