Re: Large Database Issue (possible bug)
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 57472
interpreted = N
texte = Thanks for the quick replies. Donovan, adding the type=num isn't necessary since my PointID's begin with letters, not numbers. The search code I provided does indeed change my database. By change, Charles, I meant the records themselves are not the same. Most notably, the first field is a date and the uploaded database ends on 4/21/2004. But when webcat searches through it, the last field is now 3/6/2003. What makes this even more strange is that this webcat modified db contains the same number of records, so it's not truncating the records. After a little BBEdit Find Differences magic, I was able to find what was really going on. 45 lines began with an illegal character (dare I say gremlin). This then was causing WebCat to parse the data incorrectly and why the database seemed to change and loose records. All is good now. Thanks again for your help! Jason On Apr 22, 2004, at 9:43 PM, Donovan Brooke wrote: > Jason Sofonia wrote: > >> We have a database with 27177 records (and growing). The file size >> is currently 2.9mb. Whenever WebDNA does a search within this >> database, the database file gets changed and the results are not >> what they should be. I believe this to be a bug as it has worked >> for years using previous versions of WebCat. Any guidance would be >> greatly appreciated. >> Here is an example of the code I'm using that will break the database >> file. >> [search >> db=../database.db&eqIDdatarq=[ID]&PointIDsumm=T&asPointIDsort=1] >> [founditems] >> [lookup db=../ >> PointIDs.db&lookinfield=PointID&value=[PointID]&returnfield=Descriptio >> n] >> [/founditems] >> [/search] > > > You need to add "&IDtype=num" to your search for one. I doubt its a > bug with WebDNA. > > Is that the full search code that "breaks" the database? > > Donovan > > >> The result for this search yields only one record and no more than >> 10. So it's not an issue of too many founditems. >> For the record, we are running we are running WebDNA - Commerce >> Edition 5.1g (this was also not working with version 5.0) on Mac OS >> X Server 10.2.8 with journaling on and 1.5GB ram. >> Thanks for your help and please let me know if I need to clarify >> anything further. >> Jason >> On Apr 22, 2004, at 9:24 PM, charles kline wrote: > In what way does the database get changed? 2.9 MB is not that big for > a database so I am not sure that is the problem. > > - ck ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list
. To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Thanks for the quick replies. Donovan, adding the type=num isn't necessary since my PointID's begin with letters, not numbers. The search code I provided does indeed change my database. By change, Charles, I meant the records themselves are not the same. Most notably, the first field is a date and the uploaded database ends on 4/21/2004. But when webcat searches through it, the last field is now 3/6/2003. What makes this even more strange is that this webcat modified db contains the same number of records, so it's not truncating the records. After a little BBEdit Find Differences magic, I was able to find what was really going on. 45 lines began with an illegal character (dare I say gremlin). This then was causing WebCat to parse the data incorrectly and why the database seemed to change and loose records. All is good now. Thanks again for your help! Jason On Apr 22, 2004, at 9:43 PM, Donovan Brooke wrote: > Jason Sofonia wrote: > >> We have a database with 27177 records (and growing). The file size >> is currently 2.9mb. Whenever WebDNA does a search within this >> database, the database file gets changed and the results are not >> what they should be. I believe this to be a bug as it has worked >> for years using previous versions of WebCat. Any guidance would be >> greatly appreciated. >> Here is an example of the code I'm using that will break the database >> file. >> [search >> db=../database.db&eqIDdatarq=[ID]&PointIDsumm=T&asPointIDsort=1] >> [founditems] >> [lookup db=../ >> PointIDs.db&lookinfield=PointID&value=[PointID]&returnfield=Descriptio >> n] >> [/founditems] >> [/search] > > > You need to add "&IDtype=num" to your search for one. I doubt its a > bug with WebDNA. > > Is that the full search code that "breaks" the database? > > Donovan > > >> The result for this search yields only one record and no more than >> 10. So it's not an issue of too many founditems. >> For the record, we are running we are running WebDNA - Commerce >> Edition 5.1g (this was also not working with version 5.0) on Mac OS >> X Server 10.2.8 with journaling on and 1.5GB ram. >> Thanks for your help and please let me know if I need to clarify >> anything further. >> Jason >> On Apr 22, 2004, at 9:24 PM, charles kline wrote: > In what way does the database get changed? 2.9 MB is not that big for > a database so I am not sure that is the problem. > > - ck ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Jason Sofonia
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:
Emailer file formats (1998)
WebDNA tags in WebMerchant email templates ... (1997)
Submit buttons not working.... (1999)
Nested vs conditional (1997)
SQL Error 22003 : Found the workaround (2001)
limit to listwords (2001)
japanese characters (1997)
ODBC (2000)
Problem during evaluation of WebCatalog (1998)
Date and Time Math (1997)
[WebDNA] directory protection questions (2008)
More Shopping Cart Problems (2000)
[subtotal] and others (1997)
Changes to the List (1997)
Is there an alternative to emailer? (1999)
Emailer setup (1997)
shipcost (1997)
Browser Problem?!? Still getting Error message usingPOST! (1997)
little help (2001)
Which GUI HTML editors work with WC ? (1997)