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:
AppleScript question (1997)
Trigger date/month/year setting question (2002)
Teaching Help! (2000)
FlushDatabase Suggestion (1998)
all db's in one folder and protected (1998)
How can I record purchases to a database? (1998)
WebCat2final1 crashes (1997)
Re:2nd WebCatalog2 Feature Request (1996)
'does not contain' operator needed ... (1997)
Question about replacing words (1998)
All questions are welcome on this list (1997)
Re:Subcription Sales w/WebCatalog (1999)
can WC render sites out? (1997)
SERIAL NUMBER PROBLEM *AGAIN*!!! (1998)
Imagemagick, webdna, etc (2006)
Where is eudora plugin? (1998)
WebCatalog 402rc2 is now available (2001)
Running WebCat from a CD-ROM (1997)
Encyption mail was Suggestions for Topics ... (1998)
Re[2]: What am I doing wrong? (2000)