Re: Last Record not recognized?
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 22878
interpreted = N
texte = Maybe you just need a carriage return after the last record?eVenture Communications wrote:> > 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. Killian> > eVenture Communications> -----------------------------> em: evlist@eventure.com> url: http://www.eventure.com> -----------------------------> Postal Box 9765> Seattle, WA 98109> ph: 206.559.2200> fx: 206.324.3101-- Gil Poulsen, Webmaster*************************************************************** AltiM@c * Phone: (908) 222-9001 ** 111 Mali Drive * FAX: (908) 222-9002 ** North Plainfield, NJ * e-mail: help@altimac.com ** 07062-2355 * WWW: http://www.altimac.com ***************************************************************
Associated Messages, from the most recent to the oldest:
Maybe you just need a carriage return after the last record?eVenture Communications wrote:> > 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. Killian> > eVenture Communications> -----------------------------> em: evlist@eventure.com> url: http://www.eventure.com> -----------------------------> Postal Box 9765> Seattle, WA 98109> ph: 206.559.2200> fx: 206.324.3101-- Gil Poulsen, Webmaster*************************************************************** AltiM@c * Phone: (908) 222-9001 ** 111 Mali Drive * FAX: (908) 222-9002 ** North Plainfield, NJ * e-mail: help@altimac.com ** 07062-2355 * WWW: http://www.altimac.com ***************************************************************
Gil Poulsen
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:
Help! WebCat2 bug (Ben's input) (1997)
Nested search (1997)
Change in Host? (1999)
db not being written to disk (2003)
bug in [SendMail] (1997)
Solution help needed (1998)
Public beta 2 for WebCatalog 4.0 is now available. (2000)
Showing Results Alphabetically in Columns (top to bottom) (2002)
Calendar Program (2004)
[ShowCart]-- was ThankYou page problems (1997)
WebCatalog for guestbook ? (1997)
frames & carts (1997)
WebTen and WebCat (1997)
listfiles-looking for slick solution (1997)
http upload (2001)
Emailer setup (1997)
updating checkbox in a db (1998)
WebCommerce: Folder organization ? (1997)
Typhoon Rev. and PCS store problems (1999)
More news on 5.0 (2003)