Re: Large Database Issue (possible bug)
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 57471
interpreted = N
texte = 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=Description]> [/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> jason@digitalfrontier.com> -- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE Eucalyptus Design <-Web Development (specializing in eCommerce), -> <-Graphic Design, and Pre-Press Consultation -> ADDRESS:> Donovan Brooke DBA Eucalyptus Design N2862 Summerville Park Rd. Lodi, WI 53555 PH:> 1.608.592.3567 Web:> http://www.euca.us =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o-------------------------------------------------------------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:
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=Description]> [/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> jason@digitalfrontier.com> -- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE Eucalyptus Design <-Web Development (specializing in eCommerce), -> <-Graphic Design, and Pre-Press Consultation -> ADDRESS:> Donovan Brooke DBA Eucalyptus Design N2862 Summerville Park Rd. Lodi, WI 53555 PH:> 1.608.592.3567 Web:> http://www.euca.us =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o-------------------------------------------------------------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/
Donovan Brooke
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:
ConvertWords (2002)
Nested tags count question (1997)
Re:quit command on NT (1997)
AppleScript question (1997)
FYI: virus alert (1996)
Tried installing Windows beta with no success... (2000)
Old $ commands and migration (2004)
Creating folders and deleting files (1997)
This list needs a digest: rant, rave... (1997)
PDF template hell (2000)
Multi-User Security on *nix using mod_rewrite (2002)
PCS Frames (1997)
Navigator 4.0 & tables (1997)
Re:no [search] with NT (1997)
Price question (1998)
WebCat2 several catalogs? (1997)
Problems with [Search] param - Mac Plugin b15 (1997)
'page impression' techniques for banner ads (1999)
Buying sans cart (1997)
emailer (1997)