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:
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)