Re: Large Database Issue (possible bug)

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 57473
interpreted = N
texte = >> >>Here is an example of the code I'm using that will break the database file. Searches don't change or break anything. It simply finds and displays data. If the data is changed, it's probably because you use Replace or Append somewhere else, possibly on the same template as the search. There's no bug in the WebDNA search. The bug is in code you haven't shown. >[search db=../database.db&eqIDdatarq=[ID]&PointIDsumm=T&asPointIDsort=1] >[founditems] >[lookup db=../ PointIDs.db&lookinfield=PointID&value=[PointID]&returnfield=Description] >[/founditems] >[/search] There's no reason to summ PointID when you're not using it as a search parameter. You're finding all instances of ID that equal [ID]. If this is unique, you'll get only one item returned. If it's not unique, you'll get all instances of it returned. In either event, PointIDsumm is useless in the code shown. If ID is unique, try this: [lookup db=../ PointIDs.db&lookinfield=PointID&value=[!] [/!][lookup db=../database.db&lookinfield=ID&value=[ID]&returnfield=PointID][!] [/!]&returnfield=Description] If ID is not unique, try this: [search db=../database.db&eqIDdatarq=[ID]&IDsumm=T&asPointIDsort=1] [founditems] [search db=../database.db&eqIDdatarq=[ID]&eqPointIDdatarq=[PointID]&PointIDsumm=T] [founditems] [lookup db=../ PointIDs.db&lookinfield=PointID&value=[PointID]&returnfield=Description] [/founditems] [/search] [/founditems] [/search] > >You need to add "&IDtype=num" to your search for one. I doubt its a bug with WebDNA. Nothing says the ID is a number. Glenn ------------------------------------------------------------- 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)
>> >>Here is an example of the code I'm using that will break the database file. Searches don't change or break anything. It simply finds and displays data. If the data is changed, it's probably because you use Replace or Append somewhere else, possibly on the same template as the search. There's no bug in the WebDNA search. The bug is in code you haven't shown. >[search db=../database.db&eqIDdatarq=[ID]&PointIDsumm=T&asPointIDsort=1] >[founditems] >[lookup db=../ PointIDs.db&lookinfield=PointID&value=[PointID]&returnfield=Description] >[/founditems] >[/search] There's no reason to summ PointID when you're not using it as a search parameter. You're finding all instances of ID that equal [ID]. If this is unique, you'll get only one item returned. If it's not unique, you'll get all instances of it returned. In either event, PointIDsumm is useless in the code shown. If ID is unique, try this: [lookup db=../ PointIDs.db&lookinfield=PointID&value=[!] [/!][lookup db=../database.db&lookinfield=ID&value=[ID]&returnfield=PointID][!] [/!]&returnfield=Description] If ID is not unique, try this: [search db=../database.db&eqIDdatarq=[ID]&IDsumm=T&asPointIDsort=1] [founditems] [search db=../database.db&eqIDdatarq=[ID]&eqPointIDdatarq=[PointID]&PointIDsumm=T] [founditems] [lookup db=../ PointIDs.db&lookinfield=PointID&value=[PointID]&returnfield=Description] [/founditems] [/search] [/founditems] [/search] > >You need to add "&IDtype=num" to your search for one. I doubt its a bug with WebDNA. Nothing says the ID is a number. Glenn ------------------------------------------------------------- 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/ Glenn Busbin

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:

formatting a number (1999) [convertchars] (2000) [TaxableTotal] - not working with AOL and IE (1997) Sku numbers (1997) splitting numbers in webDNA? (1997) [WebDNA] What does PHP(5) has, that Webdna hasn't (2009) [carts] and databases (1997) WebCat2 several catalogs? (1997) PSC recommends what date format yr 2000??? (1997) Permision deny. (2005) Further on formula.db failure to calculate shipCost (1997) WebCatalog 2.0 b 15 mac (1997) method of payment (1997) WebCat for Unix?? (1997) RequiredFields template (1997) Kaaaaahhhhhhhnnnnnnn! (1997) tcpconnect/tcpsend frustrations (2002) PCS Frames (1997) WebDNA maxing out processor / Strange intermittent WebDNA (2008) multiple search commands (1997)