Re: [Lookup] on secure page not returning anything
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 26184
interpreted = N
texte = >Good Morning,>>I have secure template that attemtps to do a [lookup] but nothing is >getting returned in>place of that [lookup] tag, not even the value for 'notFound'.>I think it may have something to do with the fact that the path (in >that lookup tag) to>the db it is looking in has to be specially set since the lookup tag >resides on a secure>page.>The secure template lives in the site root (it becomes secure by >virtue of a special URL>that is used to reach the template https....). The db lives in a >directory one level>down.>my lookup is like so->[lookup db=DBdirectory/Orders.db&lookInField=...]>>is it valid syntax to instead use->[lookup db=http://www.mydomain/DBdirectory/Orders.db&lookInField=...]No this is invalid but if would be a great feature :-))>?>If I am not on the right track, do you have any suggestions how to >get the lookup to do>its thing?>>-JohnI think you need to use the lookup tag with the value first like the example in the docs,[LOOKUP db=databasePath&value=searchValue&lookInField=searchField&returnField= fieldName¬Found=TextIfNotFound]Hope this helps.Micheal O Shea Email:micheal@com4u.chcom4u.ch http://www.com4u.chBreitistrasse 7B PGP key available upon request. CH-5506 Maegenwil Tel: +41 62 896 46 26Switzerland-------------------------------------------------------------Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.To end your Mail problems go to
.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:
>Good Morning,>>I have secure template that attemtps to do a [lookup] but nothing is >getting returned in>place of that [lookup] tag, not even the value for 'notFound'.>I think it may have something to do with the fact that the path (in >that lookup tag) to>the db it is looking in has to be specially set since the lookup tag >resides on a secure>page.>The secure template lives in the site root (it becomes secure by >virtue of a special URL>that is used to reach the template https....). The db lives in a >directory one level>down.>my lookup is like so->[lookup db=DBdirectory/Orders.db&lookInField=...]>>is it valid syntax to instead use->[lookup db=http://www.mydomain/DBdirectory/Orders.db&lookInField=...]No this is invalid but if would be a great feature :-))>?>If I am not on the right track, do you have any suggestions how to >get the lookup to do>its thing?>>-JohnI think you need to use the lookup tag with the value first like the example in the docs,[LOOKUP db=databasePath&value=searchValue&lookInField=searchField&returnField= fieldName¬Found=TextIfNotFound]Hope this helps.Micheal O Shea Email:micheal@com4u.chcom4u.ch http://www.com4u.chBreitistrasse 7B PGP key available upon request. CH-5506 Maegenwil Tel: +41 62 896 46 26Switzerland-------------------------------------------------------------Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.To end your Mail problems go to .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
Michael O Shea
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:
WebCat2b12 - nesting [tags] (1997)
[group] ? (1997)
Database Helper missing? (2000)
Beta 18 (1997)
Emailer (1997)
Help with Shipping Costs (1997)
Protect (1997)
WebCat2b12 - nesting [tags] (1997)
Webcat engine freezes when [tcpconnect] can't connect (2003)
webcat2b12 CGI -- Date comparisons (1997)
update problem (1998)
About WebCatalog and iTools 7 (2003)
WCS Newbie question (1997)
WebDNA Speed Test (2008)
F3 crashing server (1997)
aaron kant add (2.x) (2000)
date sorting and 'template (1997)
Add to a field (1998)
Nested Loops and SHOWIFs (1997)
Max Record length restated as maybe bug (1997)