Re: search question
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 39825
interpreted = N
texte = Try not to use the same field - form labels.-----Original Message----- From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of Dale Therio Sent: Thursday, November 01, 2001 9:51 AM 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]&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/ ------------------------------------------------------------- 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:
Try not to use the same field - form labels.-----Original Message----- From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of Dale Therio Sent: Thursday, November 01, 2001 9:51 AM 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]&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/ ------------------------------------------------------------- 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/
Vincent Medina
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:
ShippingCosts (1998)
Re1000001: Setting up shop (1997)
declined orders webmerchant not showing up? (2005)
Ken's Data Manager (finally available I think ...) (2005)
Cart Numbers (1997)
rename a file (1997)
Mac Vs WindowsNT (1997)
Add a Blog to your site. (2002)
search function (2005)
Missing orders (retrieval) after a Linux disk space cock up.... (2004)
Search for starts with and ends with? (2003)
shownext (1997)
Summing fields (1997)
[ShowIf] and empty fields (1997)
transferring values (1998)
WebCat2 several catalogs? (1997)
WebCat2: Items xx to xx shown, etc. (1997)
Uploading Files (2000)
Hard Questions ? (1997)
WebCatalog can't find database (1997)