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:
>> >>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:
Explorer 3.0/ Access Denied! (1997)
how to check for no value while using [URL] to prevent cr (1999)
Cookies (1999)
searching within same page (2000)
Looking For WebCatalog Migration Assistance (2003)
[WebDNA] Searching Possible Bug (2009)
ANother SHOWIF problem (1997)
ImageMagick and [shell] (2003)
Force leading zeros (1998)
Multiple prices (1997)
[ShowNext] feature in 2.0 (1997)
$Quit, $CloseDatabase corrections (1997)
WebCatalog for Postcards ? (1997)
Outsourcing partnership ... (2005)
Most Recent version of WebDNA For RH ES (2006)
WebCat2b12plugin - [search] is broken ... not! (1997)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
truncating email part II (1997)
tcpconnect timeout with Authorizenet (2003)
WebCat2: Items xx to xx shown, etc. (1997)