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:

    
  1. Re: Large Database Issue (possible bug) ( Glenn Busbin 2004)
  2. Re: Large Database Issue (possible bug) ( Glenn Busbin 2004)
  3. Re: Large Database Issue (possible bug) ( Jason Sofonia 2004)
  4. Re: Large Database Issue (possible bug) ( Donovan Brooke 2004)
  5. Re: Large Database Issue (possible bug) ( charles kline 2004)
  6. Large Database Issue (possible bug) ( Jason Sofonia 2004)
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)