Re: Moose on a Stump

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 30188
interpreted = N
texte = on 07/04/2000 14:01, The Mooseman at frederickslist@mooseweb.com wrote:> Howdy ya'll! :> > > > I am having trouble combining a search here and would appreciate > some help. > > The two search examples below yield two different > numbers of items found in each DB that has two different > field names for a login or username. > > I would like to search both and display records of the two DBs that > exactly match each other. > > These normal searches of the two list all the records in each DB fine: > > **** Database1**** > > [search > db=Database1.txt&NEUserNamedata=XXX&UserName&UserNamesort=1&UserNamedir=de] > FOUND IN Database1.txt: [numfound]

> [founditems] > [UserName]
> [/foundItems] > [/search] > > > **** Database2**** > > [Search db=Database2&NELOGINdata=XXX&asLOGINsort=1&max=all] > FOUND IN Database2: [numfound]

> [founditems] > [LOGIN]
> [/foundItems] > [/search] > > > I have not been able to connect on the magic fix to combine them. > > Thanks in advance... > > Your old friend, > > Mooseman > > ( I have been a way fixing a totally crashed ISP and > getting them back on the air.... giant project with no data left > to rebuild it from.) > > > > ------------------------------------------------------------- > 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 > > You could search one, and use the hits to look for matches in the other. Try something like this:[search db=a.db&neFIELDdata=etcetc] [founditems] [hideif [lookup db=b.db&value=[login]&lookinfield=login¬found=NoMatch]=NoMatch] A Hit! [/hideif] [/founditems] [/search]- Nico ------------------------------------------------------------- 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:

    
  1. Re: Moose on a Stump (Nicolas Verhaeghe 2000)
  2. Re: Moose on a Stump (Nico 2000)
  3. Moose on a Stump (The Mooseman 2000)
on 07/04/2000 14:01, The Mooseman at frederickslist@mooseweb.com wrote:> Howdy ya'll! :> > > > I am having trouble combining a search here and would appreciate > some help. > > The two search examples below yield two different > numbers of items found in each DB that has two different > field names for a login or username. > > I would like to search both and display records of the two DBs that > exactly match each other. > > These normal searches of the two list all the records in each DB fine: > > **** Database1**** > > [search > db=Database1.txt&NEUserNamedata=XXX&UserName&UserNamesort=1&UserNamedir=de] > FOUND IN Database1.txt: [numfound]

> [founditems] > [username]
> [/foundItems] > [/search] > > > **** Database2**** > > [Search db=Database2&NELOGINdata=XXX&asLOGINsort=1&max=all] > FOUND IN Database2: [numfound]

> [founditems] > [LOGIN]
> [/foundItems] > [/search] > > > I have not been able to connect on the magic fix to combine them. > > Thanks in advance... > > Your old friend, > > Mooseman > > ( I have been a way fixing a totally crashed ISP and > getting them back on the air.... giant project with no data left > to rebuild it from.) > > > > ------------------------------------------------------------- > 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 > > You could search one, and use the hits to look for matches in the other. Try something like this:[search db=a.db&neFIELDdata=etcetc] [founditems] [hideif [lookup db=b.db&value=[login]&lookinfield=login¬found=NoMatch]=NoMatch] A Hit! [/hideif] [/founditems] [/search]- Nico ------------------------------------------------------------- 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 Nico

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] find missing file in [listfiles] (2019) Image maps/Webcat (1997) The IBC root beer has arrived! (1997) Re:Searching for ALL / empty form field *the FINAL answer* (1997) Still can't get this taxrate to work... (1999) Diners Club card problems (1999) errormessages.db (1997) Search for 20 finds 2000, 200 Why? (1997) [Fwd: Rotating Banners ... (was LinkExchange)] (1997) Moment of Thanks (1997) RE: Webcatalog and CyberSTUD (1998) UPS uber integration (2007) variables in [addlineitem] (1998) Only charge card when product shipped ? (1997) OT: OSX calculator error (2004) FYI: virus alert (1996) Emailer setup (1997) [quantity] solved (1997) RE:It just Does't add up!!! (1997) Banners (1997)