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:

b12 cannot limit records returned and more. (1997) Problem with my orders (1998) WebDNA Solutions ... sorry! (1997) Integration? (1999) Merging databases (1997) Client-side Image Maps and WebCat? (1998) [ShowNext] (1997) More on the email templates (1997) [math] variable question (1997) Help!!!! (1997) Country & Ship-to address & other fields ? (1997) Location of Browser Info.txt file (1997) Car Database (2002) graphics server, SSL, Netscape 4.0 (off topic) (1998) Jimmy (1998) Post arguments problem mac? (1997) WebCatalog not recognizing ShoppingCarts folder (2000) ASP and Web DNA (1998) Monthly Reports (2000) Problems passing [SKU] with $Replace in 2.0 (1997)