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:
Longer .extensions with Windows? (1998)
Problems getting parameters passed into email. (1997)
Multiple prices (1997)
Q on the best way to set up a security function so users can edit records (1999)
TCPConnect / Current Temperature (2004)
two domains and one cart and database (2000)
encryption madness (2003)
AOL and referrers on target=_blank (2000)
[WebDNA] OT: WebDNA Host required (2008)
Running _every_ page through WebCat-error.html (1997)
form data submission gets truncated (1997)
dos performance (1998)
[OT] RedHat - GNOME (2004)
wrong input values? (1997)
Getting Crazy (1998)
Sending mail (was forms and variables) (1998)
[WebDNA] WebDNA Euro Hosting (2014)
Re:Emailer and encryption (1997)
Javascript and Search Results (1998)
ShowNext Context (2004)