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:
where to put code (1998)
$Quit, $CloseDatabase corrections (1997)
Server Load (2000)
ReadDateFormat bug in 3.0.1 (1998)
Template cache problem with WC4 on Mac OS X (2000)
form ENCTYPE confusion [correction] (2003)
PCS Frames-Default page is solution! (1997)
quantity minimum problem (1997)
Formatting a .txt file (1998)
problems with 2 tags (1997)
unable to launch acgi in WebCat (1997)
Weird happenings when viewing in IE 3.02 (1998)
(no subject) (1997)
The IBC root beer has arrived! (1997)
disappearing SKU (etc.) fields (1998)
date display (1999)
Weird problems with [SHOWIF]s (1997)
Re:Help name our technology! (1997)
[OT] Disable/enable field (2003)
Cookie setting (2003)