Re: Searching multiple records for certain info
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 30462
interpreted = N
texte = Ken,Thanks for the info. I didn't do a good job of explaining. We don't know howmany of the levels we need to match before the search. The user can come tothe website and choose from 1 to (at present) 10 different levels and theyonly want to 'find' users that have all of the levels they selected.I have suggested putting a field for the different levels in one record, butthe others want to have a record for each level as we may be adding morelevels as time goes on.Thank you!Dale-- Dale Therio +49 69 263 19977 office Dresdner Kleinwort Benson Research+49 69 263 11379 fax Jürgen-Ponto-Platz 1+49 170 934 3610 mobile 60301 Frankfurt, Germany> From: Kenneth Grome
> Reply-To: (WebCatalog Talk)> Date: Thu, 13 Apr 2000 22:57:43 -1000> To: (WebCatalog Talk)> Subject: Re: Searching multiple records for certain info> >> WebCatalog 3.08 (Mac OS and WinNT)>> >> Hi folks,>> >> Database>> userID level>> 1 3>> 1 5>> 1 6>> 2 3>> 2 4>> 2 5>> 3 3>> 3 4>> 3 5>> 3 6>> >> We are trying to accomplish the following:>> >> Do a search and only return the userID of those users that have records>> containing multiple levels. e.g. search for all users that have level 3 and>> 4. which in the above example this would return users 2 and 3 only.>> >> Any ideas?> > > [search db=x.db&woleveldatarq=3]> [text]next=[founditems][userID],[/founditems][/text]> [/search]> > [search db=x.db&wouserIDdatarq=[next]&woleveldatarq=4]> [founditems]> the records you want are here ...> [/founditems]> [/search]> -- > ================================> Kenneth Grome, WebDNA Consultant> 808-737-6499 http://webdna.net> ================================> > > > -------------------------------------------------------------> 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> > -------------------------------------------------------------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
Associated Messages, from the most recent to the oldest:
Ken,Thanks for the info. I didn't do a good job of explaining. We don't know howmany of the levels we need to match before the search. The user can come tothe website and choose from 1 to (at present) 10 different levels and theyonly want to 'find' users that have all of the levels they selected.I have suggested putting a field for the different levels in one record, butthe others want to have a record for each level as we may be adding morelevels as time goes on.Thank you!Dale-- Dale Therio +49 69 263 19977 office Dresdner Kleinwort Benson Research+49 69 263 11379 fax Jürgen-Ponto-Platz 1+49 170 934 3610 mobile 60301 Frankfurt, Germany> From: Kenneth Grome > Reply-To: (WebCatalog Talk)> Date: Thu, 13 Apr 2000 22:57:43 -1000> To: (WebCatalog Talk)> Subject: Re: Searching multiple records for certain info> >> WebCatalog 3.08 (Mac OS and WinNT)>> >> Hi folks,>> >> Database>> userID level>> 1 3>> 1 5>> 1 6>> 2 3>> 2 4>> 2 5>> 3 3>> 3 4>> 3 5>> 3 6>> >> We are trying to accomplish the following:>> >> Do a search and only return the userID of those users that have records>> containing multiple levels. e.g. search for all users that have level 3 and>> 4. which in the above example this would return users 2 and 3 only.>> >> Any ideas?> > > [search db=x.db&woleveldatarq=3]> [text]next=[founditems][userID],[/founditems][/text]> [/search]> > [search db=x.db&wouserIDdatarq=[next]&woleveldatarq=4]> [founditems]> the records you want are here ...> [/founditems]> [/search]> -- > ================================> Kenneth Grome, WebDNA Consultant> 808-737-6499 http://webdna.net> ================================> > > > -------------------------------------------------------------> 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> > -------------------------------------------------------------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
dale@gmr.dresdner.net
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:
[WebDNA] Function "libraries" (2009)
Multiple catalog databases and showcart (1997)
Deleting Orders (1997)
dates and hex formatting (1997)
Converting Quotes in Javascript (2001)
[WebDNA] WebDNA7 and mod_fcgi (2013)
can webcat determine an image's pixel dimensions? (2000)
MOOOOOO (2000)
[WebDNA] Bug reporting (2009)
using showpage and showcart commands (1996)
WebCatalog for guestbook ? (1997)
WebCatalog Hosting (1996)
Great product and great job ! (1997)
MasterCounter and capitalization (1997)
WebCatalog for Postcards ? (1997)
repost: sending a down arrow (2000)
search engine friendly URLS (Mac) and Lycos! (1998)
Creating main- and sub-category search (1997)
hideif glitch (2003)
RequiredFields template (1997)