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:
Multiple prices (1997)
Great product and great job ! (1997)
[WebDNA] Send results to more pages? (2011)
woops - speed results - right subject (2002)
displaying New products (using [date]) (1997)
Credit Card Number checking (1997)
WebStar Image Cache? (2003)
HELP WITH DATES (1997)
WCS Newbie question (1997)
Email Formatting and Encryption (1998)
[shownext] (1998)
Bug? (1997)
ImageMagick and text (2004)
WebCatalog as a ListServ (1998)
WebCat and image maps (1997)
when is date system date or order date? (1997)
For those of you not on the WebCatalog Beta... (1997)
Where's Cart Created ? (1997)
Cart doesn't interpret tag! (1997)
Running _every_ page through WebCat ? (1997)