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:
Encrypted links ... (2000)
SSL and reg web* (1997)
Date Formats (1997)
WebCat b13 CGI -shownext- (1997)
Error:Too many nested [xxx] contexts (1997)
SiteEdit (1999)
listfields for a table (2007)
Orders to FMPro (2005)
when is date system date or order date? (1997)
Emailer setup (1997)
fckeditor in Browswer html editor (2005)
eBay API thru webDNA (2004)
Moment of Thanks (1997)
authorize.net CC processing (was WC on Mac OS X or Mac OS (2001)
database paths/names, and a typo (1997)
[HIDEIF] inside [FOUNDITEM] (1997)
FREE Stuff .. (2003)
taxTotal, grandTotal (1997)
emailer (1997)
Show next 2 examples that work (1997)