Re: search question
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 39827
interpreted = N
texte = Hi,Thanks for the suggestion.I did try that. Unfortunately I get [scorpio] printed to thescreen. I have to believe there is a way to determine the field you wantdisplayed and then be able to display just that field within therecord you have found.I forgot to mention before I am using WC 3.x on Mac OS.DaleOn Thu, 1 Nov 2001 10:27:32 Anup Setty
wrote:> 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 sign> > HTH> > = 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/
Associated Messages, from the most recent to the oldest:
Hi,Thanks for the suggestion.I did try that. Unfortunately I get [scorpio] printed to thescreen. I have to believe there is a way to determine the field you wantdisplayed and then be able to display just that field within therecord you have found.I forgot to mention before I am using WC 3.x on Mac OS.DaleOn Thu, 1 Nov 2001 10:27:32 Anup Setty wrote:> 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 sign> > HTH> > = 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/
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:
[WebDNA] Manual install on Manjaro and MariaDB (2017)
Design Help Needed (1998)
Another bug to squash (WebCat2b13 Mac .acgi) (1997)
Three new problems, maybe a fourth (1997)
Emailer setup (1997)
WebCat2 - Getting to the browser's username/password data (1997)
[GROUPS] followup (1997)
Shopping carts and reloading pages (1997)
ShowIf variables (1997)
ooops...WebCatalog [FoundItems] Problem - LONG - (1997)
Copy, Move, Create Folders (1998)
SSL and reg web* (1997)
Item options w/ price adjustment (1997)
Almost a there but..bye bye NetCloak (1997)
Database load balancing (2002)
[WebDNA] The Single-Vendor Commercial Open Source Business Model for WebDNA (2012)
Sendmail Excel attachment (2003)
$Quit, $CloseDatabase corrections (1997)
Subtotal help (1997)
Writing to PDF (2003)