[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[2]: Wierd problem with 3.08 WIN Version (2000)
[WebDNA] HTTP Streaming -- impossible? (2010)
Emailer port change (1997)
Creating 404 Not Found pages (1999)
how do you and/or in a search? (1997)
Max Record length restated as maybe bug (1997)
Searching for Email Address (2004)
Help name our technology! (1997)
EMailer - WebSTAR V - OSX - WebDNA (2003)
WebCat2b13MacPlugIn - more [date] problems (1997)
WebStar 3 crackable !!!! (1998)
[SearchString] usage (1997)
TCPConnect / Current Temperature (2004)
WebCat editing, SiteGuard & SiteEdit (1997)
RE: MS Commerce Comparison (long) (1998)
[OT] Friday Time Waster (2003)
Search/sort in URL Was: GuestBook example (1997)
Message Board (2001)
[WebDNA] jumpstart me? - how to auto-upload to a remote server? (2010)
newbie question about zip code search (2003)