Re: Lookup question

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 38840
interpreted = N
texte = Why not use two searches?ex:ID VNR 5 Hans 12 Peter 9 Sven[search db=/databaser/main.dna&neIDdatarq=999999&VNRsort=1&VNRsdir=as] [founditems] [!] This is wehere I have [VNR]. If VNR is also used in main you'd have to just use [text]thisvnr=[VNR][/text] [search db=/databaser/info.db&eqIDdatarq=[ID]] [founditems] [Title] and whatever you want from info.db. [/founditems] [/founditems] [/search]If you're bent on using lookups,[search db=/databaser/info.db&neIDdatarq=999999&VNRsort=1&VNRsdir=as] [founditems] [showif [lookup db=db=/databaser/main.dna&lookinfield=ID&value=[ID]&returnfiled=ID¬found=notthere]!notthere] [Title] and whatever you want from info.db. [/founditems] [/search] Maybe I misunderstood the purpose of the databses, feel free to correct me. :-) At 02:44 PM 9/24/01, you wrote: >Hey! > >The main.db contains the following: ID, VNR. The info.db contains all info >off all persons. On the mainpage i want to choose 3 people from the info.db >which will be on the page all the time. In a adminview it have to be >possiple to change the 3 people on the front. > > > > >-- >claus lundholm >graphic interface designer > >XCITING : scandinavia > > > >on 24/09/01 14:39, Jeroen de Wijn at jdewijn@tobeone.nl wrote: > > > That depends of what your main.dna looks like and what it's used for. > > What's the header? > > > > At 02:06 PM 9/24/01, you wrote: > >> Hello! > >> > >> I have searchstring there looks like this: > >> > >> [search db=/databaser/info.db&eqSKUdatarq=3118][founditems] > >> [Title][/founditems][/search] > >> > >> I now want the eqSKUdatarqto pickup data from another db called > main.dna and > >> return with the value VNR so i can do like this: eqSKUdatarq=[vnr]. > >> > >> How can i use lookup for that purpose? > >> > >> > >> -- > >> claus lundholm > >> graphic interface designer > >> > >> XCITING : scandinavia > >> > >> > >> ------------------------------------------------------------- > >> 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 > >> > >> Web Archive of this list is at: http://search.smithmicro.com/ > > > > > > ------------------------------------------------------------- > > 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 > > > > Web Archive of this list is at: http://search.smithmicro.com/ > > > > >------------------------------------------------------------- >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 > >Web Archive of this list is at: http://search.smithmicro.com/ ------------------------------------------------------------- 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 Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Lookup question (Jeroen de Wijn 2001)
  2. Re: Lookup question (Jeroen de Wijn 2001)
  3. Re: Lookup question (Claus Lundholm 2001)
  4. Re: Lookup question (Jeroen de Wijn 2001)
  5. Lookup question (Claus Lundholm 2001)
Why not use two searches?ex:ID VNR 5 Hans 12 Peter 9 Sven[search db=/databaser/main.dna&neIDdatarq=999999&VNRsort=1&VNRsdir=as] [founditems] [!] This is wehere I have [VNR]. If VNR is also used in main you'd have to just use [text]thisvnr=[VNR][/text] [search db=/databaser/info.db&eqIDdatarq=[ID]] [founditems] [Title] and whatever you want from info.db. [/founditems] [/founditems] [/search]If you're bent on using lookups,[search db=/databaser/info.db&neIDdatarq=999999&VNRsort=1&VNRsdir=as] [founditems] [showif [lookup db=db=/databaser/main.dna&lookinfield=ID&value=[ID]&returnfiled=ID¬found=notthere]!notthere] [Title] and whatever you want from info.db. [/founditems] [/search] Maybe I misunderstood the purpose of the databses, feel free to correct me. :-) At 02:44 PM 9/24/01, you wrote: >Hey! > >The main.db contains the following: ID, VNR. The info.db contains all info >off all persons. On the mainpage i want to choose 3 people from the info.db >which will be on the page all the time. In a adminview it have to be >possiple to change the 3 people on the front. > > > > >-- >claus lundholm >graphic interface designer > >XCITING : scandinavia > > > >on 24/09/01 14:39, Jeroen de Wijn at jdewijn@tobeone.nl wrote: > > > That depends of what your main.dna looks like and what it's used for. > > What's the header? > > > > At 02:06 PM 9/24/01, you wrote: > >> Hello! > >> > >> I have searchstring there looks like this: > >> > >> [search db=/databaser/info.db&eqSKUdatarq=3118][founditems] > >> [Title][/founditems][/search] > >> > >> I now want the eqSKUdatarqto pickup data from another db called > main.dna and > >> return with the value VNR so i can do like this: eqSKUdatarq=[vnr]. > >> > >> How can i use lookup for that purpose? > >> > >> > >> -- > >> claus lundholm > >> graphic interface designer > >> > >> XCITING : scandinavia > >> > >> > >> ------------------------------------------------------------- > >> 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 > >> > >> Web Archive of this list is at: http://search.smithmicro.com/ > > > > > > ------------------------------------------------------------- > > 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 > > > > Web Archive of this list is at: http://search.smithmicro.com/ > > > > >------------------------------------------------------------- >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 > >Web Archive of this list is at: http://search.smithmicro.com/ ------------------------------------------------------------- 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 Web Archive of this list is at: http://search.smithmicro.com/ Jeroen de Wijn

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:

WebCat editing, SiteGuard WAS:SiteAssociative lookup style? (1997) RE: [input] questions (1997) ADMIN ACCESS (1999) Emailer+NetTen [same machine]=? (2000) RE: Missing contexts on NT (1997) carriage returns in data (1997) New command suggestion (1997) RequiredFields template (1997) RE: creating writefile data from a nested search (1997) authenticate broken when url not fully specified? (2000) emailer settings and control questions (1997) [WriteFile] problems (1997) Secure server question (1997) newbie question about zip code search (2003) unable to launch acgi in WebCat (1997) 2.0 Info (1997) Almost a there but..bye bye NetCloak (1997) [no_cache]?! (2000) Internet Explorer and caching (2000) re: Large databases in WebCat (1997)