Re: Lookup question

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 38841
interpreted = N
texte = oops. and a [/showif] in the second example of course. At 05:08 PM 9/24/01, you wrote: >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/ ------------------------------------------------------------- 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)
oops. and a [/showif] in the second example of course. At 05:08 PM 9/24/01, you wrote: >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/ ------------------------------------------------------------- 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:

[WebDNA] read database from other domain (2015) Blog/social networking shortcut (2007) OLD ORDERS (1998) Remove (2000) multi-paragraph fields (1997) Location of Browser Info.txt file (1997) Correlating the record found with the fieldname (2000) Moose on a Stump (2000) [OT] 'Email this story to a friend' (2003) Emailer setup (1997) Help name our technology! (1997) Associative lookup style? + bit more (1997) How do I specify a & character in Grep? (2000) WCS Newbie question (1997) Using Plug-In while running 1.6.1 (1997) [ListFiles] & [loop] (1998) Creating a folder with WebCat? (2000) Interfacing WebMerchant to www.fedex.com (1997) Time sort - Flushdatabases (2000) Middle Context (2002)