[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:

html delivery (1997) Help formatting search results w/ table (1997) File commands and Wild Cards ?? (1998) Running _every_ page through WebCat ? (1997) Country & Ship-to address & other fields ? (1997) Setheader question (1999) [WebDNA] issues with WEBDNA on Server 2008 (2009) WebDNA Programmer looking for a new job - again! (2002) PCS Frames (1997) Clearing orders and database help! (1997) cart (1997) international time (1997) formulas.db problem solved (1998) Looking for a host (1997) Can't load tmpl files (1997) Max Record length restated as maybe bug (1997) Comments in db? (1997) Can this be done? (1997) Formulas.db + Users.db (1997) Practice runs ? (1997)