[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. 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: [hideif notfound=[lookup db=AKcustomers.db&lookinfield=custpassword&value=[cpassword]&returnfield=custpassword¬found=notfound]] Sorry, that username already exists, please select a different user name.
[/hideif] [Showif notfound=[lookup db=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:

    
  1. Re: [lookup] still not working (Bob Minor 1998)
  2. [lookup] still not working (Mike Eberly 1998)
Bob, 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: [hideif notfound=[lookup db=AKcustomers.db&lookinfield=custpassword&value=[cpassword]&returnfield=custpassword¬found=notfound]] Sorry, that username already exists, please select a different user name.
[/hideif] [Showif notfound=[lookup db=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:

Search in 2 or more catalogs (1997) [TEXT SECURE=T] (2000) WebMerchant when CC network is down - bug? (1998) AE aware WebCatalog.acgi? (1997) Database Field Additions (2000) [WebDNA] [BULK] The WebDAV Server Module / web services (2012) [max] always equals 0 in search context (2000) WebCat2 - Getting to the browser's username/password data (1997) [WebDNA] SSD's and second disk (2017) Help name our technology! I found it (1997) Local redirects ... (2005) F3 crashing server (1997) WCS Newbie question (1997) [WriteFile] problems (1997) [SendMail] from a form? (1998) Quitting WebMerchant ? (1997) Search Engine bots (2002) Announce: Bug fix talk list (1999) PCS Emailer's role ? (1997) Setting up WebCatalog with Retail Pro data (1996)