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 MacSultantsProfessional Solutions for Computer Systems
Associated Messages, from the most recent to the oldest:
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 MacSultantsProfessional 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)