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

Banner Ad Server Solutions Using WEbDNA (2000) Forms Search Questions (1997) Shorthand for command args (1998) RE: WebCatalog2 for NT Beta Request (1997) Can I determine where they are coming from? (2000) Talk List Suggestions (1997) orderfile and setlineitems (1998) How to get shownext to just shownext once (1997) [format 40s]text[/format] doesn't work (1997) [shell]? (2000) [WebDNA] EMailFolder/ (2016) HTML mapped to WebCat (2001) Re:Copyright ? (1997) Version 4? (2000) WebCat2 several catalogs? (1997) Submit buttons not working.... (1999) File commands and Wild Cards ?? (1998) French Webcat User (2002) WC2.0 Memory Requirements (1997) Problem with CC problem ? (1997)