Re: using listfiles to build a database? more

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 27486
interpreted = N
texte = Ken,thank you for the suggestions. The uniquness I was looking for was in building the initial database fromt he existing files (over 6000 at last check). I was hoping to use [cart] with [listfiles] to create a unique ID for each file. That as many on the list have shown that it won't work.The files that would be eventually added would be added one at a time by the publisher of that document. They would have to enter some basic information about the document at entry time so using [cart] there would be appropriate.Thanks!Thu, 10 Feb 2000 23:52:00 -1000>>I want uniqueness, but the idea is to create this database from the files I >>have, then more files (if we go with a WebCat based solution) will be added, >>on the order of about 50 per day. The new files that will be added would use >>the [cart] to ensure uniqueness as describe in the docs. >> >>I would imagine that [cart] can't guarantee uniqueness if it wasn't used in >>the first place to create the numbers. > > >Actualluy, the [cart] tag can *easily* guarantee uniqueness if you: > >1- Do not pass a [cart] value into the page, and if you ... >2- Add the [cart] value to only one record per page. > >You seem to think you need to process more than one record per page. Why? >I would approach it from a different angle, such as processing only one >record per page, like this: > >I would write my code so that it checks the db for records having blank >values in the specified field. If it finds any matches, it then retrieve >only ONE of those records, and replaces the blank field value in that >record with the [cart] value ... > >... then after the replace is performed, my code would redirect the >visitor to the same page again -- which of course will replace a blank >field value from another record with a different [cart] value, then >redirect to the same page again -- and again, and again, and again -- >until it has run thru all the records with blank values in that field. > >Then when it cannot find any more records with blank values in the >specified field, it does *not* redirect again, instead it simply posts a >message on the page saying something like: > >I'm done adding unique values to all the records that had blank values >in them, so you can relax until tomorrow. > >And of course, you should be able to automate this by using triggers, or >else you can call this page manually every day, after you have added the >50 new records with blank values to the database. > >:) > >================================ >Kenneth Grome, WebDNA Consultant >808-737-6499, http://webdna.net >================================ ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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 Associated Messages, from the most recent to the oldest:

    
  1. Re: using listfiles to build a database? more (Dale Therio 2000)
  2. Re: using listfiles to build a database? more (Kenneth Grome 2000)
  3. Re: using listfiles to build a database? more (Therio, Dale 2000)
  4. Re: using listfiles to build a database? more (Kenneth Grome 2000)
  5. Re: using listfiles to build a database? more (WebDNA Support 2000)
  6. Re: using listfiles to build a database? more (Joseph D'Andrea 2000)
  7. Re: using listfiles to build a database? more (Dale Therio 2000)
  8. Re: using listfiles to build a database? more (Michael O Shea 2000)
  9. Re: using listfiles to build a database? more (Dale Therio 2000)
  10. Re: using listfiles to build a database? more (Michael O Shea 2000)
  11. Re: using listfiles to build a database? more (Michael O Shea 2000)
  12. Re: using listfiles to build a database? more (Therio, Dale 2000)
  13. Re: using listfiles to build a database? more (Dale Therio 2000)
Ken,thank you for the suggestions. The uniquness I was looking for was in building the initial database fromt he existing files (over 6000 at last check). I was hoping to use [cart] with [listfiles] to create a unique ID for each file. That as many on the list have shown that it won't work.The files that would be eventually added would be added one at a time by the publisher of that document. They would have to enter some basic information about the document at entry time so using [cart] there would be appropriate.Thanks!Thu, 10 Feb 2000 23:52:00 -1000>>I want uniqueness, but the idea is to create this database from the files I >>have, then more files (if we go with a WebCat based solution) will be added, >>on the order of about 50 per day. The new files that will be added would use >>the [cart] to ensure uniqueness as describe in the docs. >> >>I would imagine that [cart] can't guarantee uniqueness if it wasn't used in >>the first place to create the numbers. > > >Actualluy, the [cart] tag can *easily* guarantee uniqueness if you: > >1- Do not pass a [cart] value into the page, and if you ... >2- Add the [cart] value to only one record per page. > >You seem to think you need to process more than one record per page. Why? >I would approach it from a different angle, such as processing only one >record per page, like this: > >I would write my code so that it checks the db for records having blank >values in the specified field. If it finds any matches, it then retrieve >only ONE of those records, and replaces the blank field value in that >record with the [cart] value ... > >... then after the replace is performed, my code would redirect the >visitor to the same page again -- which of course will replace a blank >field value from another record with a different [cart] value, then >redirect to the same page again -- and again, and again, and again -- >until it has run thru all the records with blank values in that field. > >Then when it cannot find any more records with blank values in the >specified field, it does *not* redirect again, instead it simply posts a >message on the page saying something like: > >I'm done adding unique values to all the records that had blank values >in them, so you can relax until tomorrow. > >And of course, you should be able to automate this by using triggers, or >else you can call this page manually every day, after you have added the >50 new records with blank values to the database. > >:) > >================================ >Kenneth Grome, WebDNA Consultant >808-737-6499, http://webdna.net >================================ ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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 Dale Therio

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:

Re:2nd WebCatalog2 Feature Request (1996) Size limit for tmpl editor ? (1997) HELP WITH DATES (1997) ShowNext - HELP! (2000) Warning: Mac OS X 10.2.4 Update Overwrites Apache's (2003) Running _every_ page through WebCat ? (1997) Webcat/Webmerchant (1998) can pull down menu do a ONCHANGE= without Java script? (2000) I'm new be kind (1997) Session Number (1998) [WebDNA] The Single-Vendor Commercial Open Source Business Model for WebDNA (2012) Can this be done? (1997) Shopping cart not being assigned (1999) 5.0 Pricing (2003) PIXO support (1997) Page authenticating when not supposed to (2003) [WebDNA] grep question (2009) Re:no [search] with NT (1997) [writefile] (1997) No Data Results (1997)