Large Database Issue (possible bug)
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 57469
interpreted = N
texte = 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=Description][/founditems][/search]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.Jasonjason@digitalfrontier.com-------------------------------------------------------------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:
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=Description][/founditems][/search]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.Jasonjason@digitalfrontier.com-------------------------------------------------------------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:
Mac 2.1b4 unknown error: BadSuffix (1997)
ShowNext (2002)
blank page from template (1997)
[TCPConnect] questions/problems (2001)
Shopping with Accounts (2003)
[SearchString] problem with [search] context (1997)
WebCat2.0b15-to many nested [xx] tags (1997)
can we get string variables? (1998)
DNS Lookup 2 (2000)
Install Webcatalog under NT4.0 and Microsoft IIS 2.0 (1997)
WEBCAT HIERARCHY (1999)
Running 2 two WebCatalog.acgi's (1996)
[shownext max=?] armed (1997)
Every other record deleted (2005)
Running _every_ page through WebCat ? (1997)
text size limitation (1997)
Displaying text and populating form fields (2005)
Nested tags count question (1997)
RAM variables (1997)
Multiple prices (1997)