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:
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:
E-Mailer (WebCatb15acgiMac) (1997)
Re[2]: when is failing to [URL]ize values in a comparison ri (1999)
[searchString] (1997)
OT : Site speed feedback (2002)
WebCat B13 Mac CGI -- Frames question (1997)
[ShowNext] feature in 2.0 (1997)
Webcat2, WebCommerce, Mod 10 etc. (1997)
For you Unix gurus [OT] (2002)
WebCat2 - many [carts] on one template page? (1997)
WebDNA Solutions ... sorry! (1997)
[WebDNA] parsing xml (2010)
[WebDNA] why this error when using [shownext] with a [table]? (2009)
Event ticketing code? (2000)
New command suggestion (1997)
Authenticate (1997)
Cookies (1999)
Date Bug (1998)
Multiple prices (1997)
Faxing orders in place of email (1997)
Re[2]: 2nd WebCatalog2 Feature Request (1996)