Searching help needed

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 19956
interpreted = N
texte = Hi,I have a databse of restaurants, each of which has a CUISINE field and a STATE field as well as a bunch of other descriptive fields. I want to be able to search for the STATE and display the CUISINEs that are available in that state.If I search for the STATE and then use the [foundItems][CUISINE][/foundItems] to display the CUISINE I get the value back for each record in the database. Is there a way to get back only one?ie. If I search for Philadelphia and Philadelphia has 15 Italian and 5 Japanese and 20 Eclectic etc. records, but I only want to display a list of what kind of restaurants are available and not display Italian or whatever once for each record, how do I do this? So I would just get a listing of the CUISINES.I hope I am making sense...Please help.Thanks,- ck_______________________________________________________________ Charles Kline ckline@macsultants.com MacSultants Professional Solutions for Computer Systems Associated Messages, from the most recent to the oldest:

    
  1. Re: Searching help needed (Kenneth Grome 1998)
  2. Re: Searching help needed (PCS Technical Support 1998)
  3. Searching help needed (charles kline 1998)
Hi,I have a databse of restaurants, each of which has a CUISINE field and a STATE field as well as a bunch of other descriptive fields. I want to be able to search for the STATE and display the CUISINEs that are available in that state.If I search for the STATE and then use the [founditems][CUISINE][/foundItems] to display the CUISINE I get the value back for each record in the database. Is there a way to get back only one?ie. If I search for Philadelphia and Philadelphia has 15 Italian and 5 Japanese and 20 Eclectic etc. records, but I only want to display a list of what kind of restaurants are available and not display Italian or whatever once for each record, how do I do this? So I would just get a listing of the CUISINES.I hope I am making sense...Please help.Thanks,- ck_______________________________________________________________ Charles Kline ckline@macsultants.com MacSultants Professional Solutions for Computer Systems charles kline

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:

More on the email templates (1997) Search design (1997) WCS Newbie question (1997) WebCat2 - [format thousands] (1997) Server slowing down. (1997) NT Manual (1997) b12 cannot limit records returned and more. (1997) [TCPSend] and whois? (1999) WC2.0 Memory Requirements (1997) Great product and great job ! (1997) Running 2 two WebCatalog.acgi's (1996) [OT] Bandwidth Choking (2005) C is for cookie - that's good enough for me... (2001) popups, netscape vs explorer (1997) Re:Listfiles (1998) [WebDNA] 404 Pages (2014) Cart/Cookie question (2005) [CART] (1997) OT: Site Downloaders (2002) WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)