[carts] and databases

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 11886
interpreted = N
texte = OK so I messed up when I first got started using WebCat2.0 and created a database that doesn't use a [cart] to create a unique record ID.What happened is that somebody used the back button and then went foreward using the html and created to identical records based on a name. If they would have started at my add page entry point I have a checker there to prevent this....but oh well it happened. When we tried to delete these records both with the same name it hung webcat. So what I want to do is go back this weekend and import the database into FilemakerPro and add a field that in the future will be a [cart] number so this problem never occurs again. This is all in a database not used for shopping.So can I just make the field where the [cart] value will go and just fill each recored like 1,2,3,4,5,6 and so forth for these 225 some odd records and then any new records will get the [cart] value? Anybody do this yet? Seems like it should not be a problem. Just looking for somebody elses experince who has done this.Live and Learn.=============================================== Gary Richter PanaVise Products, Inc. 7540 Colbert Dr. Reno, Nevada 89511 Ph: 702.850.2900 Fx: 702.850.2929 Email: grichter@panavise.com http://www.panavise.com =============================================== Associated Messages, from the most recent to the oldest:

    
  1. Re: [carts] and databases (grichter@panavise.com (Gary Richter) 1997)
  2. Re: [carts] and databases (Grant Hulbert 1997)
  3. [carts] and databases (grichter@panavise.com (Gary Richter) 1997)
OK so I messed up when I first got started using WebCat2.0 and created a database that doesn't use a [cart] to create a unique record ID.What happened is that somebody used the back button and then went foreward using the html and created to identical records based on a name. If they would have started at my add page entry point I have a checker there to prevent this....but oh well it happened. When we tried to delete these records both with the same name it hung webcat. So what I want to do is go back this weekend and import the database into FilemakerPro and add a field that in the future will be a [cart] number so this problem never occurs again. This is all in a database not used for shopping.So can I just make the field where the [cart] value will go and just fill each recored like 1,2,3,4,5,6 and so forth for these 225 some odd records and then any new records will get the [cart] value? Anybody do this yet? Seems like it should not be a problem. Just looking for somebody elses experince who has done this.Live and Learn.=============================================== Gary Richter PanaVise Products, Inc. 7540 Colbert Dr. Reno, Nevada 89511 Ph: 702.850.2900 Fx: 702.850.2929 Email: grichter@panavise.com http://www.panavise.com =============================================== grichter@panavise.com (Gary Richter)

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:

Blasted shownext (request for 4.0) (1998) Configuring E-mail (1997) problems with 2 tags shakur (1997) Adding Header Values with [SetHeader] (1998) Multiple catalog databases and showcart (1997) Navigator 4.01 (1997) I'm new be kind (1997) WebCatalog2 Feature Feedback (1996) Verifying both name and password (was: THANKS) (1997) Cart Template (1997) WebCat2b13MacPlugin - nested [xxx] contexts (1997) URL encoding -- still a problem (1998) Spawn doesn't work as advertised ... (2000) Sorting by date (1997) Suggestions for Topics to be covered in an Advanced WebDNACourse... (1998) Anyone running WebMerchant 4.0? (2000) 2nd WebCatalog2 Feature Request (1996) Help name our technology! I found it (1997) [WebDNA] Script to start/stop proftpd (2015) Search wbrk (repost) (2001)