Re: Searching multiple records for certain info
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 30467
interpreted = N
texte = [math show=f] requiredleevlcount=0[/math][showif [level1selected]=t][math show=f] requiredleevlcount=requiredleevlcount+1[/math][/showif][showif [level1selected]=t] [math show=f] requiredleevlcount=requiredleevlcount+1[/math][/showif]...[showif [level1selected]=t] [math show=f] requiredleevlcount=requiredleevlcount+1[/math][/showif] [search db=yourdb.db&geuserIDdata=0]
[founditems] [math show=f]user=[userID][/math] [math show=f]levelCount=0[/math][showif [level1selected]=t][search db=yourdb.db&eqleveldatarq=1] [Founditems][showif [userID]=[user]][math show=f]levelcount=levelcount+1[/math] [/showif][/founditems][/search][/showif][showif [level2selected]=t][search db=yourdb.db&eqleveldatarq=2] [Founditems][showif [userID]=[user]][math show=f]levelcount=levelcount+1[/math] [/showif][/founditems][/search][/showif]...[showif [level10selected]=t][search db=yourdb.db&eqleveldatarq=10] [Founditems][showif [userID]=[user]][math show=f]levelcount=levelcount+1[/math] [/showif][/founditems][/search][/showif] [showif [levelcount]>[requiredlevelcount]]| [userID] |
[/founditems]
[/search] >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 >Jaishankar Jayaram, Database Programmer, Interactive Ink, Inc. Phone: (614) 221-7089 ext 23 Fax: (614) 221-7098 Email:jai@interactiveink.com http://www.interactiveink.com E-business made Easy------------------------------------------------------------- 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:
[math show=f] requiredleevlcount=0[/math][showif [level1selected]=t][math show=f] requiredleevlcount=requiredleevlcount+1[/math][/showif][showif [level1selected]=t] [math show=f] requiredleevlcount=requiredleevlcount+1[/math][/showif]...[showif [level1selected]=t] [math show=f] requiredleevlcount=requiredleevlcount+1[/math][/showif] [search db=yourdb.db&geuserIDdata=0] [founditems] [math show=f]user=[userID][/math] [math show=f]levelCount=0[/math][showif [level1selected]=t][search db=yourdb.db&eqleveldatarq=1] [founditems][showif [userID]=[user]][math show=f]levelcount=levelcount+1[/math] [/showif][/founditems][/search][/showif][showif [level2selected]=t][search db=yourdb.db&eqleveldatarq=2] [founditems][showif [userID]=[user]][math show=f]levelcount=levelcount+1[/math] [/showif][/founditems][/search][/showif]...[showif [level10selected]=t][search db=yourdb.db&eqleveldatarq=10] [founditems][showif [userID]=[user]][math show=f]levelcount=levelcount+1[/math] [/showif][/founditems][/search][/showif] [showif [levelcount]>[requiredlevelcount]]| [userID] |
[/founditems]
[/search] >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 >Jaishankar Jayaram, Database Programmer, Interactive Ink, Inc. Phone: (614) 221-7089 ext 23 Fax: (614) 221-7098 Email:jai@interactiveink.com http://www.interactiveink.com E-business made Easy------------------------------------------------------------- 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
Jaishankar Jayaram
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:
2.1 release (1998)
Re:2nd WebCatalog2 Feature Request (1996)
Permissions (2000)
send mail problem? (1997)
Satistics (1999)
Tracking inbound links for discounts (1997)
Separate SSL Server (1997)
What am I doing wrong? (2000)
Which GUI HTML editors work with WC ? (1997)
Stay on Products page (2003)
WebCAT has the devil in it! (2003)
Confusing [protect] (long) (1999)
using WebCat for Associate Programs? (1998)
RAM variables (1997)
Bad suffix error (1997)
same bill to and ship to? (1998)
WebCat & WebTen (1997)
[WebDNA] Ubuntu 10.4 & WebDNA 6.2 (2011)
[shownext] and sort (1998)
shipcost (1997)