Re: Referencing multiple databases...
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 34815
interpreted = N
texte = Try setting the results of the lookup into either a text or math variable (whichever is appropriate) then do your [showifs] against the variable. I just tried something similar and also ran into problems with it not always seeming to work, but with the variables it works everytime. And of course you now have that value available to you in case ou need it for somehting else as well.DaleOn Tuesday, July 18, 2000, Matthew Levy
wrote: >I am trying to reference multiple databases using the lookup command below >but it seems as though half the time it works and half the time it dosen't. >My databases seem to be set up correctly. I can't figure out >what is wrong. > >Here is the code: >[showif [user_state]!CA][lookup db=/db/employee.db&value=[lookup >db=/db/territory.db&value=[lookup >db=/db/sales_terr.db&value=[user_state]&lookinfield=terr_st&returnfield=terr >_num¬found=1]&lookinfield=terr_num&returnfield=sales_rep¬found=2]&look >infield=employee_id&returnfield=employee_fname¬found=Ray] > > >Please help. > > >Matt Levy >AEC Software, Inc. >mlevy@aecsoft.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:
Try setting the results of the lookup into either a text or math variable (whichever is appropriate) then do your [showifs] against the variable. I just tried something similar and also ran into problems with it not always seeming to work, but with the variables it works everytime. And of course you now have that value available to you in case ou need it for somehting else as well.DaleOn Tuesday, July 18, 2000, Matthew Levy wrote: >I am trying to reference multiple databases using the lookup command below >but it seems as though half the time it works and half the time it dosen't. >My databases seem to be set up correctly. I can't figure out >what is wrong. > >Here is the code: >[showif [user_state]!CA][lookup db=/db/employee.db&value=[lookup >db=/db/territory.db&value=[lookup >db=/db/sales_terr.db&value=[user_state]&lookinfield=terr_st&returnfield=terr >_num¬found=1]&lookinfield=terr_num&returnfield=sales_rep¬found=2]&look >infield=employee_id&returnfield=employee_fname¬found=Ray] > > >Please help. > > >Matt Levy >AEC Software, Inc. >mlevy@aecsoft.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/
Dale
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:
[HIDEIF] inside [FOUNDITEM] (1997)
BIG PROBLEMS with Checkboxes!!! (1998)
[authenticate] (1999)
Error Lob.db records error message not name (1997)
suffix mapping for NT? (1997)
Combining search criteria in a context? (1998)
WC2f3 (1997)
WebCat b13 CGI -shownext- (1997)
Taxes rates based on item and State (1998)
Beta version-Mac? (was Emailer update for Mac?) (1998)
upgrading (1997)
PSC recommends what date format yr 2000??? (1997)
Purchase Plugin Missing (1996)
Error Template (1999)
SET (1998)
[WebDNA] Technical References (2009)
can WC render sites out? (1997)
oops private message leaked into talk list (1997)
WebCat 3 & Aliases (2000)
grouping nothing (2000)