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:
[TCPConnect] questions/problems (2001)
Using Plug-In while running 1.6.1 (1997)
Why did this copyfile stop working? (2004)
help with grep (2008)
OT : Affiliate Schemes (2002)
RE: Languages (1997)
RAM variables (1997)
Robert Minor duplicate mail (1997)
Where is eudora plugin? (1998)
Upgrading from version (1998)
The code, one more time. (2003)
Associative lookup style? + bit more (1997)
[WebDNA] Triggers issue, or sendmail? (2012)
syntax question, not in online refernce (1997)
Re:2nd WebCatalog2 Feature Request (1996)
Possible Bug in 2.0b15.acgi (1997)
primer/tutorial question (2004)
# fields limited? (1997)
WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997)
Windows 2000 Server & Webcatalog 3.x (2000)