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:

Adding Header Values with [SetHeader] (1998) Closest non matching search (2004) [WebDNA] reverse rank=off (2008) WebMerchant Problem (1999) Two prices in shoppingcart? (1997) Bannerad Demo (1998) Nested search (1997) taxRate is fine but taxTotal isn't (1997) ConvertChars request (1999) autosensing lanague selection (1997) writefile - continued (1997) Dr.Watson Error (1999) Nested Loops and SHOWIFs (1997) [TaxableTotal] - not working with AOL and IE (1997) Showif for mulitple variations (1997) can WC render sites out? (1997) PCS Frames-Default page is solution! (1997) WebCat and image maps (1997) Stat analyzer (1997) problems with 2 tags (1997)