Last Record not recognized?

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 22875
interpreted = N
texte = Hi Webcats:In attempting to set up my tax rates database, I discovered an apparent anomoly, and wonder if any of you have experienced this before.I set a list of WA zip codes and a corresponding tax rate. The list of zips is 484 zip codes long. So, I uploaded my database...and everything worked fine.Until I tested it using the last zip code in the database. Using this last zip code in the database created an error in which the correct tax rate wasn't used (it used the default of 0.00, meaning that the zip code wasn't found in the database).The second to last zip code in the record worked fine. So, I tried inserting a dummy record after the last zip code, and this fixed the problem. But, my question is why did I have this problem? Does webcat routinely not find the last record of a database? Have any of you ever experienced this?Timothy W. KillianeVenture Communications ----------------------------- em: evlist@eventure.com url: http://www.eventure.com ----------------------------- Postal Box 9765 Seattle, WA 98109 ph: 206.559.2200 fx: 206.324.3101 Associated Messages, from the most recent to the oldest:

    
  1. Re: Last Record not recognized? (PCS Technical Support 1999)
  2. Re: Last Record not recognized? (Gil Poulsen 1999)
  3. Re: Last Record not recognized? (Will Starck 1999)
  4. Last Record not recognized? (eVenture Communications 1999)
  5. Re: Last Record not recognized? (Dave MacLeay 1999)
Hi Webcats:In attempting to set up my tax rates database, I discovered an apparent anomoly, and wonder if any of you have experienced this before.I set a list of WA zip codes and a corresponding tax rate. The list of zips is 484 zip codes long. So, I uploaded my database...and everything worked fine.Until I tested it using the last zip code in the database. Using this last zip code in the database created an error in which the correct tax rate wasn't used (it used the default of 0.00, meaning that the zip code wasn't found in the database).The second to last zip code in the record worked fine. So, I tried inserting a dummy record after the last zip code, and this fixed the problem. But, my question is why did I have this problem? Does webcat routinely not find the last record of a database? Have any of you ever experienced this?Timothy W. KillianeVenture Communications ----------------------------- em: evlist@eventure.com url: http://www.eventure.com ----------------------------- Postal Box 9765 Seattle, WA 98109 ph: 206.559.2200 fx: 206.324.3101 eVenture Communications

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:

Variable prices and Formulas.db (1997) Couple of questions (1999) WebCat with WebTen (1998) OT: Unix Find Question (2004) Likelihood of a duplicate (2005) easiest way to check for a non-alphanumeric character? (2000) Webten + Webcat running smooth (1998) File not found error message (1998) [WebDNA] 6.2.1 fails on Apache 2.4.6 (2014) Extended [Concvertchars] needed (1997) Cart creation techniques (was Problems with Price field) (1997) date format (another question) (2000) Dark Horse Comics success story (1997) CERT Advisory on malicious scripts (2000) Email notification to one of multiple vendors ? (1997) WebCat2b13MacPlugin - [math][date][/math] problem (1997) WebCat B13 Mac CGI -- Frames question (1997) 3RD POST Character limit in [Search]? (1998) simple answer? [hideif] (1997) Thanks Grant (1997)