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.ie lookup, [lookup db=AKcustomers.db&lookinfield=custpassword&value=[cpassword]&returnfield=cu stpassword¬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-4024 8616 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:

    
  1. Re: [lookup] still not working (Bob Minor 1998)
  2. [lookup] still not working (Mike Eberly 1998)
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.ie lookup, [lookup db=AKcustomers.db&lookinfield=custpassword&value=[cpassword]&returnfield=cu stpassword¬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-4024 8616 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:

requiredfields (2002) Showif for mulitple variations (1997) Cookie Question (1999) [WebDNA] What is wrong with my search tag? (2011) [WebDNA] WebDNA slow processing (2011) Help returning tracking data from USPS website (2004) Incrementing a number (1998) Some Questions (1997) [isfile] ? (1997) [writefile] (1997) WebCat2: Formulas.db question (1997) ADMIN: [Fwd: Out of Office AutoReply: Subtotal Taxabletotal (2005) [WebDNA] WebDNA Newbie Questions (2008) WebDNA versus ASP [OT] (2002) Strange database format import (2000) WCS Newbie question (1997) no global [username] or [password] displayed ... (1997) RSS Feed (2004) shipcost (1997) exclusive db lock with webcat-3 ? (2000)