Re: [lookup] still not working
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 20664
interpreted = N
texte = On 10/24/98 6:38 AM, Mike Eberly wrote:>I tried the code that you suggested that I use, and it is not working. I>am not quite sure what I am doing wrong. I tried many different>variations of this, trying to find the problem with the code, but no>luck so far. The lookup acts as if it is finding the item that is being>looked-up in the database even though it is not there. No matter what>the value of variable [cpassword] (which is submitted on the previous>page), it always shows the first statement (which should be hidden if>the content of [cpassword] is not found in the database). Here is the>code for one of my attempts:try putting the just the [lookup] statement on the page to see what you get returned. Also put the [cpassword] on the page to see what shows up there. Also do a search for [cpassword] and display the founditems to see what you get.ielookup, [lookupdb=AKcustomers.db&lookinfield=custpassword&value=[cpassword]&returnfield=custpassword¬found=notfound]
cpassword, [cpassword]
[search db=akcustomers.db&eqcustpassworddata=[cpassword]][numfound]
[founditems][name], [custpassword]
[/founditems][/search]This will tell you alot about your data, send it to me if it doesn't show you the answer and give me an in to the page.Robert Minor___________________________________________________________________________CyberMill Communications voice 314-962-40248616 Joseph Ave http://www.cybermill.com/St. Louis, MO 63144 email: webmaster@cybermill.com___________________________________________________________________________Purveyors of fine Websites and Webhosting services.
Associated Messages, from the most recent to the oldest:
On 10/24/98 6:38 AM, Mike Eberly wrote:>I tried the code that you suggested that I use, and it is not working. I>am not quite sure what I am doing wrong. I tried many different>variations of this, trying to find the problem with the code, but no>luck so far. The lookup acts as if it is finding the item that is being>looked-up in the database even though it is not there. No matter what>the value of variable [cpassword] (which is submitted on the previous>page), it always shows the first statement (which should be hidden if>the content of [cpassword] is not found in the database). Here is the>code for one of my attempts:try putting the just the
[lookup] statement on the page to see what you get returned. Also put the [cpassword] on the page to see what shows up there. Also do a search for [cpassword] and display the founditems to see what you get.ielookup, [lookupdb=AKcustomers.db&lookinfield=custpassword&value=[cpassword]&returnfield=custpassword¬found=notfound]
cpassword, [cpassword]
[search db=akcustomers.db&eqcustpassworddata=[cpassword]][numfound]
[founditems][name], [custpassword]
[/founditems][/search]This will tell you alot about your data, send it to me if it doesn't show you the answer and give me an in to the page.Robert Minor___________________________________________________________________________CyberMill Communications voice 314-962-40248616 Joseph Ave http://www.cybermill.com/St. Louis, MO 63144 email: webmaster@cybermill.com___________________________________________________________________________Purveyors of fine Websites and Webhosting services.
Bob Minor
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] El Capitan (2017)
WebCatalog not running after upgrade (2000)
Separate SSL Server (1997)
TCPConnect and AuthorizeNet (2001)
writing db to disk (1997)
Music in background (2000)
SiteGuard Admin Feature ? (1997)
Loss in form (1998)
Re:[off] Promotions Co? (1997)
Server 2003 & IIS 6 (2008)
Sort Order on a page search (1997)
PDF Difficulties (2000)
New Webcatalog for Mac (1997)
Ruby on Rails (was Looping Search) (2006)
[trim]?! (2004)
Help on multiple select fields (2002)
WebDNA equivalent for $REQUEST_URI (2004)
Cookies (2001)
[OT] (waaaay OT) further off topic than before (2004)
Validation (2000)