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:
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:
2.0 Info (1997)
Listfiles path bug ... (2005)
WC2b15 - [HTMLx]...[/HTMLx] problems (1997)
searchable list archive (1997)
Anyone using unix? Having problems... (2000)
'page impression' techniques for banner ads (1999)
Smith Micro - no competition (2000)
Error 11 (1996)
Where is Typhoon 3.x? (2000)
WebCat2b12 CGI Mac -- Problems propagating the cart through frames...still (1997)
[WebDNA] Bug in 6.2? (2009)
Thanks ! (1997)
redirect not passing vars (2004)
math a various prices (1997)
webten vs. webstar (1998)
WebCatalog for guestbook ? (1997)
Sorting by date (1997)
creator code (1997)
Change in Host? (1999)
[referrer] tag (1997)