Re: Table code broken?

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 60383
interpreted = N
texte = OK, these are identical in structure except for the directory or the number of dates. I assure you that there is a /Orders/ path on this server (with fewer than 10k order files in it). If I limit the number of entries to the table by restricting the date (SET 2 below), the problem disappears for the /Orders/ folder. See the three sets of code below for what works/what doesn't. Is there a limit to either the number of entries in a table or the size of a table? There's no limit mentioned in the docs and there should be plenty of room to handle this on the server. Thanks, Bill SET 1 THIS WORKS: [table name=tab&fields=ONO,DACR][/table] [listfiles path=/] [append table=tab]ONO=[url][filename][/url]&DACR=[url][moddate][/url][/append] [/listfiles] [search table=tab&neDACRdatarq=[blank]] [founditems][ONO] [DACR]
[/founditems] [/search] SET 2 THIS DATE RESTRICTED VERSION WORKS: [table name=tab&fields=ONO,DACR][/table] [listfiles path=/Orders] [showif [math]{[moddate]}[/math]>[math]{[date]}-30[/math]] [append table=tab]ONO=[url][filename][/url]&DACR=[url][moddate][/url][/append] [/showif] [/listfiles] SET 3 THIS UNRESTRICTED VERSION SHOWS NOTHING! [table name=tab&fields=ONO,DACR][/table] [listfiles path=/Orders/] [append table=tab]ONO=[url][filename][/url]&DACR=[url][moddate][/url][/append] [/listfiles] ------------------------------------------------------------- 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: Table code broken? ( Stuart Tremain 2004)
  2. Re: Table code broken? ( "Scott Anderson" 2004)
  3. Re: Table code broken? ( Stuart Tremain 2004)
  4. Re: Table code broken? ( "Scott Anderson" 2004)
  5. Re: Table code broken? ( devaulw@onebox.com 2004)
  6. Re: Table code broken? ( "Scott Anderson" 2004)
  7. Re: Table code broken? ( devaulw@onebox.com 2004)
  8. Re: Table code broken? ( "Scott Anderson" 2004)
  9. Re: Table code broken? ( "Scott Anderson" 2004)
  10. Re: Table code broken? ( Larry Hewitt 2004)
  11. Re: Table code broken? ( devaulw@onebox.com 2004)
  12. Re: Table code broken? ( devaulw@onebox.com 2004)
  13. Re: Table code broken? ( Brian Fries 2004)
  14. Table code broken? ( devaulw@onebox.com 2004)
OK, these are identical in structure except for the directory or the number of dates. I assure you that there is a /Orders/ path on this server (with fewer than 10k order files in it). If I limit the number of entries to the table by restricting the date (SET 2 below), the problem disappears for the /Orders/ folder. See the three sets of code below for what works/what doesn't. Is there a limit to either the number of entries in a table or the size of a table? There's no limit mentioned in the docs and there should be plenty of room to handle this on the server. Thanks, Bill SET 1 THIS WORKS: [table name=tab&fields=ONO,DACR][/table] [listfiles path=/] [append table=tab]ONO=[url][filename][/url]&DACR=[url][moddate][/url][/append] [/listfiles] [search table=tab&neDACRdatarq=[blank]] [founditems][ONO] [DACR]
[/founditems] [/search] SET 2 THIS DATE RESTRICTED VERSION WORKS: [table name=tab&fields=ONO,DACR][/table] [listfiles path=/Orders] [showif [math]{[moddate]}[/math]>[math]{[date]}-30[/math]] [append table=tab]ONO=[url][filename][/url]&DACR=[url][moddate][/url][/append] [/showif] [/listfiles] SET 3 THIS UNRESTRICTED VERSION SHOWS NOTHING! [table name=tab&fields=ONO,DACR][/table] [listfiles path=/Orders/] [append table=tab]ONO=[url][filename][/url]&DACR=[url][moddate][/url][/append] [/listfiles] ------------------------------------------------------------- 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/ devaulw@onebox.com

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:

possible, WebCat2.0 and checkboxes-restated (1997) emailer (1997) Web Site (2000) Summ=T Problem (1997) Upgrading old WebCat Database Files (1997) [OT] Looking for WC web dev help (2003) 2.1 Stuff (1998) Search repost: (2000) Pre-flight public flag (1997) Re1000002: Setting up shop (1997) Remove Command not working (2000) Web Catalog 2 demo (1997) MacAuthorize Problem (1998) GuestBook example (1997) shownext not showing next...still r2 (1997) NT Manual (1997) WebCat2 as a chat server? (1997) Security (1998) searchable list archive (1997) Sendmail doesn't (was Queertrons?) (1997)