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:
REPOST: The old multiple selection bit (2000)
WebCat editing, SiteGuard & SiteEdit (1997)
Using Plug-In while running 1.6.1 (1997)
question: webmerchant connection (1997)
WebCat2final1 crashes (1997)
Web Catalog vs. ICAT (1997)
Problems with [Search] param - Mac Plugin b15 (1997)
Server Freeze (1998)
WebCat2 - [format thousands] (1997)
test (2001)
Forcing a NEWCART (1997)
WebCat2 - [format thousands] (1997)
Another bug to squash (WebCat2b13 Mac .acgi) (1997)
Almost a there but..bye bye NetCloak (1997)
Sending Email (2004)
[WebDNA] [lookup] fails when using [url] to wrap a value for potential "&" char? (2009)
Exclamation point (1997)
RePost: NAT and the CART (1999)
Looking for a Manual (1997)
Text data with spaces in them... (1997)