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:
WebCat cannot handle compatible search parameters? (1997)
Updating checkboxes made easy !!! (1998)
Absolute path (2003)
RAM problems, [appendfile] problems (1998)
[BULK] Fwd: [WebDNA] [BULK] WebDNA discovery in the Console - [having many crashes] (2011)
Date Calulation (1997)
Active Server Code... (1998)
Problems reading files created by WC (1997)
Search Question (2003)
Security Question (1997)
Hierarchy of form/text/math variables (2000)
[shippingtotal] in Formulas.db (2002)
charging? (2001)
Protecting webdelivery (1997)
date tag not interpreted (2000)
os x server (2000)
Sort Order on a page search (1997)
Alternating colors (1997)
WC Database Format (1997)
ODBC-Interface (2000)