[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:
Locking up with WebCatalog... (1997)
multiple product databases (1997)
HTTP header line is too long? (1997)
2.0 Info (1997)
2nd WebCatalog2 Feature Request (1996)
Cookies and webcat (1997)
Spawn doesn't work as advertised ... (2000)
ShowIf inside formulas (1997)
WriteFile is there a max size? (1998)
Problems with [Applescript] (1997)
[index] (1997)
database size? (1997)
Upgrading old WebCat Database Files (1997)
[UPPERCASE] (1997)
HELP WITH DATES (1997)
Include Files (1998)
AuthorizeNet Bug (2002)
Re[2]: 2nd WebCatalog2 Feature Request (1996)
variables in [addlineitem] (1998)
[WebDNA] High-profile WebDNA sites? (2008)