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 how many of the levels we need to match before the search. The user can come to the website and choose from 1 to (at present) 10 different levels and they only 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, but the others want to have a record for each level as we may be adding more levels 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 how many of the levels we need to match before the search. The user can come to the website and choose from 1 to (at present) 10 different levels and they only 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, but the others want to have a record for each level as we may be adding more levels 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 vs PHP (2003)
Referrer field to header field conversion (1997)
linetiems in thankyou.tpl (1997)
Slow NT mail. (2000)
WebCat2.0 [format thousands .0f] no go (1997)
Interesting speed comparison .. (2003)
[WriteFile] problems (1997)
pop up menu's (1998)
Showing unopened cart (1997)
WebCat2b13MacPlugin - [math][date][/math] problem (1997)
More on the email templates (I like it) (1997)
autosensing lanague selection (1997)
E-mail Attachments (1997)
Protecting Images (2003)
[WebDNA] Friday's.. WIP thread (2009)
authorizenet and netscape (2002)
server 2003 weirdness (2004)
SERIAL NUMBER BEING LOST AGAIN!!! (1999)
greater than or equal to (1997)
Mac 2.1b2 speed (1997)