[lookup] still not working
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 20659
interpreted = N
texte = Bob,I tried the code that you suggested that I use, and it is not working. Iam not quite sure what I am doing wrong. I tried many differentvariations of this, trying to find the problem with the code, but noluck so far. The lookup acts as if it is finding the item that is beinglooked-up in the database even though it is not there. No matter whatthe value of variable [cpassword] (which is submitted on the previouspage), it always shows the first statement (which should be hidden ifthe content of [cpassword] is not found in the database). Here is thecode for one of my attempts:
[hideif notfound=[lookupdb=AKcustomers.db&lookinfield=custpassword&value=[cpassword]&returnfield=custpassword¬found=notfound]]Sorry, that username already exists, please select a different username.
[/hideif][Showif notfound=[lookupdb=AKcustomers.db&lookinfield=custpassword&value=[cpassword]&return=custpassword¬found=notfound]] [Append db=AKcustomers.db]eMail=[eMail]&BillFirstName;=[BillFirstName]&BillInitial;=[BillInitial]&BillLast;=[BillLast]&BillCompany;=[BillCompany]&BillTitle;=[BillTitle]&BillAddr1;=[BillAddr1]&BillCity;=[BillCity]&BillState;=[BillState]&BillZip;=[BillZip]
[/Append] Thank you [BillFirstName]! Your customer information has been saved. Commit your password to memory for future ordering: ([cpassword]) [/showif] Any suggestions as to what is wrong? (This is the first time I have used[lookup])Thanks,Mike
Associated Messages, from the most recent to the oldest:
Bob,I tried the code that you suggested that I use, and it is not working. Iam not quite sure what I am doing wrong. I tried many differentvariations of this, trying to find the problem with the code, but noluck so far. The lookup acts as if it is finding the item that is beinglooked-up in the database even though it is not there. No matter whatthe value of variable [cpassword] (which is submitted on the previouspage), it always shows the first statement (which should be hidden ifthe content of [cpassword] is not found in the database). Here is thecode for one of my attempts: [hideif notfound=[lookupdb=AKcustomers.db&lookinfield=custpassword&value=[cpassword]&returnfield=custpassword¬found=notfound]]Sorry, that username already exists, please select a different username.
[/hideif][Showif notfound=[lookupdb=AKcustomers.db&lookinfield=custpassword&value=[cpassword]&return=custpassword¬found=notfound]] [Append db=AKcustomers.db]eMail=[eMail]&BillFirstName;=[BillFirstName]&BillInitial;=[BillInitial]&BillLast;=[BillLast]&BillCompany;=[BillCompany]&BillTitle;=[BillTitle]&BillAddr1;=[BillAddr1]&BillCity;=[BillCity]&BillState;=[BillState]&BillZip;=[BillZip]
[/Append] Thank you [BillFirstName]! Your customer information has been saved. Commit your password to memory for future ordering: ([cpassword]) [/showif] Any suggestions as to what is wrong? (This is the first time I have used[lookup])Thanks,Mike
Mike Eberly
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:
RE: Database field limit? (1998)
Adding up line items. (2000)
Excel PMT Calculation (2001)
[OT] Discussion forum, last visit, Cookie, ... (2003)
syntax question, not in online refernce (1997)
autosensing lanague selection (1997)
Navigator 4.01 (1997)
WebCat2 - [format thousands] (1997)
textarea (2000)
Logging purchases (1997)
WebCat2 as a chat server? (1997)
[WebDNA] Pretty URLS (2011)
How to Sort Summ data ? (1997)
RE: LookUp Tag (1997)
WebCat2b12 CGI Mac - [shownext] problem (1997)
My web page only... (2003)
WebCat2 - storing unformatted date data? (1997)
Tax Collection for Different Items (2003)
Mac 2.1b2 speed (1997)
[WebDNA] Calculate Cube root (2012)