Re: using listfiles to build a database? more
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 27340
interpreted = N
texte = >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:
>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
Kenneth Grome
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:
Help! WebCat2 bug (Ben's input) (1997)
Shared databases (2003)
possible, WebCat2.0 and checkboxes-restated (1997)
not interpreting Q (2001)
RE: [WebDNA] Installation on windows 2008 server (2010)
OUTSIDE LINKS TO SHOW SHOPPING CART????????? (1998)
Date to Daze (1999)
Searching multiple Databases (1997)
Webcat2, WebCommerce, Mod 10 etc. (1997)
[WebDNA] Quick sort/results grouping Q (2008)
Frames and WebCat (1997)
webmerchant/ Mac Auth. and CC refunds (1998)
Re(2): typhoon ? (2003)
Deleting with contexts (2001)
Cleaner URLs (2003)
Processing all html files through WebCat or Typhoon (1998)
unsubscribe (1997)
Format question WC Mac f3 (1997)
Re:HELP - NONE STOP DIGESTS. Digest for 4/24/97) (1997)
America Online Issues (1998)